Business Intelligence Analyst (Ref 20241029) Job at Exchange Solutions, Canada

ZlI4ZW9OUzdqZlp3WXpaSjFUbWJMZmlDSFE9PQ==
  • Exchange Solutions
  • Canada

Job Description

Job Description

The Senior BI Analyst role is part of the Analytics and Optimization team, reporting to the Manager of BI Analytics. This position involves managing and delivering reporting and analytics needs. The analyst will collaborate with various teams to provide insights that support all business areas, including enhancing loyalty programs and operational analytics for clients using our loyalty products. Responsibilities include handling all stages of reporting projects, from solution and data design to data preparation, investigation, and creating advanced dashboards.

This role offers a unique opportunity to join a dynamic team of analytical professionals who work with Business and Technology to create innovative, value-adding customer engagement solutions. It’s ideal for motivated individuals looking to deepen their expertise in retail, customer behavior, and analytics.

What you bring:

Advanced technical skills with expertise in SQL, Tableau, and other data manipulation and modeling tools.

Extensive experience in data architecture, data modeling, data quality, and data analytics.

Analytical mind set and hands on experience in campaign analytics and customer analysis preferably in a fast-moving retail like pharmacy, fuel retailer or grocery.

Strong understanding of data visualization best practices and design principles.

Responsibilities:

Work on BI initiatives from planning to deployment and provides support throughout the products lifecycle.

  • Conduct analysis, planning for product reporting requirements and user needs. Design, architect, and develop data models, table relationships, queries, KPIs and measures.
  • Based on design requirements, design and develop advanced dashboards and self-serve tools using Tableau.
  • Troubleshoot BI and reporting issues, conduct data integrity and data quality assessment.
  • Generate analytical insights that drive performance of loyalty programs.
  • Communicate analytical findings to peers within Analytics team, and, on occasions, to partners from business and technology.
  • Lead developing processes for standardization and creation of scalable solutions.
  • Contribute to the overall operations and culture of the company, fostering our values and policies.

Qualifications – education, skills & experience

  • Graduate degree in Computer Science, Engineering or equivalent work experience
  • 6+ years of expert-level experience with Tableau and other BI tools
  • 6+ years of expert-level hands-on in technical Skills:
  • Expert understanding of relational data (i.e. SQL/Oracle/PostgreSQL) and hands-on experience writing custom queries. Experience with Snowflake preferred.
  • Strong skills pertaining to reporting data models design, data extraction and data manipulation.
  • Expert SQL query writing, debugging, and tuning skills
  • Practical knowledge in data investigation and checking data quality of large datasets
  • Experience with production level data volumes
  • Excellent troubleshooting skills in high pressure situations
  • Ability to take complex data and visualize it to a business story.
  • Ability to find creative solutions to solve analytical and data problems.
  • Ability to develop analytical frameworks and generate / communicate business insights.
  • Attention to detail, high aptitude for problem solving and a natural interest in understanding and explaining consumer behavior / business.
  • Proficiency with Python is an asset

Job Tags

Work experience placement,

Similar Jobs

LocumJobsOnline

Locum Physician (MD/DO) - Nurse Practitioner in Houston, MO Job at LocumJobsOnline

 ...email the PROVIDER two forms to complete- *PLEASE NOTE THAT THE PROVIDER HAS 48 HOURS TO COMPLETE OR THEY WILL BE REDIRECTED* the Docusign VES Application- instructions will be sent to the agency to relay to the provider.Electronic Signature Form.AHSA will email your agency... 

UP Health System - Portage

Registered Nurse - Emergency Department Job at UP Health System - Portage

 ...Annual Influenza Vaccination or Declination Required Position Details: 0.9 FTE (36 hours per week) Night/swing/day shifts 12 hour shifts Every 3rd weekend Christmas odd years Posted for Internal Applicants only: May 14 19, 2025 at 11:35 a.m.... 

DoorDash

Director, Enterprise Ad Sales (San Francisco) Job at DoorDash

 ...largest advertising partnerships. This rapidly growing team aims to build an industry-leading ads and promotions business across DoorDashs Restaurant offerings, making it the premier platform for merchants and brands to reach local customers in a mutually beneficial... 

VensureHR

Butler - PA Job at VensureHR

 ...Position Summary In your role as Butler , it is imperative that you meticulously attend to all the personal needs of the esteemed guests that have been entrusted to your care. In preparation for their arrival, it is your responsibility to reach out to them and... 

City of Santa Ana, CA

Correctional Officer Job at City of Santa Ana, CA

 ...inmates and staff in a direct supervision correctional environment. Adheres to state and...  ...equivalent. Sufficient training and/or experience conducive to the skills and abilities listed...  ..., nights, holidays, and weekends. Officers will work any time of day as required,...