Manager, Analytical Engineer

Bristol Myers Squibb • New Brunswick, NJ

1d • Hybrid

About The Position

The Manager of Analytics Engineering provides hands-on technical expertise to develop, deploy, and maintain both core data models and core data layer infrastructure. This role is ideal for someone who thrives on building robust, scalable, and well-documented data models and pipelines, while also enabling self-service analytics across the organization. We are seeking a highly skilled Analytical Engineer to join our team. This role bridges the gap between data engineering and data analytics, focusing on data architecture, quality, and governance. The ideal candidate will have experience designing and maintaining dimensional data models (star/snowflake schemas), including fact and dimension table design, slowly changing dimensions (SCD), and conformed dimensions across multiple subject areas. This role requires strong technical expertise in data transformation, modeling, and pipeline optimization. Additionally, a successful candidate is an excellent communicator who can effectively explain complex technical information to a wide variety of stakeholders.

Requirements

• BA/BS or higher required
• Computer Science, Physics, Math, Data Science, Pharmaceutical Science, or Engineering area of study preferred
• Proficiency with SQL
• Experience scripting (e.g. Python/R)
• Working knowledge of DAG-based and asset-based pipeline design
• Experience with version control (e.g. Git, SVN) and Agile development
• Proven analytical and problem-solving ability
• Excellent communications and presentation skills.
• Ability to explain complex analyses and outcomes to both technical and non-technical stakeholders

Nice To Haves

• Experience working in or alongside agile/scrum teams highly desired
• Expertise gathering requirements to understand business needs and define technical solutions
• Hands-on experience with dbt a plus
• Familiarity with our toolkit desired: work information process tools (JIRA, Confluence, ServiceNow, MS suites); data-related tools (Databricks, DBT, )

Responsibilities

• Collaborate with the business to gather requirements and deliver data-products to enable data-informed decision-making.
• Develop a centralized data-layer to deliver data-products at scale to the business.
• Incorporating domain-specific data marts into a centralized, foundational core.
• Harmonize data across manufacturing sites, software, and platforms for enterprise-level consumption.
• Designing highly organized and scalable architectural solutions to drive efficiency.
• Define orchestration strategies across multiple data domains.
• Work within a governed metadata framework where documentation is a delivery requirement.
• Work within Data Build Tool (dbt) to deliver documented, tested, and DRY (“don’t-repeat-yourself”) code.
• Follow analytical lifecycle process and quality frameworks to deliver accurate data to internal consumers on-time.
• Focus on innovative solutions to increase speed-to-delivery and accelerate business decision-making.

Benefits

• Health Coverage: Medical, pharmacy, dental, and vision care.
• Wellbeing Support: Programs such as BMS Well-Being Account, BMS Living Life Better, and Employee Assistance Programs (EAP).
• Financial Well-being and Protection: 401(k) plan, short- and long-term disability, life insurance, accident insurance, supplemental health insurance, business travel protection, personal liability protection, identity theft benefit, legal support, and survivor support.
• Work-life benefits include: Paid Time Off US Exempt Employees: flexible time off (unlimited, with manager approval, 11 paid national holidays (not applicable to employees in Phoenix, AZ, Puerto Rico or Rayzebio employees) Phoenix, AZ, Puerto Rico and Rayzebio Exempt, Non-Exempt, Hourly Employees: 160 hours annual paid vacation for new hires with manager approval, 11 national holidays, and 3 optional holidays
• Based on eligibility, additional time off for employees may include unlimited paid sick time, up to 2 paid volunteer days per year, summer hours flexibility, leaves of absence for medical, personal, parental, caregiver, bereavement, and military needs and an annual Global Shutdown between Christmas and New Years Day.

What This Job Offers

• Job Type: Full-time
• Career Level: Manager