ELT Analyst - Engineer

Description:

Date Posted: 07/07/2025

Hiring Organization: Rose International

Position Number: 485078

Industry: Government

Job Title: ELT Analyst - Engineer

Job Location: Austin, TX, USA, 78751

Work Model: Hybrid

Work Model Details: 2 days on-site, 3 days remote

Shift: M-F, 8-5

Employment Type: Temporary

FT/PT: Full-Time

Estimated Duration (In months): 13

Min Hourly Rate ($): 75.00

Max Hourly Rate ($): 85.50

Must Have Skills/Attributes: ERWIN, ETL, Informatica, MS Access, MS Excel, MS Office, Oracle, Python, Snowflake, SQL Server, Tableau, Technical Writing, VISIO

Nice To Have Skills/Attributes: State Agency experience

Experience Desired: Developing mappings and workflows to automate ETL processes (8 yrs); Designing and developing complex SQL scripts (8 yrs); Technical writing and diagraming skills, including modeling & mapping (8 yrs)

Job Description

Candidates must already reside in the Austin, TX area

Minimum Requirements:

• 8+ years of experience with Informatica IICS, IDMC, or PowerCenter for ETL development.

• 8+ years of experience integrating data from diverse sources (Snowflake, Oracle, SQL Server, Excel, Access, PDF) for Tableau reporting.

• 8+ years of experience writing and optimizing complex SQL scripts.

• 8+ years of experience in data analytics, performance management, or data warehousing projects.

• 8+ years of experience with technical writing, diagramming (Visio, Erwin), and Microsoft Office tools.

• 8+ years of experience developing Python scripts for data testing and automation.

• 8+ years of experience identifying and tracking defects throughout the development lifecycle.

• 8+ years of experience collaborating with development teams to improve quality processes.

• 8+ years of experience developing and executing test plans and scripts.

• Strong analytical, organizational, and problem-solving skills.

• Ability to work independently and collaboratively in a team environment.

• High attention to detail and ability to manage multiple tasks.

• Commitment to confidentiality and discretion when handling sensitive data.

Preferred Experience:

• Experience enhancing automation frameworks and expanding test coverage.

• Experience with automated regression and functional test suites, ideally AI-enhanced.

• Experience working with AI platforms or validating AI-integrated products.

• Familiarity with observability and testing infrastructure at scale.

• Demonstrated innovation in software quality or test automation.

Summary:

• Seeking an experienced ETL Analyst/Engineer to support the Health and Human Services Commission (HHSC).

• The selected candidate will contribute to the ongoing development and enhancement of the HHS Data Integration Hub; a critical initiative aimed at integrating and automating data flows across multiple systems.

• The role involves working within an Agile development team to design, develop, and implement ETL processes, complex SQL scripts, and automation pipelines using Informatica IICS/PowerCenter, while supporting data visualization and reporting needs through platforms like Tableau.

Key Responsibilities:

• Design, develop, and automate ETL processes using Informatica IICS or PowerCenter.

• Acquire and integrate data from multiple sources including Snowflake, Oracle, SQL Server, Excel, Access, and PDF.

• Develop and optimize complex SQL scripts for data transformation and dimensional modeling.

• Collaborate with data engineers and architects to implement scalable data solutions.

• Validate and verify data pipelines, SQL scripts, and Informatica workflows.

• Participate in Agile ceremonies and contribute to sprint planning and execution.

• Enhance and maintain a Java-based web portal for Tableau dashboards.

• Develop mockups and work with stakeholders for validation and feedback.

• Create and maintain technical documentation, diagrams, and specifications.

• Support testing efforts including integration, load, and stress testing.

• Assist with tool configuration and implementation as needed.

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.