NEW JOB OPENING DATA ENGINEER IN AUSTIN, TX, USA!

Job Description
*** Position requires candidates who are LOCAL TO THE AUSTIN AREA ONLY. ***

Education:
• Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience. (Preferred)

Minimum Requirements:
(Candidates must meet all minimum requirements to be considered)
• 8 years (Required): Experience developing ETL mappings and workflows using Informatica PowerCenter or IICS.
• 8 years (Required): Experience integrating data from multiple sources (Oracle, SQL Server, Excel, Access, PDF) into analytics platforms (e.g., Tableau).
• 8 years (Required): Experience writing and optimizing complex SQL queries (Snowflake or similar platforms).
• 8 years (Required): Systems analysis experience supporting data analytics, data warehousing, or performance management systems.
• 8 years (Required): Strong analytical and problem-solving skills with ability to evaluate alternative solutions.
• 8 years (Required): Experience with technical documentation, data modeling, and diagramming tools (Visio, Erwin, MS Office Suite, MS Project).
• 8 years (Required): Experience delivering enterprise software platforms used across multiple business units.
• 8 years (Required): Proven ability to write efficient, scalable, and testable code following best practices.

Preferred Qualifications:
• 6 years (Preferred): Strong written and verbal communication skills.
• 6 years (Preferred): Ability to manage multiple priorities and shifting deadlines in a fast-paced environment.
• 4 years (Preferred): Experience working in an Agile/Scrum development environment.
• 4 years (Preferred): Knowledge of data security principles, particularly in healthcare.
• 4 years (Preferred): Experience with business intelligence or data visualization ecosystems.
• 4 years (Preferred): Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.
• 4 years (Preferred): Experience in the Healthcare industry.
• 4 years (Preferred): Prior experience with HHS agencies or public sector environments.
• 4 years (Preferred): Experience handling PII/PHI-sensitive data.
• 4 years (Preferred): Experience with Python scripting for data processing or automation.
• 4 years (Preferred): Experience using JIRA or similar project tracking tools.
• 2 years (Preferred): Experience with Web Services (REST, SOAP).
• 2 years (Preferred): Experience with Java and JavaScript development.
• 2 years (Preferred): Experience building CI/CD pipelines using GitHub and GitHub Actions.
• 2 years (Preferred): Experience with MuleSoft integration platform.
• 2 years (Preferred): Experience using AI-enabled data tools (e.g., Snowflake Cortex, Informatica CLAIRE).

Summary:
• Support the Texas Health and Human Services Commission (HHSC) in developing and enhancing a centralized data integration hub within the Performance Management & Analytics System (PMAS).
• Analyze business objectives and translate them into scalable data solutions through ETL development, data modeling, and system analysis.
• Collaborate across business and technical teams to design, build, and maintain data pipelines, automation workflows, and analytics-ready datasets.
• Operate within an Agile development environment, contributing to all SDLC phases including requirements gathering, design, development, testing, and deployment.

Responsibilities:
• Analyze business objectives, user requirements, and operational procedures to identify gaps and propose data-driven solutions.
• Perform feasibility studies and cost/benefit analysis of system enhancements or new solutions.
• Design, develop, and maintain data acquisition and integration processes from multiple data sources.
• Develop and optimize complex SQL scripts and database objects (views, materialized views).
• Build and maintain ETL workflows using Informatica PowerCenter and/or IICS.
• Transform data into dimensional models for analytics and reporting.
• Collaborate with architects and engineering teams on data design, architecture, and integration strategies.
• Participate in Agile ceremonies, including sprint planning, daily stand-ups, and retrospectives.
• Perform validation and testing (integration, load, stress) of data pipelines and system outputs.
• Develop automated validation and quality assurance processes for data accuracy and completeness.
• Produce and maintain technical documentation, including system specifications, data models, and diagrams.
• Work with stakeholders to create mockups and prototypes for validation.
• Assess system capabilities, limitations, and feasibility for enhancements or new implementations.
• Support deployment, operations, and continuous improvement of the data integration hub.
• Provide troubleshooting and resolution for technical and data-related issues.
• Ensure compliance with data security and privacy standards, especially for sensitive datasets (PII/PHI).

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

Benefits:
For information and details on employment benefits offered with this position, please visit here . Should you have any questions/concerns, please contact our HR Department via our secure website .

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here .

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department .

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).