Senior Analytics Engineer

Bristol Myers Squibb; Hyderabad; On-site; INR 4,500,000 - 8,000,000; Full time

Job summary

Bristol Myers Squibb in Hyderabad is seeking a Senior Analytics Engineer to design, build, and scale an analytics layer on the Databricks Lakehouse, partnering with analysts and data scientists to deliver trusted insights for commercial analytics.

You will own transformation logic, dimensional models, and metrics, set data modeling standards, mentor junior engineers, and drive cost optimization across Databricks and AWS, translating complex business questions into governed data products.

Qualifications

• 6+ years of hands-on analytics engineering, data engineering, or related roles.
• Depth in Databricks, data modeling, and AWS at scale.
• Experience mentoring and working with business stakeholders.

Responsibilities

• Design, build, and own scalable analytics-layer transformations on Databricks.
• Architect analytics-ready data models (star/snowflake) and conformed dimensions.
• Own performance tuning and cost optimization of Databricks workloads.
• Design and manage AWS-based data architecture underpinning the Lakehouse.
• Architect datasets for large-scale structured and semi-structured data.
• Establish testing, validation, documentation, and CI/CD for Databricks code.
• Lead design reviews and mentor data/analytics engineers.
• Explain data model decisions to business stakeholders clearly.
• Partner with analysts/data scientists to translate business questions into data products.

Skills

Databricks

Data modeling

AWS

SQL

Python

dbt

Analytics engineering

Mentoring juniors

Stakeholder communication

Education

Bachelor's or Master's degree in Computer Science/Engineering/IS/Stats/Math

Tools

Unity Catalog

Delta Lake

dbt on Databricks

Airflow

Databricks Workflows

Git / CI/CD

Job description

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

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 [e-mail]. 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 [e-mail]. 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