Data Engineer
IntegriChain6 days ago
Remote, India or Pune, IndiaMid Level
Responsibilities
- Develop scalable and reliable data pipelines using dbt, Python, or other ELT tools.
- Design, implement, and maintain data orchestration and transformation processes.
- Build complex dbt models and develop data warehouse structures with dimension and fact tables.
- Implement Type 1 and Type 2 slowly changing dimensions and execute data mart updates.
- Build conformed dimensions through integration with Master Data Management systems.
- Apply life science and healthcare domain knowledge to improve data quality and relevance.
- Collaborate with cross-functional teams to translate data requirements into technical solutions.
- Partner with data analysts and data scientists to provide clean, structured datasets.
- Collaborate with engineers across Git repositories using version control and code review practices.
Requirements
- Bachelor’s degree in Computer Science or a related engineering discipline, or equivalent practical experience.
- Advanced SQL skills for writing, optimizing, and troubleshooting complex queries across large datasets.
- Strong expertise in data warehouse development, dimensional modeling, slowly changing dimensions, data marts, and conformed dimensions.
- Hands-on proficiency with ETL tools such as dbt, Python, SSIS, or PowerCenter.
- Experience designing and building reliable, scalable, and maintainable ETL/ELT pipelines.
- Experience working with Git across engineering repositories.
- Availability to work with meaningful overlap with US Eastern business hours.
- Experience with life science or healthcare data and its quality and compliance considerations.
- Working knowledge of cloud platforms such as Azure or AWS.
- Practical experience building and optimizing workloads in Snowflake is preferred.
- Practical experience building and maintaining complex dbt models, including testing and documentation, is preferred.
- Snowflake or dbt certification is preferred.
Benefits
- Fully remote role based in India, with working hours aligned to US Eastern Time from 9:00 AM to 5:00 PM ET, Monday through Friday.
- The role follows the US company holiday calendar rather than the Indian public holiday calendar.
- Excellent and affordable medical benefits.
- Non-medical perks including Flexible Paid Time Off.
- More than 700 free learning and development courses.
- Periodic office visits for workshops and team collaboration, with occasional international travel based on business need.
About IntegriChain
IntegriChain provides a SaaS commercialization and revenue optimization platform for biopharma manufacturers, integrating data, software, and managed services to manage market access, payer contracting, patient services, and distribution analytics. Its ICyte platform unifies key commercial, financial, and operational data and is used by more than 250 manufacturers. Founded in 2005 and headquartered in Philadelphia, the company is privately held and backed by Nordic Capital.