Data engineer in drug development

Andersen; United States; Hybrid; USD 67,000 - 100,000; Full time

Benefits offered by this job

Private health insurance

Career growth opportunities

Training portal access

Certification compensation (AWS, PMP)

Referral program

Job summary

Andersen ищет дата-инженера для проекта на Azure Databricks в ЕС, цель — развивать облачную платформу данных и поставлять масштабируемые решения для разработки лекарств.

Задачи включают конвейеры Landing–Raw–Enriched–Curated, оркестрацию через Databricks Jobs, интеграцию данных батч/API, контроль качества и аудит. Требуется 4+ года опыта, dbt, CI/CD, английский не ниже Upper-Intermediate.

Qualifications

• 4+ лет коммерческого опыта в Data Engineering.
• Опыт работы с Azure Databricks и Delta Lake.
• Умение проектировать конвейеры Landing → Raw → Enriched → Curated.
• Контроль качества данных на этапе инференции и хранении.
• Опыт оркестрации через Databricks Jobs / Workflows, обработка зависимостей и сбоев.
• Опыт Batch и API‑интеграций, dbt, мониторинг и аудит.

Responsibilities

• Создание и сопровождение многослойных конвейеров (Landing → Raw → Enriched → Curated) на Azure Databricks.
• Оркестрация пайплайнов через Databricks Jobs / Workflows; управление зависимостями и повторными попытками.
• Интеграция данных батч и API из разных источников; обеспечение качества на стадии ingest.
• Контроль качества, аудит и документирование traceability и data lineage.
• Работа с dbt для observability, governance и CI/CD/MLOps в Databricks.
• Мониторинг сбоев, свежести данных и соответствия SLA; настройка логирования и алертинга.

Skills

Azure Databricks

Spark

Delta Lake

dbt

Databricks Jobs

Workflows

Data ingestion

Data quality checks

Schema enforcement

CI/CD

MLOps

Data contracts

Data lineage

English (Upper-Intermediate)

Tools

dbt

Delta Lake

Spark

Job description

Описание

Andersen is hiring a Data Engineer (Azure Databricks) in the EU for a project enhancing a cloud-based data platform and delivering scalable data solutions for drug development. The customer is an international company operating in the life sciences sector. It focuses on developing and commercializing specialized products and solutions, supported by research, technology, and partnerships across multiple markets.

Задачи

• Building and maintaining multi-layer pipelines (Landing → Raw → Enriched → Curated) on Azure Databricks (Spark, Delta Lake)
• Orchestrating pipelines via Databricks Jobs / Workflows: dependencies, retries, alerting.
• Implementing batch and API-based data ingestion from multiple source systems.
• Applying schema enforcement and handle schema drift; run data quality checks at ingestion.
• Working hands-on with dbt for pipeline observability and data governance tasks.
• Monitoring job failures, data freshness, and pipeline health against SLA-based delivery targets.
• Setting up alerts, logging, and retry strategies for production pipelines.
• Working within a controlled Dev/Test/Prod environment: access control, audit trails, pipeline documentation, traceability to requirements.
• Contributing to CI/CD and MLOps/AI pipelines on Databricks where the project needs it.

Требования

• Commercial experience in Data Engineering for 4+ years.
• Strong hands-on experience with Azure Databricks, including Spark and Delta Lake.
• Experience building and maintaining multi-layer data pipelines following the Landing → Raw → Enriched → Curated architecture.
• Experience with schema enforcement and schema-drift handling.
• Ability to implement data quality checks at ingestion.
• Experience orchestrating pipelines using Databricks Jobs / Workflows, including dependencies, retries, alerts, and failure handling.
• Experience with both batch and API-based data ingestion.
• Strong hands-on experience with dbt.
• Ability to monitor job failures, data freshness, and overall pipeline health.
• Experience delivering data in line with defined SLAs.
• Experience implementing alerting, logging, and retry strategies.
• Experience designing and maintaining access control models.
• Understanding of audit trails, data lineage, and end-to-end traceability.
• Experience with logging and evidence generation for audit and compliance purposes.
• Understanding of segregation of duties.
• Experience defining and maintaining data contracts.
• Ability to create and maintain clear pipeline documentation.
• Experience working across controlled Dev, Test, and Prod environments.
• Ability to ensure traceability between requirements and implemented data solutions.
• Level of English– from Upper-Intermediate and above.

Будет плюсом

• Experience with Databricks
• Experience with SAP S/4HANA
• Microsoft 365
• Azure
• SharePoint
• Enterprise integrations
• Experience with CI/CD and DevOps practices for data, including Git-based development and branching strategies
• Experience building and maintaining CI/CD pipelines for data workflows
• Experience promoting code and data solutions across Dev, Test, and Prod environments
• Ability to integrate automated testing into deployment pipelines
• Experience with MLOps and AI pipelines on Databricks
• Exposure to regulated domains such as GxP, clinical trials, and pharmacovigilance
• Strong SQL engineering skills, including the development of modular and reusable dbt models, tests, and documentation at Analytics Engineer depth
• Experience with dimensional data modeling, including star schemas, One Big Table (OBT) approaches, and curated data marts
• Familiarity with Tabular Editor and metadata-as-code concepts
• Experience with Power BI dataset design, performance optimization, and maintaining KPI and semantic consistency
• Experience in the pharmaceutical or biotechnology industry
• Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others

Условия

• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth!
• The opportunity to earn up to an additional 1,000 EUR per month, depending on the level of expertise, which will be included in the annual bonus, by participating in the company's activities.
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Bright corporate life (parties / pizza days / PlayStation / fruits / coffee / snacks / movies).
• Certification compensation (AWS, PMP, etc).
• Referral program.
• Private health insurance and sports compensation, depending on the type of employment.