Data Services Developer SQL Server - Remote

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; 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 , or follow us on LinkedIn .

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.

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

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

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

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. Holiday calendar: The role follows the US company holiday calendar rather than the Indian public holiday calendar

#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. committed to creating a community of inclusion, and an environment free from discrimination, harassment, and retaliation.