Data Engineer

IntegriChain; Maharashtra; Remote; INR 1,400,000 - 2,200,000; Full time

Benefits offered by this job

Medical benefits

Flexible PTO

700+ development courses

Job summary

IntegriChain is seeking a Data Engineer to design, build, and maintain scalable data pipelines and warehouse models that turn life science data into clean datasets powering analytics and decision-making.

You’ll work remotely from India with hours overlapping US Eastern time, collaborating with cross-functional teams to implement dbt, Python, SQL, and Snowflake, delivering reliable, governance-focused data solutions.

Qualifications

• Bachelor’s degree in Computer Science or related engineering discipline or equivalent practical experience
• Advanced SQL skills for large datasets, optimization and troubleshooting
• Strong data warehouse knowledge including dimensional modeling and SCDs (Type 1/Type 2)
• Hands-on experience with ETL/ELT tools such as dbt, Python, SSIS, or PowerCenter
• Experience with Git and collaboration across repositories
• Willingness to overlap with US Eastern business hours
• Experience with life sciences/healthcare data and data quality/compliance considerations
• Familiarity with cloud platforms such as Azure or AWS
• Nice-to-have Snowflake and dbt certifications

Responsibilities

• Design, build, and maintain scalable data pipelines and warehouse models
• Develop and maintain complex dbt models and data marts
• Implement Type 1 and Type 2 SCDs to capture historical data
• Build conformed dimensions and integrate with MDM systems
• Collaborate across teams to translate data requirements into technical solutions
• Partner with data analysts and data scientists to deliver clean datasets for analysis
• Maintain code quality with Git and code reviews
• Work with life science/healthcare datasets ensuring data quality and compliance

Skills

Advanced SQL

ETL/ELT

Git collaboration

Cloud platforms (Azure/AWS)

Data warehousing

Education

Bachelor’s degree in CS or related engineering

Tools

dbt

Python

SSIS

PowerCenter

Snowflake

Job description

IntegriChain is the data and application backbone for market access departments of Life Sciences manufacturers. More than 250 manufacturers rely on our ICyte Platform to orchestrate commercial and government payer contracting, patient services, and distribution channels. ICyte unites the financial, operational, and commercial data sets required to support therapy access in the era of specialty and precision medicine, freeing our customers’ best talent to focus on data-driven decisions rather than labor-intensive processes.

We are headquartered in Philadelphia, PA (USA), with offices in Pune, India; and Medellín, Colombia. We offer a hybrid working environment, with periodic visits to office locations for workshops and team collaboration, and occasional international travel based on business need. For more information, visit www.integrichain.com, or follow us on LinkedIn.

Your mission at IntegriChain:

The mission of the Data Engineer is to design, build, and maintain scalable, reliable data pipelines and warehouse models that turn complex life science and healthcare data into clean, trusted datasets that power analytics and decision-making.

What you’ll do to thrive in this role:

• Develop scalable, reliable, and efficient data pipelines using dbt, Python, or other ELT tools
• Design, implement, and maintain scalable data orchestration and transformation processes, ensuring data accuracy, consistency, and timeliness
• Build and maintain scalable, complex dbt models
• Develop data warehouse structures, including dimension and fact tables
• Implement Type 1 and Type 2 slowly changing dimensions (SCDs) to accurately capture historical and current data
• Manage and execute data mart updates to support downstream reporting and analytics
• Build conformed dimensions through integration with Master Data Management (MDM) systems
• Work with life science and healthcare datasets, applying domain knowledge to ensure data quality and relevance
• Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions
• Partner closely with data analysts and data scientists to deliver clean, well-structured datasets for analysis and modeling
• Collaborate with fellow engineers across Git repositories, following sound version control and code review practices

What you’ll bring to the table:

• Bachelor’s degree (B.Tech or B.E.) in Computer Science or a related engineering discipline and/or equivalent practical experience
• Advanced SQL skills, including writing, optimizing, and troubleshooting complex queries across large datasets
• Strong expertise in data warehouse development and concepts, including dimensional modeling, Type 1/Type 2 SCDs, data mart updates, and conformed dimensions via MDM integration
• Hands-on proficiency with ETL tools such as dbt, Python, SSIS, or PowerCenter
• Proven ability to design and build ETL/ELT pipelines that are reliable, scalable, and easy to maintain
• Demonstrated experience working with Git and collaborating with other engineers across repositories
• Availability to work with meaningful overlap with US Eastern business hours
• Experience working with life science or healthcare data and an understanding of its quality and compliance considerations
• Working knowledge of cloud platforms such as Azure or AWS
• Practical experience building and optimizing workloads in Snowflake, preferred
• Practical experience building and maintaining complex dbt models, including testing and documentation, preferred
• Snowflake or dbt certification, preferred

Additional Information:

• Working hours: This is a fully remote role based in India, with working hours aligned to US Eastern Time, 9:00 AM to 5:00 PM ET, Monday through Friday. This corresponds to approximately 6:30 PM to 2:30 AM IST during US Daylight Saving Time and 7:30 PM to 3:30 AM IST otherwise.
• Holiday calendar: The role follows the US company holiday calendar rather than the Indian public holiday calendar

#LI-NS1

What IntegriChain offers:

• Mission driven: Work with the purpose of helping to improve patients' lives!
• Excellent and affordable medical benefits + non-medical perks including Flexible Paid Time Off (PTO) and much more!
• Robust Learning & Development opportunities including over 700+ development courses free to all employees

IntegriChain is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to race, color, religion, national origin, ethnicity, age, sex, marital status, physical or mental disability, gender identity, sexual orientation, veteran or military status, or any other category protected under the law. IntegriChain is an equal opportunity employer; committed to creating a community of inclusion, and an environment free from discrimination, harassment, and retaliation.