Core Skills
- Data Integration (ETL) Experts
- Expertise in Datawarehouse Development and Concepts
- Dimension/Fact
- Type 1/Type 2 SCD
- Data Mart Updates
- Conformed Dimensions via MDM Integration
- Experience with ETL Tools like DBT, Python, SSIS or PowerCenter
- Strong SQL Skills
- Snowflake Experience preferred
- DBT Experience Preferred
- Experience with Life Science/Healthcare Data
Roles and Responsibilities
- Lead a project team of 3-5 Data Engineers to design and deliver data pipelines
- Develop scalable, reliable, and efficient data pipelines using dbt, Python, or other ELT tools
- Implement and maintain scalable data orchestration and transformation, ensuring data accuracy, consistency, and timeliness
- Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions
- Work closely with data analysts and data scientists to provide them with clean and structured datasets for analysis and modeling
- Build scalable, complex DBT models
- Design and build scalable data orchestration and transformation
