Data Engineer – Business Intelligence

Working with Us
Challenging. 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:

Position Overview:
Join the Business Intelligence and Technology Insights, Reporting and Analytics team as a Data Engineer, where you will design, develop, and support robust data solutions. We are seeking a hands-on Microsoft Power BI developer who is passionate about building and optimizing business analytics solutions within the Microsoft ecosystem. This role focuses on transforming raw data into scalable, efficient, and insightful dashboards.

Key Responsibilities:

• Design and develop scalable data products, ingestion pipelines, and application programming interface (API) connections across diverse sources such as Microsoft SQL Server, web APIs, Microsoft OneLake, and Microsoft Fabric Dataflows
• Cleanse, join, and standardize data using Microsoft Power Query, Structured Query Language (SQL), and Python to provide consistent and reusable reporting assets
• Contribute to analytical data models, including star schema and snowflake models, defining relationships, hierarchies, and implementing security measures such as row-level and object-level security
• Build calculations, key performance indicators (KPIs), and business measures using Data Analysis Expressions (DAX); integrate Python and utilize artificial intelligence tools for analytics and insights
• Create and deploy Microsoft Power BI dashboards that follow usability, accessibility, and design best practices, ensuring solutions are optimized for enterprise use
• Tune queries, data models, and reports for improved performance, while adhering to governance standards for data certification, metadata, and naming conventions
• Support enterprise standards for Power BI deployment workflows and data management activities
• Assist with troubleshooting and user training on Microsoft Power Platform capabilities
• Contribute to process improvements and keep current with developments in data engineering and analytics

Qualifications & Experience:

• Three to five years in data engineering, business reporting, or analytics roles
• Proficient in Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, Structured Query Language (SQL), and Python
• Experience working in global teams or fast-paced business environments is an advantage
• Experience integrating and managing data across enterprise technology platforms
• Understanding of database technologies, such as Amazon RedShift, PostgreSQL, Oracle, and MongoDB
• Demonstrated ability to deliver secure and scalable data solutions and automation
• Familiarity with data governance practices and implementing row-level security
• Experience with agile development methodologies, such as Kanban or Scrum
• Effective communicator skilled in gathering requirements and supporting users

Nice to Have:

• Experience or knowledge of enterprise data governance frameworks
• Exposure to embedding Microsoft Power BI dashboards into applications or web portals
• Experience with Bonita Business Process Management, Amazon Web Services (AWS), and cloud-based database platforms

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 Visit 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: 

Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.