Systems Analyst
Not Disclosed•ContractorHybrid
location_on9109, Atwater Cove, Travis County, Texas, 78733, United States
About the Mission
The Texas Health and Human Services Commission (HHSC) is advancing its Performance Management & Analytics System (PMAS) by developing a robust data integration hub. This initiative aims to unify data from diverse sources to drive performance metrics and analytics, ensuring the state's health and human services are supported by accurate, timely, and actionable insights.
About the Role
As a Systems Analyst 3, you will serve as a technical leader within an agile development team dedicated to the design, development, and implementation of this critical data infrastructure. Your work will bridge the gap between complex data acquisition and high-level business intelligence, utilizing an agile methodology to manage the full software development life cycle (SDLC).
In this hybrid role based in Austin, you will collaborate closely with architects and the Data Engineering Team to define optimal data designs and acquisition strategies. You will be responsible for leading sprint ceremonies, interpreting evolving business requirements, and proposing technical enhancements. The day-to-day involves transforming raw data from sources like Oracle, SQL Server, and Excel into dimensional models using complex SQL scripts and Informatica automation. You will also verify and validate these processes, ensuring data integrity for downstream visualization tools like Tableau.
Hiring Process & Application
To be considered for this contract opportunity, please submit your resume along with three professional references. Ideally, these references should include a supervisor, providing their name, title, company, email, and phone number. Selected candidates will undergo a background check prior to placement.
Equal Opportunity & Culture
The Texas Health and Human Services Commission is an equal opportunity employer committed to a diverse workforce. We welcome applications from all qualified candidates regardless of background, ensuring a fair and inclusive hiring process for our state's critical services.
Work location
Work model: Hybrid
9109, Atwater Cove, Travis County, Texas, 78733, United States
Texas
Key Responsibilities
- check_circleDevelop automation workflows using Informatica Power Center or IICS
- check_circleCreate complex SQL scripts to transform source data into dimensional models
- check_circleDesign, develop, and implement a data integration hub using agile methodology
- check_circleCollaborate with architects to design optimal data acquisition strategies
- check_circleProduce technical specifications, diagrams, and documentation for DD&I efforts
- check_circleInterpret business requirements to propose system enhancements and changes
- check_circleLead agile development teams through project sprints and ceremonies
- check_circleVerify and validate SQL scripts, automation, and database views
Requirements
- verified8 years ETL experience using Informatica Power Center or IICS
- verified8 years data integration from Oracle, SQL Server, Excel, Access, Adobe PDF
- verified8 years Snowflake SQL scripting
- verified8 years system analyst experience in data analytics or data warehousing
- verified8 years technical writing and diagraming with Visio, Erwin, MS Office, MS Project
- verified8 years software platform planning and delivery
- verified8 years software development best practices
- verifiedBachelor's degree in CS, IS, Business or equivalent
- verified6 years oral and written communication skills
- verified6 years agile sprint team experience
- verified4 years healthcare data security principles
Nice to Have
Excellent oral and written communication skills. Ability to effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments. Experience on an agile sprint team. Understanding of security principles and how they apply to healthcare data. Experience with state of the art software components for a performance metrics data visualization or business intelligence environment. Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience. Prior experience in the Healthcare Industry. Prior experience with an HHS agency. Prior experience working with PII or PHI data. Experience designing and developing scripts using Python. Experience with JIRA software. Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.). Experience designing and developing code using Java and JavaScript. Experience developing CI/CD pipelines with GitHub and Git Actions. Experience as a Mulesoft developer. Experience developing using AI tools such as Snowflake Cortex and Intelligence, and/or Informatica Claire.
Similar Job Opportunities
Skills, education and keywords
Skills: Agile Methodology, SDLC, SQL, Oracle, Informatica Power Center, Informatica Iics, Snowflake, Etl, Data Warehousing, Visio.
Education: Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
Frequently asked questions about Systems Analyst at Phoenix Convention Center & Venues
What does a Systems Analyst at Phoenix Convention Center & Venues do?expand_more
A Systems Analyst at Phoenix Convention Center & Venues is responsible for the following: Develop automation workflows using Informatica Power Center or IICS; Create complex SQL scripts to transform source data into dimensional models; Design, develop, and implement a data integration hub using agile methodology; and Collaborate with architects to design optimal data acquisition strategies.
What are the requirements for this Systems Analyst role?expand_more
Phoenix Convention Center & Venues is looking for candidates who meet the following requirements: 8 years ETL experience using Informatica Power Center or IICS; 8 years data integration from Oracle, SQL Server, Excel, Access, Adobe PDF; 8 years Snowflake SQL scripting; 8 years system analyst experience in data analytics or data warehousing; 8 years technical writing and diagraming with Visio, Erwin, MS Office, MS Project; and 8 years software platform planning and delivery.
Where is the Systems Analyst role at Phoenix Convention Center & Venues located?expand_more
Systems Analyst at Phoenix Convention Center & Venues is based in 9109, Atwater Cove, Travis County, Texas, 78733, United States. This is a hybrid role.
Is this Systems Analyst job remote, hybrid, or on-site?expand_more
Phoenix Convention Center & Venues has listed this Systems Analyst role as hybrid.
How much experience is required for this Systems Analyst role?expand_more
Systems Analyst at Phoenix Convention Center & Venues typically requires 8+ years of relevant experience at the senior level.
What skills do you need for the Systems Analyst role at Phoenix Convention Center & Venues?expand_more
Key skills for Systems Analyst at Phoenix Convention Center & Venues include Agile Methodology; SDLC; SQL; Oracle; Informatica Power Center; Informatica Iics; Snowflake; and Etl.
What education is required for Systems Analyst at Phoenix Convention Center & Venues?expand_more
Educational requirements for this role: Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
What category does the Systems Analyst role belong to?expand_more
Systems Analyst at Phoenix Convention Center & Venues is part of the it job category on Recrutus.