Position Summary:The Manager, Data & AI Analytics Engineering is a hands-on individual contributor responsible for designing, building, and delivering scalable data and AI-driven analytics solutions supporting Global Patient Operations (GPO).
This role plays a critical part in advancing the GPO Analytics Hub, enabling standardized, high-quality data models, cross-platform data integration, and AI/automation use cases to drive operational insights and decision-making across patient operations, manufacturing logistics, scheduling, supply chain, and workforce analytics.
Key Responsibilities:- Collaborate with cross-functional teams (SCLT, APH Ops, BI&T, Manufacturing, Supply Chain) to translate business needs into scalable data solutions
- Design, develop, and maintain scalable ETL pipelines and data models using SQL, Python, dbt, and Databricks (Medallion architecture - bronze/silver/gold)
- Build and optimize complex SQL transformation pipelines integrating data from SAP, Oracle, Salesforce, AWS Athena, PostgreSQL, and other enterprise systems
- Develop and maintain curated datasets and semantic models supporting the GPO Analytics Hub and enterprise reporting
- Design and optimize Power BI and Tableau datasets/dashboards to enable consistent KPI reporting and executive analytics
- Partner with analytics and business teams to standardize KPIs, definitions, and data logic across GPO
- Enable and support AI/automation initiatives, including predictive analytics, Copilot, and agent-based solutions
- Develop data harmonization and reconciliation pipelines to unify cross-system operational data
- Build reusable frameworks for ETL orchestration, API integration, automated validation, and operational alerting
- Implement data quality checks, monitoring, and production-ready deployment strategies
- Optimize performance of large-scale datasets across PostgreSQL, Impala/Cloudera, and Athena environments
- Support platform migration initiatives (e.g., Tableau to Power BI) and enterprise data standardization efforts
- Lead requirements gathering, UAT coordination, stakeholder reviews, and production rollouts
- Maintain documentation, metadata mapping, and data lineage to support governance and transparency
- Provide technical leadership, code reviews, and best practices guidance (no direct reports)
Key Qualifications & Experience:- Bachelor's or Master's degree in Computer Science, Data Engineering, Analytics, or related field
- 8+ years of experience in data engineering or analytics engineering
- Strong hands-on expertise in SQL and Python, with experience in large-scale data environments
- Experience with Databricks, dbt, and cloud data platforms (AWS/Azure)
- Proven ability to design and optimize ETL pipelines, data models, and semantic layers
- Experience with Power BI and/or Tableau
- Understanding of AI/ML data workflows and integration requirements
- Experience in life sciences, pharmaceutical, or regulated environments
- Hands-on experience with GenAI, LLMs, or agent-based AI solutions
- Experience with Data Ops, CI/CD, and Git-based development workflows
- Familiarity with Domino Data Lab or similar platforms
- Knowledge of data governance, metadata, and lineage frameworks
- Strong hands-on technical expertise with end-to-end ownership
- Ability to translate business requirements into scalable data solutions
- Collaborative and proactive approach across cross-functional teams
- Strong problem-solving and system design skills
- Focus on data quality, consistency, and usability
Compensation Overview:Seattle - WA: $105,560 - $127,916
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.
On-site ProtocolBMS 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.
