Data Engineer

This is a fully remote position, open to applicants in India.

📋 Description

• Design, construct, and uphold scalable and dependable data pipelines and warehouse models.

• Develop data pipelines utilizing dbt, Python, or other ELT tools.

• Create, implement, and manage data orchestration and transformation workflows.

• Build and support intricate dbt models.

• Develop data warehouse architectures, encompassing dimension and fact tables.

• Implement Type 1 and Type 2 slowly changing dimensions.

• Oversee and execute data mart updates for downstream reporting and analytics.

• Create conformed dimensions through integration with Master Data Management systems.

• Work with life science and healthcare datasets to guarantee data quality and pertinence.

• Collaborate with cross-functional teams to convert data requirements into technical solutions.

• Partner with data analysts and data scientists to provide clean datasets.

• Work alongside engineers across Git repositories employing version control and code review practices.

⛳️ Requirements

• Bachelor’s degree (B.Tech or B.E.) in Computer Science or a related engineering field, along with equivalent practical experience.

• Advanced SQL proficiency, including the ability to write, optimize, and troubleshoot complex queries across extensive datasets.

• Strong knowledge in data warehouse development and principles, including dimensional modeling, Type 1/Type 2 SCDs, data mart updates, and conformed dimensions through MDM integration.

• Hands-on experience with ETL tools such as dbt, Python, SSIS, or PowerCenter.

• Proven track record of designing and constructing reliable, scalable, and maintainable ETL/ELT pipelines.

• Demonstrated experience collaborating with other engineers through Git across repositories.

• Availability to work with substantial overlap with US Eastern business hours.

• Experience with life science or healthcare data, including an understanding of quality and compliance factors.

• Familiarity with cloud platforms such as Azure or AWS.

• Practical experience in building and optimizing workloads in Snowflake is preferred.

• Practical experience in developing and maintaining complex dbt models, including testing and documentation, is preferred.

• Snowflake or dbt certification is preferred.

🏝️ Benefits

• Excellent and affordable medical benefits.

• Non-medical perks including Flexible Paid Time Off (PTO).

• Access to over 700+ development courses free for all employees.

• Mission-driven work focused on improving patients' lives.