BI Visualization & Reporting Analyst I

Roles & Responsibilities
• Design modular and configurable ETL/ELT pipelines with parameterization and idempotent tasks
• Implement data quality checks covering accuracy, completeness, consistency, uniqueness, and timeliness using SQL and Python
• Develop interactive dashboards and reports using Power BI
• Perform data profiling, exploration, and analysis to generate actionable insights
• Collaborate with stakeholders to gather reporting and visualization requirements
• Support dimensional data modeling including facts, dimensions, grain, and SCD Type 1/2
• Leverage AI tools such as Copilot to accelerate coding, testing, and documentation
• Contribute to runbooks, data contracts, standards, and BI best practices

Qualification
• Bachelor’s or Master’s degree in Business Analytics, Data Science, Computer Science, or a related fields

Skills
• Strong SQL skills (joins, CTEs, window functions)
• Basic Python knowledge (pandas, NumPy)
• Experience or working knowledge of Power BI, DAX basics, and semantic models
• Understanding of ETL processes, data governance, and data quality management
• Familiarity with BI visualization best practices and UX principles
• Knowledge of healthcare or biopharmaceutical data and KPIs is an added advantage
• Good communication and documentation skills

Experience
• Entry-level to early-career candidates with relevant academic or practical exposure

About the Organization
Bristol Myers Squibb is a global biopharmaceutical company focused on discovering, developing, and delivering innovative medicines that help patients prevail over serious diseases, driven by data, science, and purpose.