This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking an experienced Data Engineer / Systems Analyst III to support a major healthcare and data analytics initiative focused on building and enhancing a large-scale enterprise data integration hub. This role will support the design, development, automation, and optimization of complex data engineering solutions within a highly collaborative Agile environment.
Job Responsibility
Lead and contribute to Agile data engineering and systems analysis initiatives
Design, develop, and maintain complex ETL workflows and data integration processes
Acquire and integrate data from multiple enterprise and external data sources
Develop advanced Snowflake SQL scripts optimized for scalability and performance
Create dimensional data models, database views, and materialized views
Develop and automate data workflows using Informatica PowerCenter and/or Informatica IICS
Collaborate with architects, developers, analysts, and stakeholders to design optimal data solutions
Participate in sprint planning, standups, retrospectives, and other Agile ceremonies
Conduct validation, testing, troubleshooting, and performance optimization
Produce technical documentation, diagrams, specifications, and mapping documents
Assist with deployment, operations support, and ongoing platform enhancements
Support data visualization and business intelligence initiatives
Interpret changing business requirements and recommend scalable technical solutions
Requirements
8+ years of experience developing ETL mappings and workflows using Informatica PowerCenter or Informatica IICS
8+ years of experience integrating data from multiple data sources and technologies including Oracle, SQL Server, Excel, Microsoft Access, Adobe PDF
8+ years of experience designing and developing complex Snowflake SQL scripts
8+ years of experience supporting data analytics, performance management, or enterprise data warehouse initiatives
Strong analytical, troubleshooting, and systems analysis skills
Experience producing technical documentation, diagrams, and data mappings
Experience with Visio, Erwin, Microsoft Office Suite, and MS Project
Proven ability to write scalable, testable, and efficient code
Experience delivering enterprise software solutions across multiple business units
Nice to have
Experience working within Agile sprint teams
Healthcare industry experience
Experience working with PHI and PII data
Prior experience supporting HHS or government healthcare agencies
Experience with Python scripting and automation
Experience using JIRA
Knowledge of REST and SOAP web services
Experience with Java and JavaScript
Experience developing CI/CD pipelines using GitHub and GitHub Actions
Experience with MuleSoft
Exposure to AI-enabled data tools such as Snowflake Cortex, Snowflake Intelligence, Informatica Claire