Sr Data Engineer

IntegriChain

United States

À distance

USD 140 000 - 190 000

Plein temps

Il y a 11 jours

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Avantages offerts par ce poste

Excellent medical benefits
Flexible Paid Time Off

Résumé du poste

IntegriChain is seeking a senior data engineering leader to define and mature data integration, consolidation, and MDM enablement across our Snowflake-based data platform. You will design robust ELT pipelines, work with Reltio MDM, and partner with Product and DevOps to deliver scalable data solutions for Life Sciences markets.

The role emphasizes hands-on Snowflake work, data modeling, and building reusable data products with a focus on quality, performance, and governance.

Qualifications

  • 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, cost optimization, and data modeling.
  • Hands-on ETL/ELT tools experience; 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.
  • 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.
  • Working understanding of Master Data Management concepts such as golden records, crosswalks/XREFs, match/merge, survivorship, hierarchies, entity relationships, stewardship, and data quality.
  • Experience partnering with MDM, Product, or business teams to translate mastering requirements into data mappings, transformation logic, validations, and downstream data consumption patterns.
  • Ability to work directly with cross-functional stakeholders to gather requirements, explain design tradeoffs, and drive alignment.
  • Experience implementing data quality, lineage, auditability, observability, and operational monitoring within data pipelines.
  • Comfortable operating as a hands-on senior contributor who can influence strategy and engineering standards.

Responsabilités

  • Data Strategy, Consolidation, and Integration: rationalize and consolidate the enterprise data landscape across products and platforms.
  • Define reusable data integration patterns for batch, micro-batch, near-real-time, and application-to-application data exchange.
  • Collaborate with cross-functional teams to understand business data needs and enterprise integration requirements.
  • Design scalable patterns for ingesting, transforming, mastering, and publishing data across use cases.
  • Help establish standards for data contracts, schema evolution, data quality, lineage, and data ownership.
  • MDM/Reltio Data Engineering Enablement: design and build pipelines loading source data into Reltio and publishing outputs to Snowflake and analytics.
  • Partner with MDM configuration and Product teams to translate mastering requirements into data patterns.
  • Work with APIs, exports, crosswalks, event-based patterns, and bulk load/extract mechanisms for inbound/outbound data flows.
  • Engineer integration patterns for HCO Master data including party/entity, address, identifier, hierarchy, survivorship, and golden records.
  • Develop validation and reconciliation processes across source data, mastered data, and downstream layers.
  • Build orchestration-ready pipelines with dependency management and restartability.
  • Collaborate with DevOps/SRE on CI/CD and deployment automation for data pipelines.

Connaissances

Data engineering
Analytics engineering
SQL
Python
ETL/ELT
Data modeling
Data quality
Observability
Data orchestration

Outils

Snowflake
dbt
Reltio MDM
Airflow
Git
Terraform

Description du poste

Company Description

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.

Job Description
Position Overview

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.

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.

Key Responsibilities
  • Data Strategy, Consolidation, and Integration Partner with Data Science leadership to rationalize and consolidate the enterprise data landscape across products, platforms, and acquired capabilities.
  • Define reusable data integration patterns for batch, micro-batch, near-real-time, and application-to-application data exchange.
  • Collaborate with cross-functional teams to understand business data needs, source-system realities, and enterprise application integration requirements.
  • Design scalable patterns for ingesting, transforming, mastering, and publishing data across operational and analytical use cases.
  • Help establish standards for data contracts, schema evolution, data quality, lineage, and data ownership.
  • 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.
  • Work with Reltio APIs, exports, crosswalks/XREFs, event-based integration patterns, and bulk load/extract mechanisms as needed to support inbound and outbound data flows.
  • Engineer integration patterns for HCO Master data, including party/entity, address, identifier, hierarchy, relationship, match/merge, survivorship, and golden record outputs.
  • 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.
  • 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.
  • 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.
  • 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.
  • Develop modular, tested, and reusable transformation models for raw, curated, mastered, and business-ready data layers.
  • Implement automated data quality checks, source freshness checks, reconciliation, logging, and exception-handling patterns.
  • Build orchestration-ready pipelines that support dependency management, restartability, incremental loads, and operational monitoring.
  • Collaborate with DevOps/SRE teams on CI/CD, deployment automation, environment promotion, and operational runbooks for data pipelines.
  • Data Modeling and Big Data Processing Spearhead logical and physical data modeling efforts for enterprise analytical, operational, MDM, and AI-ready datasets.
  • Design models that balance normalization, dimensional modeling, medallion/lakehouse concepts, and application-specific consumption needs.
  • Create denormalized reporting and semantic-model-ready structures that simplify business consumption and reduce ambiguity for AI/LLM use cases.
  • Process and optimise 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.
  • Ensure data models support downstream BI, AI/ML, semantic models, data apps, MDM Explorer/Entity 360 use cases, and enterprise reporting.
