Integrichain1

AI Data Engineer

Philadelphia, PA, United States

No sponsorshipDetected 64 days ago

PythonSQLSnowflakeCI/CDDevOpsSite Reliability EngineeringMachine LearningAirflowdbtData EngineeringData ScienceLLMsAgentic AIForecastingPatient CareCollaboration

About the role

IntegriChain is the data and application backbone for market access departments of Life Sciences manufacturers.
For more information, visit www.integrichain.com, or follow us on Twitter @ IntegriChain and LinkedIn.
The ideal candidate is a strong data engineer with deep Snowflake/dbt experience and a practical understanding of how semantic layers, ER relationships, denormalized models, and metadata quality influence LLM and agent performance.

Responsibilities

Build reliable data pipelines from raw source data through curated silver layers and business-ready gold layers using Snowflake and dbt.
Develop modular dbt models, tests, documentation, exposures, and lineage-friendly transformation patterns.
Implement incremental processing, snapshots, audit columns, reconciliation, data quality checks, and restartable pipeline patterns.
Optimize Snowflake SQL and dbt workloads for performance, scalability, cost, and maintainability.
Work with orchestration and DevOps/SRE teams to support CI/CD, environment promotion, pipeline monitoring, and operational runbooks.
Create Snowflake semantic models and curated views that support accurate natural-language querying through Snowflake Cortex Analyst and related LLM tools.
Design ER relationships and join paths that are explicit, accurate, and easy for semantic-layer tools and AI agents to use.
Create denormalized or consumption-optimized models where appropriate to reduce ambiguity and improve LLM answer quality.
Partner with AI developers to understand tool schema needs, agent workflows, and how data model design affects LLM tool performance.
Design logical and physical models that support enterprise data consolidation, analytical reporting, AI workflows, and business operations.

Requirements

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.
This role offers flexibility, but candidates must reside in Pennsylvania, New Jersey, or New York and be within a reasonable travel distance of our Philadelphia office, as regular in-person collaboration is required.

Nice to have

Translate approved data dictionaries into semantic model dimensions, facts, metrics, synonyms, descriptions, relationships, and business rules.
Work across source systems, files, APIs, cloud storage, operational systems, and analytical platforms to integrate data into Snowflake.
Understand Snowflake Cortex capabilities, including Cortex Analyst, Cortex Complete, semantic views/models, and metadata-driven AI workflows.
Prepare data models and semantic layers for accurate LLM usage, including clear naming, descriptions, relationships, metrics, and governance metadata.
6+ years of experience in data engineering, analytics engineering, database engineering, or data platform development in production environments.
Strong hands-on experience with Snowflake, including SQL development, performance tuning, security-aware design, cost optimization, and large-volume processing.
Strong hands-on experience with dbt or comparable ELT tooling, including models, tests, documentation, lineage, and environment promotion.
Strong SQL and Snowflake development skills, including complex transformations, views, stored procedures/Snowflake Scripting, and query optimization.

Benefits

Excellent and affordable medical benefits + non-medical perks including Student Loan Reimbursement, Flexible Paid Time Off and Paid Parental Leave
Robust Learning & Development opportunities including over 700+ development courses free to all employees

Visa & Work Authorization

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.

Apply directly at Integrichain1 →Create a free account for alerts like this View Integrichain1 immigration profile

This listing is sourced directly from Integrichain1's careers page and normalized into a canonical job model.