Manager, Analytical Engineer

Bristol Myers Squibb; New Brunswick (NJ); On-site; USD 97,000 - 117,000; Full time

Benefits offered by this job

Health coverage

Wellbeing programs

401(k) retirement plan

Paid time off

Job summary

Bristol Myers Squibb is seeking an Analytical Engineer to join our data analytics team in New Jersey. This role focuses on building robust data models, pipelines, and core data layer infrastructure to enable self-service analytics across the organization.

You will bridge data engineering and analytics, emphasizing data quality and governance. The ideal candidate will design dimensional models (star/snowflake), handle slowly changing dimensions, and collaborate with stakeholders across functions.

Qualifications

• BA/BS or higher required.
• CS, Physics, Math, Data Science, Pharmaceutical Science, or Engineering preferred.
• Proficiency with SQL.
• Experience scripting with Python or R.
• Knowledge of DAG-based and asset-based pipeline design.
• Experience with version control (Git, SVN) and Agile development.
• Analytical and problem-solving abilities.
• Experience in agile/scrum environments preferred.
• Ability to gather requirements and translate into technical solutions.
• Excellent communication and presentation skills; able to explain analyses to diverse stakeholders.
• Hands-on dbt experience a plus.
• Familiarity with JIRA, Confluence, ServiceNow, MS Office; data tools like Databricks and DBT.

Responsibilities

• Collaborate with business to gather requirements and deliver data-products at scale.
• Develop a centralized data-layer and harmonize data across domains.
• Incorporate domain data marts into a central core.
• Harmonize data across manufacturing sites, software, and platforms.
• Design scalable architectural solutions to drive efficiency.
• Define orchestration across multiple data domains.
• Work within a governed metadata framework with documentation as a deliverable.
• Utilize dbt to deliver documented, tested, DRY code.
• Follow analytical lifecycle processes to deliver accurate data on time.
• Focus on speed-to-delivery and enable better decision-making.

Skills

SQL

Python/R

Data pipelines

Version control

Agile

Analytical thinking

Communication

dbt

JIRA/Confluence

Databricks

Education

BA/BS or higher

CS/Physics/Math/Data Science/Engineering

Tools

Databricks

DBT

Git

Confluence

MS Office

Job description

Working with UsChallenging. 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.

Working with UsChallenging. 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. 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.

Key Responsibilities And Major Duties

• 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.

Qualifications/Degree/Certification/Licensure

• 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
• Experience working in or alongside agile/scrum teams highly desired
• Expertise gathering requirements to understand business needs and define technical solutions
• Excellent communications and presentation skills. Ability to explain complex analyses and outcomes to both technical and non‑technical stakeholders
• 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,)

Compensation Overview

Devens - MA - US $106,220 - $128,709 New Brunswick - NJ - US $96,560 - $117,008

The starting compensation range(s) for this role are listed above for a full‑time employee (FTE) basis. Additional incentive cash and stock opportunities (based on eligibility) may be available. The starting pay rate takes into account characteristics of the job, such as required skills, where the job is performed, the employee’s work schedule, job‑related knowledge, and experience. Final, individual compensation will be decided based on demonstrated experience.

Eligibility for specific benefits listed on our careers site may vary based on the job and location. For more on benefits, please visit https //careers.bms.com/life-at-bms/.

Benefit offerings are subject to the terms and conditions of the applicable plans in effect at the time and may require enrollment. Our benefits include

• 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.

All global employees full and part‑time who are actively employed at and paid directly by BMS at the end of the calendar year are eligible to take advantage of the Global Shutdown.

• Eligibility Disclosure The summer hours program is for United States (U.S.) office‑based employees due to the unique nature of their work. Summer hours are generally not available for field sales and manufacturing operations and may also be limited for the capability centers. Employees in remote‑by‑design or lab‑based roles may be eligible for summer hours, depending on the nature of their work, and should discuss eligibility with their manager. Employees covered under a collective bargaining agreement should consult that document to determine if they are eligible. Contractors, leased workers and other service providers are not eligible to participate in the program.

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.

R1605193 Manager, Analytical Engineer