Data Engineer I

Responsibilities

• Design, build, and support reliable batch and incremental data pipelines for commercial data products, ensuring scalability, maintainability, and operational readiness.
• Ingest, transform, and integrate large-scale structured and semi-structured pharma datasets (e.g., claims, patient, HUB, and specialty pharmacy data) into curated refined-layer tables.
• Implement transformation logic including cross-domain joins and slowly changing dimensions (SCD) and maintain clear technical documentation for datasets and pipelines.
• Ensure data quality through cleansing, standardization, deduplication, reconciliation, automated validation checks, anomaly detection, and monitoring/alerting; triage and resolve data issues.
• Apply data governance practices including documentation, lineage, access controls, and compliant handling of sensitive/regulated data.
• Partner with analysts and business stakeholders to translate requirements into data specifications, define dataset readiness criteria, and support adoption of published data products.
• Skills & Competancies
• Proficiency in SQL and Python for data transformation, validation, and pipeline development.
• Experience building ETL/ELT pipelines and working with lakehouse concepts (e.g., medallion architecture; bronze/silver/gold layers).
• Hands-on experience with Databricks (notebooks/jobs/workflows) and Delta Lake concepts (ACID tables, incremental processing, upserts/merge).
• Familiarity with data modeling for analytics-ready datasets.
• Experience with cloud data engineering fundamentals (e.g., AWS storage/compute, IAM concepts)
• Understanding of data quality practices and operational support.
• Working knowledge of engineering best practices (Git/version control, code reviews, basic CI/CD concepts).
• Understanding of data governance and secure data handling (documentation, lineage, access controls, PII/PHI awareness).
• Familiarity with BI/visualization tools (Tableau/Power BI) is a plus for downstream consumption.
• Strong problem-solving, communication, and time-management skills
• Ability to work with both technical and business partners.
• Qualifications & Experience
• Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, Statistics/Mathematics, or a related field (or equivalent practical experience).
• 1-3 years of hands-on experience in data engineering or related roles, building and supporting ETL/ELT pipelines and curated datasets; biopharma/pharmaceutical experience is a plus.
• Experience processing large-scale structured and semi-structured datasets using SQL and Python, with attention to data quality, performance, and maintainability.
• Preferred: experience with Databricks and Delta Lake concepts.
• Preferred: experience working with commercial pharma datasets (e.g., claims, sales, payer, patient, HUB/specialty pharmacy) and understanding common identifiers and integration challenges.
• If you come across a role that intrigues you but doesn't perfectly line up with your resume, we encourage you to apply anyway. You could be one step away from work that will transform your life and career.
• Uniquely Interesting Work, Life-changing Careers
• With a single vision as inspiring as "Transforming patients' lives through science™ ", every BMS employee plays an integral role in work that goes far beyond ordinary. Each of us is empowered to apply our individual talents and unique perspectives in a supportive culture, promo

Benefits

Additional Information

Working with Us Challenging. Meaningful. Life-changing. Those aren't words that are usually associated with a job. But working at Bristol Myers Squibb is anything but usual. Here, uniquely interesting work happens every day, in every department. From optimizing a production line to the latest breakthroughs in cell therapy, this is work that transforms the lives of patients, and the careers of those who do it. You'll get the chance to grow and thrive through opportunities uncommon in scale and scope, alongside high-achieving teams. Take your career farther than you thought possible. Bristol Myers Squibb recognizes the importance of balance and flexibility in our work environment. We offer a wide variety of competitive benefits, services and programs that provide our employees with the resources to pursue their goals, both at work and in their personal lives. Read more: careers.bms.com/working-with-us . Position Summary We are looking for an early ‑ career Data Engineer to help build, operate, and continuously improve reliable data pipelines and curated datasets that support commercial analytics and reporting. In this role, you will transform raw data into high ‑ quality, analytics ‑ ready tables in the refined layer, applying data modeling best practices, validation checks, and governance standards. You will work closely with engineers, analysts, and business stakeholders to understand data requirements, implement scalable transformations, and ensure data products are trusted, secure, and well ‑ documented.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Bristol-Myers Squibb? Share your experience