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

Shavano Family Practice

Remote Account Assistant Job at Shavano Family Practice

We are looking to employ an efficient and detail-oriented accounts assistant to assist our accounting firm with all clerical and basic accounting tasks. The Accounts Assistant's responsibilities include updating our client records, responding to clients' inquiries in a ...

Stevens Institute of Technology

Research Engineer, Systems & Enterprises Job at Stevens Institute of Technology

 ...Time type Part timePosted on Posted 4 Days AgoJob requisition id RQ28828Job DescriptionThe Research Engineer, in support of the Accenture Project within the Department of Systems and Enterprises, will have the following responsibilities:Develop the research... 

NavitsPartners

RN Obstetrics Labor Care Nurse - TXRN Job at NavitsPartners

 ...RN Obstetrics Labor Care Nurse Description: The RN Obstetrics Labor Care Nurse is responsible for assisting women during labor and ensuring a safe delivery. This role includes monitoring maternal and fetal health, administering medications, assisting with the delivery... 

Elliot Health System

Elliot Health Systems - Fitness Specialist - Welliot at Rivers Edge - Full Time Job at Elliot Health System

30 hours Monday-Friday Variable schedule. Fitness Center hours are 6:30a - 7p Mon-Thu, 6:30 - 2:00 Fri *Ability to work weekdays between 330pm-7 Elliot Fitness Services Elliot Fitness Services consists of 3 centers that include employee and community gym membership, group...

Title Resources Guaranty

Title Specialist Job at Title Resources Guaranty

 ...Description About the Job: Dive into a dynamic career with Title Resources Group, one of the nations most prominent and rapidly...  ...applications required. Who We Are: Title Resources Group is a Company that puts people first! We take pride in our culture, and...