Analytics Engineer I

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 Analytics Engineer to help develop trusted, analytics‑ready data products that enable commercial reporting, business insights, and decision support. In this role, you will transform raw and curated data into well‑modeled datasets, metrics, and semantic assets that are easy for analysts and business users to consume. You will apply data modeling, SQL transformation, data quality, documentation, and governance practices while partnering closely with engineering, analytics, and business stakeholders to ensure data products are accurate, secure, reusable, and aligned to business needs.

Key Responsibilities

• Design, build, and support analytics-ready data products, curated datasets, and reusable transformation assets within a modern lakehouse environment to enable commercial reporting, self-service analytics, and business insights.

• Translate business and analytics requirements into clear data specifications, dimensional models, metrics definitions, and dataset readiness criteria aligned to internal modeling and delivery standards.

• Develop and maintain scalable SQL- and Python-based transformation logic that integrates structured and semi-structured pharma datasets such as claims, patient, sales, payer, HUB, and specialty pharmacy data.

• Apply internally developed accelerators, reusable code patterns, templates, and engineering guardrails to improve development speed, consistency, quality, and maintainability across data products.

• Create analytics-friendly models, including fact and dimension tables, cross-domain joins, slowly changing dimensions, and business-rule-driven metrics that support dashboard, reporting, and advanced analytics consumption.

• Implement standardized data quality checks, reconciliation logic, validation routines, and anomaly detection controls to ensure datasets are accurate, complete, consistent, and trusted by downstream users.

• Document data products, metric definitions, lineage, assumptions, reusable components, and known limitations in accordance with internal documentation and governance standards.

• Partner with data engineers, analysts, BI developers, and business stakeholders to support dashboard/reporting use cases, drive adoption of published data products, and continuously improve reusable delivery standards.

• Apply data governance standards, access controls, and compliant handling practices for sensitive and regulated data, including PII/PHI awareness.

 

Skills & Competencies

• Strong proficiency in SQL for analytics transformations, data modeling, validation, and performance tuning.

• Working knowledge of Python for data preparation, validation, automation, and analytical workflows.

• Experience developing analytics-ready datasets using dimensional modeling concepts such as facts, dimensions, grains, keys, and slowly changing dimensions.

• Familiarity with ETL/ELT patterns, lakehouse concepts, and medallion architecture including bronze, silver, and gold/refined layers.

• Hands-on familiarity with Databricks notebooks, jobs/workflows, Delta Lake concepts, and curated data product development.

• Understanding of semantic layer concepts, metric definitions, and how curated datasets support BI, dashboards, and self-service analytics.

• Experience with data quality practices including profiling, cleansing, standardization, reconciliation, anomaly detection, and issue triage.

• Working knowledge of governance and secure data handling practices including documentation, lineage, access controls, and PII/PHI awareness.

• Familiarity with BI/visualization tools such as Tableau or Power BI and the data structures required for effective reporting consumption.

• Understanding of engineering practices such as Git/version control, code reviews, modular development, and basic CI/CD concepts.

• Strong problem-solving, communication, and stakeholder collaboration skills, with the ability to bridge technical and business conversations.

 

 

Qualifications & Experience

• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, Statistics/Mathematics, Analytics, or a related field (or equivalent practical experience).

• 1–3 years of hands-on experience in analytics engineering, data engineering, business intelligence engineering, or related roles building curated datasets, data models, and analytics-ready assets.

• Experience transforming large-scale structured and semi-structured datasets using SQL and Python, with attention to data quality, business logic, performance, and maintainability.

• Preferred: experience with Databricks, Delta Lake, lakehouse architecture, and refined/gold-layer data product development.

• Preferred: experience working with commercial pharma datasets such as claims, sales, payer, patient, HUB, or specialty pharmacy data and understanding common identifiers, metrics, and integration challenges.

• Preferred: experience in Medical Evidence Generation and the Medical data domain, including familiarity with evidence planning, scientific data assets, medical insights, publications, field medical activity, or related medical affairs datasets.

• Preferred: exposure to BI/reporting use cases, semantic layer design, metric standardization, or dashboard-ready data modeling.

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, promoting global participation in clinical trials, while our shared values of passion, innovation, urgency, accountability, inclusion and integrity bring out the highest potential of each of our colleagues.

On-site Protocol

BMS has an occupancy structure that determines where an employee is required to conduct their work. This structure includes site-essential, site-by-design, field-based and remote-by-design jobs. The occupancy type that you are assigned is determined by the nature and responsibilities of your role:

Site-essential roles require 100% of shifts onsite at your assigned facility. Site-by-design roles may be eligible for a hybrid work model with at least 50% onsite at your assigned facility. For these roles, onsite presence is considered an essential job function and is critical to collaboration, innovation, productivity, and a positive Company culture. For field-based and remote-by-design roles the ability to physically travel to visit customers, patients or business partners and to attend meetings on behalf of BMS as directed is an essential job function.

Supporting People with Disabilities

BMS is dedicated to ensuring that people with disabilities can excel through a transparent recruitment process, reasonable workplace accommodations/adjustments and ongoing support in their roles. Applicants can request a reasonable workplace accommodation/adjustment prior to accepting a job offer. If you require reasonable accommodations/adjustments in completing this application, or in any part of the recruitment process, direct your inquiries to [email protected]. Visit careers.bms.com/eeo-accessibility to access our complete Equal Employment Opportunity statement.

Candidate Rights

BMS will consider for employment qualified applicants with arrest and conviction records, pursuant to applicable laws in your area.

If you live in or expect to work from Los Angeles County if hired for this position, please visit this page for important additional information: https://careers.bms.com/california-residents/

Data Protection

We will never request payments, financial information, or social security numbers during our application or recruitment process. Learn more about protecting yourself at https://careers.bms.com/fraud-protection.

Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.

If you believe that the job posting is missing information required by local law or incorrect in any way, please contact BMS at [email protected]. Please provide the Job Title and Requisition number so we can review. Communications related to your application should not be sent to this email and you will not receive a response. Inquiries related to the status of your application should be directed to Chat with Ripley.

R1605091 : Analytics Engineer I