Sr. Business Intelligence Analyst

Role Overview

The Senior Business Intelligence Analyst will design and deliver impactful, user-centric dashboards and analytics solutions that transform complex data into actionable insights for decision-making. This role emphasizes data storytelling, visualization excellence, and technical rigor in modern BI platforms, supporting CPSC’s strategic initiatives such as Sentinel-driven product safety analytics. The analyst will partner with stakeholders to ensure clarity, usability, and trust in all reporting solutions.

Key Responsibilities

• Dashboard & Visualization Development

• Design and build interactive dashboards and reports in Power BI that communicate insights clearly and effectively to diverse audiences.

• Apply data storytelling principles to create visualizations that drive understanding and informed decision-making.

• Ensure dashboards are user-friendly, accessible, and optimized for performance across devices.

• Data Modeling & Transformation

• Develop robust data models ensuring accuracy, scalability, and maintainability.

• Implement ETL processes and integrate data from multiple sources, including relational databases and data warehouses.

• Apply best practices for data governance, including validation, lineage, and documentation.

• Analytics & Insight Delivery

• Translate business requirements into BI solutions that provide actionable insights and measurable impact.

• Conduct ad-hoc analyses and deliver executive-ready reports to support strategic decisions.

• Collaborate with stakeholders to refine KPIs and ensure alignment with organizational goals.

• Performance Optimization & Quality Assurance

• Monitor and optimize Power BI performance, including query tuning and resource management.

• Implement quality checks and validation processes to maintain data integrity and reliability.

• Collaboration & Continuous Improvement

• Work closely with data engineers, data scientists, and business teams to ensure seamless integration of BI solutions into workflows.

• Contribute to Agile delivery processes, participating in sprint planning, reviews, and retrospectives.

• Identify opportunities for automation and efficiency improvements in reporting and analytics.

Required Qualifications

• Education: Bachelor’s degree (or higher) in Computer Science, Information Systems, Data Analytics, Business, related field, or equivalent experience.

• Experience:

• 5+ years in business intelligence, analytics, or data visualization roles.

• Demonstrated expertise in Power BI, including data modeling, and dashboard/report development.

• Technical Skills:

• Strong understanding of data warehousing, ETL processes, and relational databases.

• Proficiency in SQL for data extraction and transformation.

• Visualization Expertise:

• Ability to design impactful, user-friendly dashboards that communicate insights effectively to technical and non-technical audiences.

Preferred Qualifications

• Experience with Azure Data Services (Data Lake, Synapse) and cloud-based BI deployments.

• Familiarity with Agile methodologies and collaborative development environments.

• Knowledge of data governance frameworks and compliance standards.

Advanced certifications in Power BI or related BI tools.