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
Minimum 4 years experience working in analytical or data field
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)
Why you should apply
You will help patients in their fight against serious diseases
You will be part of a company that encourages excellence and innovation, respects diversity, develops leaders and values its employees.
You’ll get a competitive salary and a great benefits package including, but not only, an annual bonus, pension contribution, family health insurance, 27 days of annual leave , access to BMS Cruiserath on-site gym and life assurance
#LI-Hybrid
We hire for skills and capabilities, not just credentials – if this role excites you, but doesn’t perfectly match your resume, we encourage you to apply anyway.
How We Work
Where you work matters – because collaboration, innovation and patient impact happen in many settings. Our roles are structured across four work models: site-essential, site-by-design, field-based and remote-by-design. The model assigned to this role is based on its core responsibilities. Learn more at https://careers.bms.com/ways-of-working.
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 qualified applicants with arrest and conviction records, pursuant to applicable laws in your area.
For roles based in Los Angeles County only: 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/
For roles based in Washington State only: If you live in or expect to work from Washington State if hired for this position, please visit this page for important information about the Washington Fair Chance Act.
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 this posting is missing required information required by local law or incorrect, contact BMS at TAEnablement@bms.com with the Job Title and Requisition number. Do not send application-related inquiries to this email. To check your application status, please login to your Candidate Home Account.
R1608306 : Manager, Analytical Engineer