Analytics Engineering Manager: Data Architecture & Pipelines

Biopharma Careers; New Brunswick (NJ); On-site; USD 96,000 - 117,000; Full time

Benefits offered by this job

Health Coverage

Wellbeing Support

Financial Well-being

Paid Time Off

Job summary

Bristol Myers Squibb is seeking an Analytical Engineer to design and maintain dimensional data models and robust data pipelines in New Jersey. The role bridges data engineering and analytics, ensuring data quality, governance, and self-service access for diverse stakeholders.

The ideal candidate will implement star/snowflake schemas, SCDs, and conformed dimensions, while coordinating with data teams to optimize transformation and delivery. Strong communication is essential for success.

Qualifications

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

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

Skills

SQL

Python/R

DBT

Git/SVN

Agile/scrum

Requirements gathering

Communication

dbt documentation

JIRA/Confluence

Databricks

Education

BA/BS or higher

Data Science/Engineering focus

Tools

Databricks

DBT

MS Office

Job description

Bristol Myers Squibb is seeking an Analytical Engineer to design and maintain dimensional data models and robust data pipelines in New Jersey. The role bridges data engineering and analytics, ensuring data quality, governance, and self-service access for diverse stakeholders.

The ideal candidate will implement star/snowflake schemas, SCDs, and conformed dimensions, while coordinating with data teams to optimize transformation and delivery. Strong communication is essential for success.