Senior Analytics Engineer

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 experienced Senior Analytics Engineer with deep expertise in Databricks, data modeling, and AWS to design, build, and scale the analytics layer that sits between raw curated data and business-facing insights for commercial analytics and reporting. In this role, you will own the transformation logic, dimensional/semantic models, and metrics definitions that turn refined-layer datasets into trusted, self-serve analytics products on the Databricks Lakehouse. You will set standards for data modeling and testing, mentor and work hands-on alongside junior developers to help them grow, and partner directly with analysts, data scientists, and business stakeholders to define metrics, data models, and governed datasets that power dashboards, self-service BI, and advanced analytics. You will also drive technical decisions on Databricks and AWS architecture, performance, scalability, and cost optimization across the analytics stack, while confidently communicating technical concepts and trade-offs to business audiences.

Key Responsibilities

• Design, build, and own scalable analytics-layer transformations (marts, semantic models, and metrics) on Databricks, using strong dimensional and analytical data modeling practices and modern transformation frameworks (e.g., dbt on Databricks).

• Architect analytics-ready data models (star/snowflake schemas, conformed dimensions, fact tables) that translate complex commercial business logic into consistent, reusable data structures.

• Own performance tuning and cost optimization of Databricks workloads, including cluster configuration, Delta Lake optimization (Z-ordering, partitioning, OPTIMIZE/VACUUM), Unity Catalog, and job/workflow orchestration.

• Design and manage AWS-based data architecture underpinning the Lakehouse (e.g., S3 storage layout, IAM roles/policies, Glue, Lambda, and networking/security fundamentals) in partnership with cloud/platform teams.

• Architect and optimize datasets for large-scale, structured and semi-structured commercial datasets (e.g., sales, claims, patient, or similar), including complex cross-domain joins and slowly changing dimensions (SCD).

• Establish and enforce testing, validation, documentation, and CI/CD practices for Databricks-based analytics code, ensuring data quality, lineage, and reliability at scale.

• Lead technical design reviews and set best practices for data modeling, Databricks architecture, and AWS resource usage; mentor and provide technical guidance to data and analytics engineers.

• Mentor and coach junior developers day-to-day — pairing on code, reviewing pull requests, and working alongside them on shared deliverables to build their skills in data modeling, Databricks, and AWS.

• Act as a primary point of contact for business stakeholders, clearly explaining technical trade-offs, data model decisions, and dataset limitations in business-friendly terms.

• Partner closely with analysts, data scientists, and business stakeholders to translate ambiguous business questions into well-modeled, analytics-ready data products, and define dataset readiness and adoption criteria.

• Apply and champion data governance practices on Databricks and AWS, including documentation, lineage, access controls (Unity Catalog/IAM), and compliant handling of sensitive/regulated data.

Skills & Competencies

• Expert, hands-on experience with Databricks (notebooks, jobs/workflows, clusters, Unity Catalog) and Delta Lake (ACID tables, incremental processing, upserts/merge, Z-ordering, partitioning, performance tuning) — this is a core requirement.

• Strong expertise in data modeling for analytics — dimensional/Kimball-style star and snowflake schemas, conformed dimensions, fact tables, SCD handling, and lakehouse concepts (medallion architecture; bronze/silver/gold layers) — this is a core requirement.

• Solid, hands-on experience with AWS as the underlying cloud platform (S3, IAM, Glue, Lambda, networking/security fundamentals) supporting a Databricks Lakehouse — this is a core requirement.

• Advanced proficiency in SQL and Python for data transformation, modeling, and validation at scale.

• Hands-on experience with analytics engineering frameworks (e.g., dbt) and building governed semantic/metrics layers on top of Databricks.

• Experience with workflow orchestration (e.g., Databricks Workflows, Airflow) and engineering best practices (Git/version control, code review, CI/CD).

• Strong grounding in data governance and secure data handling (documentation, lineage, access controls via Unity Catalog/IAM, PII/PHI awareness).

• Proficiency with BI/visualization tools (Tableau/Power BI) and enabling self-service analytics for business users.

• Demonstrated ability to mentor and coach junior developers, including hands-on pairing and code review, while working alongside them as part of the same delivery team.

• Excellent verbal and written communication skills, with the ability to explain technical concepts clearly and confidently to non-technical business stakeholders.

• Strong stakeholder-management skills; comfortable leading conversations with business partners to gather requirements, manage expectations, and present findings.

Qualifications & Experience

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

• 6+ years of hands-on experience in analytics engineering, data engineering, or related roles, with demonstrated depth in Databricks, data modeling, and AWS.

• Required: significant production experience building and optimizing pipelines and data models on Databricks and Delta Lake at scale.

• Required: strong, demonstrable data modeling experience (dimensional modeling, schema design) for analytics-ready datasets.

• Required: working experience with AWS services (S3, IAM, Glue, Lambda, or similar) in a production data platform.

• Preferred: experience with dbt on Databricks and Unity Catalog for governance and access control.

• Required: demonstrated experience mentoring junior developers and working alongside them in a hands-on capacity (pairing, reviews, shared delivery).

• Preferred: experience presenting to or working directly with business stakeholders (e.g., requirements gathering, readouts, roadmap discussions).

• Preferred: prior experience leading engineers.

• Added advantage: understanding of the pharma/biopharma domain and commercial datasets (e.g., claims, sales, payer, patient, HUB/specialty pharmacy), including 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, 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 adastaffingsupport@bms.com. 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 TAEnablement@bms.com. 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.

R1605261 : Senior Analytics Engineer