5+ years in data engineering, analytics engineering, or data platform development.
10+ years of experience IT with some in Biotech/Pharma industry
Expert-level proficiency in:
**DBT:** advanced macros, Jinja, testing, exposures, dbt Cloud deployment.
**Databricks:** Spark (PySpark, SQL), Delta Lake, Unity Catalog.
**Snowflake**
**AWS: S3, Glue, Lambda, Step Functions, Datasync, EMR, Redshift, IAM and networking/security fundamentals.**
**Data Visualization:** Power BI or Tableau.
Strong programming background in Python and SQL (including query optimization).
Proven experience with distributed systems and large-scale datasets (TB scale).
Experience implementing CI/CD pipelines, data testing, and infrastructure as code.
Solid understanding of data governance, security, and compliance in enterprise environments.
Architect and implement end-to-end ELT workflows with DBT (core and Cloud), ensuring modular, testable, and reusable transformations.
Build high-performance data pipelines in Snowflake and Databricks (PySpark, Delta Lake, Unity Catalog) for batch and streaming workloads.
Orchestration using Apache Airflow and Amazon tools.
Engineer scalable data ingestion pipelines into AWS (DBT, SQL, PythonS3, Kinesis, Glue, Lambda, Step Functions) with strong monitoring and fault tolerance.
Ensure observability, cost efficiency & scalability in all pipeline and compute designs.
Design normalized and star-schema models for analytical workloads, following dbt's best practices and software engineering principles.
Implement data quality testing frameworks (dbt tests, Great Expectations, or custom validations) with automated CI/CD integration.
Manage data versioning, lineage, and governance through tools such as Unity Catalog and AWS Lake Formation.
Ensure data lineage, cataloging, and metadata management are maintained.
Apply HIPPA privacy rules, and pharma‑specific compliance standards.
Support audits, documentation, and validation activities.
Develop semantic data layers that support self-service analytics across BI tools (Tableau, Power BI etc.).
Partner with analysts and data scientists to optimize queries and deliver production-ready datasets.
Manage ingestion and harmonization of EU commercial datasets such as:
HCP/HCO master data (IQVIA and Veeva)
Sales and distribution data (Integrichain, Symphony Non-Retail and Country specific market data)
Omnichannel engagement (email, rep-triggered, web, events)
CRM activity data (Veeva, LifeScience Cloud)
Market research and syndicated data (IQVIA, etc.)
Support data pipelines used for incentive compensation, field force effectiveness, and brand performance analytics.
Automate deployment pipelines with CI/CD (GitHub Actions, GitLab CI, or AWS CodePipeline) for dbt and Databricks.
Implement infrastructure-as-code (IaaC) for reproducibility (Terraform, CloudFormation).
Ensure system reliability through observability and monitoring (Datadog, CloudWatch, Prometheus, or similar).
Benchmark and optimize SQL, Spark, and BI query performance at scale.
Partner with Data Scientists, Commercial Analysts, and Business Partners to translate business needs into technical solutions.
Work closely with IT, Compliance, and Data Privacy teams to ensure GDPR‑aligned data handling.
Provide technical guidance on data availability, feasibility, and best practices.
For US based candidates, the proposed salary band for this position is as follows: $131,600.00---$197,400.00
The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, and location. Also, certain positions are eligible for additional forms of compensation, such as discretionary bonuses and long-term incentives.
401(k) Plan: 100% match on the first 6% of contributions
Health Benefits: Two medical plan options (including HDHP with HSA), dental, and vision insurance
Voluntary Plans: Critical illness, accident, and hospital indemnity insurance
Time Off: Paid vacation, sick leave, holidays, and 12 weeks of discretionary paid parental leave
Support Resources: Access to child and adult backup care, family support programs, financial wellness tools, and emotional well-being support
Additional Perks: Commuter benefits, tuition reimbursement, and a Lifestyle Spending Account for wellness and personal expenses
For US based candidates, the proposed salary band for this position is as follows:\n\n$131,600.00---$197,400.00
The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, and location. Also, certain\npositions are eligible for additional forms of compensation, such as discretionary bonuses and long-term incentives.