BI Visualization & Reporting Analyst I

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: careers.bms.com/working-with-us.

Summary:

The Business Intelligence (BI) Visualization & Reporting Analyst position is a specialized role that focuses on developing and delivering insightful and visually impactful dashboards, reports, and modular ETL/ELT design and rigorous data quality controls (e.g., checks for duplicates, nulls, referential integrity) and uses AI tools (Copilot) to improve efficiency. The BI Visualization & Reporting Analyst collaborates with cross-functional teams, gathers requirements, designs and develops visualizations, performs data analysis, and ensures accurate and timely reporting to support data-driven decision-making and drive business growth for BMS globally.

​Roles & Responsibilities:

• Design configurable, modular, and parameterized ETL/ELT flows (avoid hardcoding) with idempotent tasks and clear separation of extract/transform/load.
• Implement data quality checks across core dimensions (accuracy, completeness, consistency, timeliness, validity, uniqueness) using SQL/Python; prevent duplication/drops and maintain referential integrity.
• Use SQL and Python to understand current data processing steps and recommend simpler, more efficient alternatives; contribute to runbooks and data contracts.
• Stay updated on trends in data visualization, BI tools, ETL/DataOps practices, and reporting methodologies; leverage Copilot to accelerate code scaffolding, unit tests, and documentation.
• Collaborate with stakeholders to gather business requirements, understand key metrics and identify reporting and visualization needs. Partner with senior analysts to design interactive and user-friendly dashboards, reports and visualizations using BI tools
• Create visually appealing and informative visualizations that communicate complex data sets and insights to non-technical stakeholders
• Perform data analysis to uncover patterns and insights that support strategic decision-making and business performance optimization
• Stay updated with emerging trends, technologies, and best practices in data visualization, BI tools and reporting methodologies​

Skills and competencies:

• Working knowledge of data visualization best practices, principles of effective design and user experience (UX) considerations.
• Experience with data analysis, interpretation and visualization to derive actionable insights from complex datasets
• Familiarity with data extraction, transformation and loading processes, data governance and data quality management
• Strong SQL fundamentals (joins, window functions, CTEs) and basic Python (pandas) for profiling, transforms, and QC automation.
• Ability to design and execute quality checks (nulls/range/duplicates/referential integrity) and monitor freshness/timeliness.
• Understanding of dimensional modeling (facts/dimensions, grain selection, surrogate keys) and basic SCD Type‑1/Type‑2 concepts.
• Awareness of parameterization and environment promotion (Dev/Test/Prod) principles for pipelines; familiarity with Git‑based workflows is a plus.
• Solid communication skills with the ability to transparently share task plan, perceived priority, need for help etc.
• Familiarity with the biopharma industry a plus , including knowledge of relevant data sources and KPIs
• Ability to use AI tools (e.g., Copilot) to increase efficiency and accelerate learning.

Experience :

• We welcome a bachelor's or master's degree in a relevant field such as Business Analytics, Data Science, Computer Science, or a related discipline.
• Proven experience (typically 0 to 2 years - work/internships/projects) in ETL pipeline, data exploration, QC design and BI visualization.
• Have a strong commitment to a career in technology with a passion for healthcare
• Proficiency in BI tools such as Power BI (semantic models, DAX basics, RLS awareness desirable)
• Experience with data analysis, visualization, and report development; ability to profile sources and document grain/keys.
• Knowledge of data modeling, SQL, and data manipulation techniques.
• Good to have familiarity with Python coding and its libraries like Pandas, Numpy, Matplotlib, Streamlit/DASH etc.,
• Developing and optimizing prompts for AI systems, applying basic skills in generative AI are a plus

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.

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 [email protected]. Visit careers.bms.com/eeo-accessibility to access our complete Equal Employment Opportunity statement.

Candidate Rights

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/

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 you believe that the job posting is missing information required by local law or incorrect in any way, please contact BMS at [email protected]. Please provide the Job Title and Requisition number so we can review. Communications related to your application should not be sent to this email and you will not receive a response. Inquiries related to the status of your application should be directed to Chat with Ripley.