Description

You will own the development and maintenance of data pipelines and ETL processes.

Responsibilities

• Develop and manage working relationships across departments for coordinated data initiatives.
• Translate business process knowledge into data transformation requirements for ETL architecture.
• Design, implement, and automate ETL flows, providing input into the overall ETL architecture.
• Investigate data to identify ETL pipeline issues, notify users, and propose solutions.
• Test ETL system code, data design, and pipelines; conduct root cause analysis on production issues.

Required Skills

• 5+ years of Data engineering experience focusing on Data Warehousing.
• 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools.
• 2+ years of experience creating pipelines in Azure Data Factory (ADF).
• 5+ years with Relational Databases (Oracle, Snowflake, SQL Server, etc.).
• 3+ years creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL.
• 2+ years experience with GitHub, SVN, or similar source control systems.
• 2+ years experience processing structured and un-structured data.
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements.
• Experience with HL7 and FHIR standards.

Preferred Skills

• 2+ years experience with Python scripting.
• 3+ years of data modeling experience in a data warehouse environment.

Key Skills

Education

Bachelor's degree