Qualifications Required Skills and Experience
  • 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.
  • 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.
  • 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 with data integration patterns across enterprise applications, APIs, files, cloud storage, operational systems, MDM platforms.
  • Working understanding of Master Data Management concepts such as golden records, crosswalks/XREFs, match/merge, survivorship, hierarchies, entity relationships, stewardship, and data quality.
  • 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.
  • Ability to work directly with cross-functional stakeholders to gather requirements, explain design tradeoffs, and drive alignment.
  • Experience implementing data quality, lineage, auditability, observability, and operational monitoring within data pipelines.
  • Comfortable operating as a hands-on senior individual contributor who can also influence strategy and engineering standards.
Preferred Experience
  • 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.
  • 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.
  • 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

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 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.

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.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Data Engineer
Data Engineer

IntegriChain • États-Unis

À distance
USD 120 000 - 170 000
Flexible PTO
Medical benefits
Learning & development
Product Manager - Data Management & Data Products
Product Manager - Data Management & Data Products

IntegriChain Incorporated • Pennsylvania

Hybride
USD 130 000 - 190 000
Flexible Paid Time Off
Learning & Development courses
Product Analyst, Conversational AI
Product Analyst, Conversational AI

IntegriChain Incorporated • Philadelphia

Hybride
USD 90 000 - 120 000
Flexible Paid Time Off
700+ development courses
Medical benefits
Senior Manager, Data Solutions
Senior Manager, Data Solutions

IntegriChain • Pennsylvania

Sur place
USD 140 000 - 190 000
Medical benefits
Learning & Development opportunities
Flexible Paid Time Off
Senior Manager, Data Solutions
Senior Manager, Data Solutions

IntegriChain • Philadelphia

Sur place
USD 150 000 - 190 000
Medical benefits
Learning & development opportunities
Mission-driven work
Product Analyst, Prism — Conversational AI
Product Analyst, Prism — Conversational AI

IntegriChain Incorporated • Philadelphia

Hybride
USD 90 000 - 120 000
Flexible Paid Time Off
700+ development courses
Medical benefits
Manager, Trade Operations
Manager, Trade Operations

IntegriChain • Philadelphia

Sur place
USD 120 000 - 165 000
Mission driven
Medical benefits
Student Loan Reimbursement
+1
Product Analyst, Agentic AI
Product Analyst, Agentic AI

IntegriChain Incorporated • Pennsylvania

Sur place
USD 90 000 - 130 000
Flexible Paid Time Off
Medical benefits
700+ development courses
Product Analyst, Conversational AI
Product Analyst, Conversational AI

IntegriChain • Pennsylvania

Sur place
USD 85 000 - 110 000
Medical benefits
Learning & development
Flexible PTO
Sr. Product Manager
Sr. Product Manager

IntegriChain Incorporated • Pennsylvania

Hybride
USD 110 000 - 165 000
Student Loan Reimbursement
Flexible Paid Time Off
Paid Parental Leave
+2