Collaborate with the business to gather requirements and deliver data-products to enable data-informed decision-making. As a member of the team, develop a centralized data-layer to deliver data-products at scale to the business. Use ELT framework to transform raw or semi-structured data into a contextualized data model (preferably using DBT), proposing architectural solutions (preferably AWS) to drive efficiency. Partner with AI and ML teams to deliver the data skeleton for AI-enabled internal tools. Work within 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. Independently gather business requirements, establish measurable outcomes, and create analytical product plan translating complexity for various stakeholders. Computer Science, Physics, Math, Data Science, Pharmaceutical Science, or Engineering area of study preferred Minimum of 6 years of analytical engineering, data modeling or a similar role Proficiency with SQL, SPARK and Python Knowledge of data engineering tools (AWS, Airflow) and visualization tools (Tableau, Power BI, Looker) Experience with version control (e.g. Git, SVN) and Agile development Proven analytical and problem-solving ability Expertise gathering requirements to understand business needs and define technical solutions Ability to explain complex analyses and outcomes to both technical and non-technical stakeholders Familiarity with AI, ML, predictive modeling a plus Familiarity with our toolkit desired: work information process tools (JIRA, Confluence, ServiceNow, MS suites); data-related tools (Oracle, Redshift, PostgreSQL, CDP Impala, Athena) Proven experience in guiding large, complex projects that involve collaborating with team members from various functions. If you come across a role that intrigues you but doesn't perfectly line up with your resume, we encourage you to apply anyway. You could be one step away from work that will transform your life and career. 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. 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. BMS cares about your well-being and the well-being of our staff, customers, patients, and communities. As a result, the Company strongly recommends that all employees be fully vaccinated for Covid-19 and keep up to date with Covid-19 boosters. 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/ Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.