Sr Data Engineer

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.

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.

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

Ensure data models support downstream BI, AI/ML, semantic models, data apps, MDM Explorer/Entity 360 use cases, and enterprise reporting.

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.

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

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