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.