About the Role
As a Senior Business Analyst, Data & Insights, you will turn complex operational and business data into actionable insights through advanced analytics, reporting, and dashboard development, focusing heavily on Power BI. You will partner with cross-functional teams to identify business needs, analyze trends, automate reporting, and create scalable dashboards that provide visibility into key organizational metrics.
Responsibilities
- Design, build, and maintain interactive Power BI dashboards, reports, and data models to support operational, financial, workforce, and strategic decision-making
- Translate business requirements into meaningful reporting solutions and data visualizations that improve visibility into organizational performance
- Analyze large and complex datasets to identify trends, risks, opportunities, and business insights
- Develop and maintain automated reporting solutions, reducing manual processes and improving reporting efficiency and accuracy
- Partner with business leaders and stakeholders to define KPIs, performance metrics, and dashboard requirements
- Create scalable reporting structures and governance practices to ensure data integrity, consistency, and usability
- Perform data analysis, trend analysis, root cause analysis, and ad hoc reporting to support strategic initiatives and operational priorities
- Collaborate with cross-functional teams to improve reporting infrastructure and optimize business processes through automation and analytics
- Support executive leadership through the development of presentation-ready dashboards, reporting packages, and actionable insights
- Identify opportunities to streamline workflows and improve data accessibility through Power Automate, reporting automation, and system integration
- Assist in strategic projects and special analyses as required
Requirements
- Bachelor’s degree in Business Analytics, Finance, Data Analytics, Business Administration, Economics, Information Systems, or a related field
- 5+ years of experience in a Business Analyst, Data Analyst, Business Intelligence, FP&A, or similar analytics-focused role within a medium to large organization
- Advanced proficiency in Power BI, including dashboard creation and visualization best practices, data modeling and relationships, DAX formulas and calculated measures, and Power Query / data transformation
- Strong experience with data analysis, reporting automation, and dashboard development
- Advanced Excel skills, including complex formulas, pivot tables, and data analysis
- Experience integrating data from multiple systems and sources to create unified reporting solutions
- Strong business acumen with the ability to convert data into clear business recommendations and operational insights
- Exceptional analytical and problem-solving skills with strong attention to detail
- Ability to communicate technical findings to non-technical stakeholders and senior leadership
- Experience with ERP systems, reporting tools, and business intelligence platforms (e.g., Power BI, NetSuite, ADP, SharePoint, SQL, or similar platforms)
- Experience developing executive dashboards and KPI reporting
- Exposure to HR, recruiting, operational, or workforce analytics
- Experience in a multi-site or multi-unit business environment preferred
- Knowledge of data governance and reporting best practices
Skills
- Power BI
- Business Intelligence
- Data Visualization
- Performance Reporting
- Power BI dashboard creation
- Power BI data modeling
- DAX formulas
- Power Query
- Data Analysis
- Reporting Automation
- Dashboard Development
- Advanced Excel
- Complex formulas
- Pivot tables
- Data integration
- Business acumen
- Analytical thinking
- Problem-solving
- Attention to detail
- Communication
- ERP systems
- NetSuite
- ADP
- SharePoint
- SQL
- Power Automate
- VBA/macros
- Data automation tools
- Executive dashboards
- KPI reporting
- HR analytics
- Recruiting analytics
- Operational analytics
- Workforce analytics
- Data governance
Location
- Etobicoke Corporate Office
Work Type
- Hybrid
- Full Time
- Salary
Experience Level
- 5+ years of experience
- Senior
Education Level
- Bachelor’s degree in Business Analytics, Finance, Data Analytics, Business Administration, Economics, Information Systems, or a related field
Salary/Compensations
- $85,000 - $105,000 Annually
Benefits
- 40% child care discount for Full-time employees
- 10% child care discount for Part-time employees
- Professional development
- Tuition reimbursement
- RRSP with company match for Full-time staff
- Holiday, PTO, and Sick leave for Full-time staff
- Health insurance for Full-time staff
- Dental insurance for Full-time staff
- Vision insurance for Full-time staff
- Life insurance for Full-time staff
- Additional Bonus
About the Company
- At BrightPath Kids, part of the Busy Bees global family, we operate 250+ childcare centers across the United States and Canada.
- We are committed to providing exceptional early childhood education in safe, nurturing environments.
- Data plays a critical role in helping us make informed decisions, improve operational performance, and support strategic growth.
- Our corporate team partners across the business to transform data into meaningful insights that drive action and improve outcomes.
