Sr. BI & Insights Analyst
About The Position
As a Sr. BI & Insights Analyst, you will be responsible for providing analytical support to key clients within the business, primarily Marketing and Merchandise. Specifically, you will become a significant contributor of actionable insights which will drive marketing strategy, support with tactical initiatives, as well as improve efficiency within the organization. Your analysis and BI reporting skills will help to promote and sustain the profitable growth of the business. You are the type of individual who can energize the people around you and inspire fellow employees and shareholders with your natural curiosity and problem-solving ability. Establish a strong understanding of POS, loyalty and customer related data sources, with emphasis on delivering data driven solutions. Support our True North strategy through delivery of dashboards and reports. Assist the development of data pipelines using Synapse Analytics and SQL Server to source, transform, and load data into BI environments. Extract, manipulate and interpret data to isolate on key trends. Summarize findings into concise and informative reports and presentations. Design, automate, maintain, and enhance BI data model and reports. Support the development of sound analytical models utilizing various data sources. Understand the statistical significance of various model outputs and how to interpret them for creating business value. Support cross functional teams with knowledge of data visualization and dashboard. Provide proactive analyses on areas of the business which are influenced by customer behaviour trends. Collaborate across teams to create synergies and support with financial implications. Actively engage with data teams to continuously improve on data mart capabilities. Manage project timelines through effective communication and feedback loops. You will join an enthusiastic, fast-paced, and dynamic team at Canadian Tire. Sustained exceptional performance, innovation, creativity, insight, good judgment, and attention to detail are daily requirements.
Requirements
- University degree in quantitative discipline, master program is preferred
- 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
- Working knowledge of SQL (or PySpark)
- Experienced in data modeling techniques (dimensional modeling, star/snowflake schemas)
- Knowledge of Power BI / DAX.
- Working knowledge of Azure Synapse (or Fabric).
Nice To Haves
- MS Power BI Data Analyst Associate Certification is preferred
- MS Fabric Analytics / Data Engineer Certification is a strong asset
- Digital / Web Analytics experience is an asset
Responsibilities
- Providing analytical support to key clients within the business, primarily Marketing and Merchandise.
- Becoming a significant contributor of actionable insights which will drive marketing strategy, support with tactical initiatives, as well as improve efficiency within the organization.
- Promoting and sustaining the profitable growth of the business through analysis and BI reporting skills.
- Establishing a strong understanding of POS, loyalty and customer related data sources, with emphasis on delivering data driven solutions.
- Supporting the True North strategy through delivery of dashboards and reports.
- Assisting the development of data pipelines using Synapse Analytics and SQL Server to source, transform, and load data into BI environments.
- Extracting, manipulating and interpreting data to isolate on key trends.
- Summarizing findings into concise and informative reports and presentations.
- Designing, automating, maintaining, and enhancing BI data model and reports.
- Supporting the development of sound analytical models utilizing various data sources.
- Understanding the statistical significance of various model outputs and how to interpret them for creating business value.
- Supporting cross functional teams with knowledge of data visualization and dashboard.
- Providing proactive analyses on areas of the business which are influenced by customer behaviour trends.
- Collaborating across teams to create synergies and support with financial implications.
- Actively engaging with data teams to continuously improve on data mart capabilities.
- Managing project timelines through effective communication and feedback loops.
Benefits
- Comprehensive benefits and retirement programs
- Performance incentives
- Continuing Education Programs
- Other perks to support your well-being
- Career growth opportunities
- Product discounts
- Store discounts
- Supported learning through our Triangle Learning Academy
- Canadian Tire Profit Sharing
- Retirement and savings programs for eligible employees
- Mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families
- Total well-being, and mental health tools and resources for all employees
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
