Pay
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Philadelphia, PA, United States
Open 4 months, first seen by us 149 days agoWork setup in the employer’s posting: RemoteFrom the employer’s posting
Employment type in the employer’s posting: Full-timeFrom the employer’s posting
Design, build and optimize Snowflake data models, pipelines and stored procedures
Build pipelines that load source data into Reltio MDM and extract mastered outputs
Develop reliable, testable dbt or similar ELT transformation pipelines
Drive Snowflake performance tuning, warehouse sizing and cost optimization
Define reusable data integration patterns for batch, near-real-time and app-to-app exchange
Design, build, optimize, and operate Snowflake data models, pipelines, stored procedures, and high-volume data processing patterns.
Design and build data pipelines that load source data into Reltio MDM and extract mastered outputs from Reltio for downstream Snowflake, analytics, AI, and operational use cases.
Use dbt or similar ELT tooling to develop reliable, maintainable, testable, and observable data pipelines.
Drive Snowflake performance tuning, warehouse sizing, workload management, cost tracking, and cost optimization practices.
Define reusable data integration patterns for batch, micro-batch, near-real-time, and application-to-application data exchange.
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by IntegriChain
10+ years of experience in data engineering, database engineering, analytics engineering, or data platform development in production environments.
Strong SQL and PL/SQL-style development experience, including complex transformations, stored procedures, performance tuning, and large-scale data processing.
Python experience for data automation, API integration, file handling, data validation, metadata processing, or operational tooling.
Experience designing and implementing enterprise data models, curated data layers, semantic layers, and reusable data products.
Experience with data integration patterns across enterprise applications, APIs, files, cloud storage, operational systems, MDM platforms, and analytical platforms.
Experience partnering with MDM, Product, or business teams to translate mastering requirements into source-to-target mappings, transformation logic, validations, and downstream data consumption patterns.
Hands-on experience with ETL/ELT tools; dbt experience is strongly preferred.
Experience with Reltio MDM, including inbound data loads, outbound exports, Reltio APIs, crosswalks, match/merge outputs, survivorship outputs, and operational troubleshooting.
Experience in life sciences, healthcare, pharma commercialization, HCO/HCP mastering, patient data, channel data, customer master, or commercial data platforms.
Experience with life sciences reference and commercial datasets such as HIN, DEA, NPI, NCPDP, 340B/PHS, 844, 852, 867, chargebacks, gross-to-net, government pricing, PBR, or UBR.
Open 4 monthsWe first saw this posting 149 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Day 149
Up longer than most. Similar jobs usually come down between day 6 and day 56.
Well past IntegriChain’s usual: its jobs come down by about day 41.
From 14,756 similar postings that came down, and 12 of IntegriChain’s. Coming down is not always a hire.
9 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Create denormalized reporting and semantic-model-ready structures that simplify business consumption and reduce ambiguity for AI/LLM use cases. - Process and optimize large data volumes in Snowflake using efficient SQL, PL/SQL-style procedural logic, Snowflake Scripting, and performance-aware design. - Create reusable patterns for historical tracking, snapshots, audit columns, data versioning, and lifecycle management.
- Hands-on experience with ETL/ELT tools; dbt experience is strongly preferred. - Strong SQL and PL/SQL-style development experience, including complex transformations, stored procedures, performance tuning, and large-scale data processing. - Python experience for data automation, API integration, file handling, data validation, metadata processing, or operational tooling.
- Apply secure Snowflake design patterns including RBAC, masking, access isolation, auditing, and environment separation. ETL/ELT, dbt, Python, and Data Pipeline Development - Design, build, and maintain reliable ELT pipelines using dbt or comparable modern data transformation tooling.
- Design, build, and maintain reliable ELT pipelines using dbt or comparable modern data transformation tooling. - Develop Python-based automation for API integration, file processing, metadata management, validation, orchestration support, and operational tooling. - Develop modular, tested, and reusable transformation models for raw, curated, mastered, and business-ready data layers.
- Strong SQL and PL/SQL-style development experience, including complex transformations, stored procedures, performance tuning, and large-scale data processing. - Python experience for data automation, API integration, file handling, data validation, metadata processing, or operational tooling. - Experience designing and implementing enterprise data models, curated data layers, semantic layers, and reusable data products.
- Implement Snowflake cost tracking and optimization practices, including warehouse utilization monitoring, inefficient query identification, and cost allocation by workload, team, or use case. - Build scalable SQL and Snowflake stored procedure logic for large-volume data processing and analytical workloads. - Apply secure Snowflake design patterns including RBAC, masking, access isolation, auditing, and environment separation.
- Experience with orchestration frameworks such as Airflow, Dagster, dbt Cloud jobs, cloud-native schedulers, or similar tools. - Experience with cloud platforms and storage patterns, especially Azure or AWS object storage integrated with Snowflake. - Exposure to AI-ready data architecture, feature stores, ML datasets, semantic models, or AI/ML pipeline enablement.
- Cross-functional partnership: Work with Product, Engineering, MDM, Data Science, DevOps, Security, and business stakeholders to align data solutions to enterprise priorities. - Modern ELT execution: Use dbt or similar ELT tooling to develop reliable, maintainable, testable, and observable data pipelines. - Cost and performance ownership: Drive Snowflake performance tuning, warehouse sizing, workload management, cost tracking, and cost optimization practices.
ETL/ELT, dbt, Python, and Data Pipeline Development - Design, build, and maintain reliable ELT pipelines using dbt or comparable modern data transformation tooling. - Develop Python-based automation for API integration, file processing, metadata management, validation, orchestration support, and operational tooling.
- Thorough understanding of Snowflake design patterns for analytical workloads, high-volume data processing, data sharing, and multi-environment deployments. - Hands-on experience with ETL/ELT tools; dbt experience is strongly preferred. - Strong SQL and PL/SQL-style development experience, including complex transformations, stored procedures, performance tuning, and large-scale data processing.
- Experience with life sciences reference and commercial datasets such as HIN, DEA, NPI, NCPDP, 340B/PHS, 844, 852, 867, chargebacks, gross-to-net, government pricing, PBR, or UBR. - Experience with orchestration frameworks such as Airflow, Dagster, dbt Cloud jobs, cloud-native schedulers, or similar tools. - Experience with cloud platforms and storage patterns, especially Azure or AWS object storage integrated with Snowflake.
- Experience with Terraform, CI/CD, Git-based development, and infrastructure-as-code practices. - Snowflake SnowPro, Reltio, dbt, or equivalent cloud/data engineering certifications. Additional Information
- Enterprise data leadership: Help define and mature data integration, data consolidation, MDM integration, and data platform design patterns across Integrichain. - Hands-on Snowflake engineering: Design, build, optimize, and operate Snowflake data models, pipelines, stored procedures, and high-volume data processing patterns. - MDM/Reltio enablement: Partner with MDM and Product teams to support HCO Master data ingestion, outbound extracts, cross-reference data, golden record consumption, survivorship outputs, and downstream publishing patterns.
- Modern ELT execution: Use dbt or similar ELT tooling to develop reliable, maintainable, testable, and observable data pipelines. - Cost and performance ownership: Drive Snowflake performance tuning, warehouse sizing, workload management, cost tracking, and cost optimization practices. Key Responsibilities
MDM / Reltio Data Engineering Enablement - Design and build data pipelines that load source data into Reltio MDM and extract mastered outputs from Reltio for downstream Snowflake, analytics, AI, and operational use cases. - Partner with MDM configuration and Product Management teams to translate HCO mastering requirements into data pipeline, mapping, validation, reconciliation, and publishing patterns.
- Support source ingestion and reference data integration involving datasets such as HIN, DEA, NPI, NCPDP, 340B/PHS, channel outlet data, customer/account data, and other life sciences master/reference sources. - Develop validation and reconciliation processes to compare source data, Reltio mastered data, Snowflake curated data, and downstream consumption layers. - Help operationalize MDM outputs for business-facing data products, semantic models, reporting tables, APIs, and AI-ready datasets.
- Help operationalize MDM outputs for business-facing data products, semantic models, reporting tables, APIs, and AI-ready datasets. Snowflake Platform Engineering and Optimization - Design Snowflake database, schema, table, view, and semantic-layer patterns that support performance, governance, and maintainability.
Snowflake Platform Engineering and Optimization - Design Snowflake database, schema, table, view, and semantic-layer patterns that support performance, governance, and maintainability. - Optimize Snowflake workloads using clustering, micro-partition awareness, warehouse sizing, query profiling, caching behavior, and workload isolation.
- Design Snowflake database, schema, table, view, and semantic-layer patterns that support performance, governance, and maintainability. - Optimize Snowflake workloads using clustering, micro-partition awareness, warehouse sizing, query profiling, caching behavior, and workload isolation. - Implement Snowflake cost tracking and optimization practices, including warehouse utilization monitoring, inefficient query identification, and cost allocation by workload, team, or use case.
- Optimize Snowflake workloads using clustering, micro-partition awareness, warehouse sizing, query profiling, caching behavior, and workload isolation. - Implement Snowflake cost tracking and optimization practices, including warehouse utilization monitoring, inefficient query identification, and cost allocation by workload, team, or use case. - Build scalable SQL and Snowflake stored procedure logic for large-volume data processing and analytical workloads.
- Build scalable SQL and Snowflake stored procedure logic for large-volume data processing and analytical workloads. - Apply secure Snowflake design patterns including RBAC, masking, access isolation, auditing, and environment separation. ETL/ELT, dbt, Python, and Data Pipeline Development
- 10+ years of experience in data engineering, database engineering, analytics engineering, or data platform development in production environments. - Strong hands-on experience with Snowflake, including architecture, performance tuning, security design, cost optimization, and cost tracking. - Thorough understanding of Snowflake design patterns for analytical workloads, high-volume data processing, data sharing, and multi-environment deployments.
- Strong hands-on experience with Snowflake, including architecture, performance tuning, security design, cost optimization, and cost tracking. - Thorough understanding of Snowflake design patterns for analytical workloads, high-volume data processing, data sharing, and multi-environment deployments. - Hands-on experience with ETL/ELT tools; dbt experience is strongly preferred.
- Exposure to AI-ready data architecture, feature stores, ML datasets, semantic models, or AI/ML pipeline enablement. - Experience with Terraform, CI/CD, Git-based development, and infrastructure-as-code practices. - Snowflake SnowPro, Reltio, dbt, or equivalent cloud/data engineering certifications.
Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.
Already applied? Track this application
Position Overview
Key Responsibilities
Data Strategy, Consolidation, and Integration
MDM / Reltio Data Engineering Enablement
Snowflake Platform Engineering and Optimization
ETL/ELT, dbt, Python, and Data Pipeline Development
Data Modeling and Big Data Processing
Required Skills and Experience
Preferred Experience
What does IntegriChain have to offer?
#LI-KL1
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.
Our policy on visa sponsorship for US based positions: Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by IntegriChain.
IntegriChain is the data and application backbone for market access departments of Life Sciences manufacturers. We deliver the data, the applications, and the business process infrastructure for patient access and therapy commercialization. More than 250 manufacturers rely on our ICyte Platform to orchestrate their commercial and government payer contracting, patient services, and distribution channels. ICyte is the first and only platform that unites the financial, operational, and commercial data sets required to support therapy access in the era of specialty and precision medicine. With ICyte, Life Sciences innovators can digitalize their market access operations, freeing up resources to focus on more data-driven decision support. With ICyte, Life Sciences innovators are digitalizing labor-intensive processes – freeing up their best talent to identify and resolve coverage and availability hurdles and to manage pricing and forecasting complexity.
We are headquartered in Philadelphia, PA (USA), with offices in: Ambler, PA (USA); Pune, India; and Medellín, Colombia. For more information, visit www.integrichain.com, or follow us on Twitter @IntegriChain and LinkedIn.
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Philadelphia, PA, United States
Working pattern and location restrictions need checking in the full posting.
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. Our policy on visa sponsorship for US based positions: Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by IntegriChain. Company Description