Systems Analyst
Not Disclosed•ContractorHybrid
location_on4502, Avenue G, North Loop, Austin, Travis County, Texas, 78751, 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 across the state's healthcare infrastructure.
About the Role
As a Systems Analyst 3, you will serve as a technical leader within an agile development team, guiding the design, development, and implementation of the PMAS data integration hub. This role is pivotal in transforming raw data into actionable insights, utilizing an agile methodology aligned with HHSC's current standards.
Your day-to-day involves orchestrating the full software development lifecycle (SDLC). You will lead efforts to validate performance metric requirements, create user stories, and engineer complex SQL scripts to transform source data into dimensional models within Oracle. A significant portion of your work will focus on automating data acquisition using Informatica Power Center or IICS, ensuring seamless integration from sources such as Oracle, SQL Server, Excel, and Adobe PDF.
Beyond development, you will collaborate closely with architects and the Data Engineering Team to optimize data design and verification strategies. You will participate in all sprint ceremonies, interpret evolving business requirements to propose enhancements, and produce technical specifications and diagrams to support the project. The role requires a balance of hands-on technical execution and strategic leadership to ensure the hub meets the rigorous demands of a healthcare environment.
Hiring Process
Interested candidates should submit their resume along with three professional references, preferably supervisors, including their name, title, company, email, and phone number. Selected candidates will undergo a background check prior to placement. The engagement is expected to commence on September 1, 2026, and run through August 31, 2027.
Location and Work Model
This is a hybrid position based in Austin, Texas, with primary work conducted at 4601 W Guadalupe St. While the role includes telework options, on-site presence is required. Candidates must be prepared to work normal business hours (Monday–Friday, 8:00 AM–5:00 PM), with potential flexibility for evenings, weekends, or holidays as requested by the agency.
Equal Opportunity
The Texas Health and Human Services Commission is an equal opportunity employer committed to diversity and inclusion in its workforce.
Work location
Work model: Hybrid
4502, Avenue G, North Loop, Austin, Travis County, Texas, 78751, United States
Austin, Texas
Key Responsibilities
- check_circleDesign and implement infrastructure for the data integration hub within the PMAS system
- check_circleCreate automation workflows using Informatica Power Center or IICS for data acquisition
- check_circleDevelop complex SQL scripts to transform source data into dimensional models and views
- check_circleCollaborate with architects to design optimal data acquisition strategies and integration designs
- check_circleLead agile development teams through all SDLC phases including sprint ceremonies
- check_circleProduce and maintain technical specifications, diagrams, and documentation for DD&I efforts
- check_circleInterpret business requirements to propose enhancements and changes to data solutions
- check_circleVerify and validate SQL scripts, automation workflows, 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 script development
- 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 Computer Science, Information Systems, Business or equivalent
- verifiedBackground check required
- verifiedWork authorization for Texas Health and Human Services Commission
- verified
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
In this Systems Analyst at Phoenix Convention Center & Venues role, you will design and implement infrastructure for the data integration hub within the pmas system; create automation workflows using informatica power center or iics for data acquisition; develop complex sql scripts to transform source data into dimensional models and views; and collaborate with architects to design optimal data acquisition strategies and integration designs.
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 script development; 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 4502, Avenue G, North Loop, Austin, Travis County, Texas, 78751, 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.