Opening for - Data Engineer || Austin, Texas (Hybrid || In person interview

Nexiva•Austin, TX

1d•Hybrid

About The Position

Texas Health and Human Services Commission (HHSC) is seeking an experienced Systems Analyst 3 / Data Engineer to support the continued development and enhancement of the Performance Management & Analytics System (PMAS) Data Integration Hub. This role will be responsible for designing, developing, and maintaining enterprise data integration solutions that support business intelligence, analytics, and performance management initiatives across HHSC. The selected candidate will serve as a technical leader within an Agile development team, driving data acquisition, ETL automation, data transformation, dimensional modeling, and analytics platform enhancements utilizing Informatica, Snowflake, Oracle, and Tableau technologies. This position requires strong expertise in enterprise data warehousing, ETL development, data integration, SQL optimization, and business intelligence environments, along with the ability to collaborate with architects, analysts, and stakeholders to deliver scalable and secure data solutions.

Requirements

8+ years developing ETL mappings and workflows using Informatica PowerCenter and/or IICS
8+ years integrating data from multiple sources for analytics and reporting environments
8+ years designing and developing complex, high-performance Snowflake SQL
8+ years working as a Systems Analyst on: Data Analytics Platforms, Data Warehousing Projects, Performance Management Systems
8+ years creating technical documentation, process diagrams, and system designs
8+ years planning and delivering enterprise software platforms across multiple organizational units
8+ years developing efficient, scalable, and maintainable software solutions using industry best practices
Informatica PowerCenter
Informatica Intelligent Cloud Services (IICS)
Snowflake
SQL Development & Optimization
Oracle Database
SQL Server
Tableau Data Integration
Data Warehousing Concepts
Dimensional Modeling
Data Transformation & Data Quality
Microsoft Office Suite
Microsoft Project
Visio
Erwin Data Modeling
Experience working within Agile/Scrum teams
Knowledge of healthcare data security and compliance requirements
Experience supporting Business Intelligence and Performance Metrics environments
Experience working with Personally Identifiable Information (PII) and Protected Health Information (PHI)
Healthcare industry experience
Prior experience supporting Texas HHS agencies
Python scripting and automation experience
Experience using JIRA
Experience with REST and SOAP Web Services
Java and JavaScript development experience
CI/CD pipeline development using GitHub and GitHub Actions
MuleSoft development experience
Experience with AI-enabled data tools such as: Snowflake Cortex, Snowflake Intelligence, Informatica CLAIRE
Bachelor's Degree in Computer Science, Information Systems, Business, or related field preferred
Equivalent combination of education and professional experience will be considered
Strong analytical and problem-solving skills
Excellent written and verbal communication abilities
Ability to manage multiple priorities simultaneously
Strong stakeholder engagement skills
Technical leadership and mentoring capabilities
Attention to detail and commitment to quality
Ability to work independently and collaboratively in Agile environments

Responsibilities

Design, develop, and maintain complex ETL workflows and mappings using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).
Automate acquisition and integration of data from multiple sources including: Oracle Databases, SQL Server, Excel Files, Microsoft Access Databases, Adobe PDF Sources.
Develop efficient and scalable data transformation processes supporting enterprise analytics initiatives.
Create and optimize complex Snowflake SQL scripts and database objects for performance and scalability.
Design dimensional data models and support enterprise data warehouse architecture.
Support implementation and enhancement of the HHSC Data Integration Hub.
Transform source data into enterprise dimensional models and reporting structures.
Develop database views and materialized views to support reporting and visualization requirements.
Collaborate with business stakeholders to validate performance metric requirements and analytics needs.
Support Tableau reporting and dashboard initiatives through optimized data delivery.
Analyze business requirements and translate them into technical solutions.
Lead Agile development teams through project planning, execution, and delivery.
Develop Epics, User Stories, Tasks, and technical specifications.
Conduct feasibility studies and cost-benefit analyses for proposed solutions.
Provide recommendations for system enhancements and architectural improvements.
Validate ETL processes, SQL scripts, database views, and data transformation logic.
Develop automated testing and validation processes.
Perform integration, performance, load, and stress testing activities.
Ensure data quality, integrity, and compliance standards are maintained.
Work closely with Data Architects, Developers, Analysts, and Business Stakeholders.
Participate in Agile ceremonies including: Sprint Planning, Daily Standups, Sprint Reviews, Retrospectives.
Develop technical documentation, process diagrams, architecture diagrams, and implementation guides.
Create prototypes and mockups for stakeholder validation.
Support production deployment activities and post-implementation operations.
Troubleshoot technical issues and implement corrective actions.
Maintain and enhance existing data integration solutions.
Support ongoing system improvements and optimization initiatives.