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

dHlCRUhkZ3lvUSthNWpOMlRVQ0h1WndFT2c9PQ==
  • 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

Axiom Staffing Group

Bilingual (French) Customer Service Rep Job at Axiom Staffing Group

 ...and personable Bilingual Customer Service Representative who can communicate fluently in Canadian French and English. This role is essential in supporting our French-speaking customers, ensuring their ques Customer Service, French, Bilingual, Service, Retail, Staffing,... 

Arrow Healthcare Staffing

Travel Nurse RN - Clinic - $2,397 per week Job at Arrow Healthcare Staffing

 ...Arrow Healthcare Staffing is seeking a travel nurse RN Clinic for a travel nursing job in Saratoga Springs, New York. Job Description...  ...-free stipend amount to be determined. Posted job title: RN:Outpatient Clinic,19:00:00-07:00:00 About Arrow Healthcare Staffing... 

Disability Solutions

Research Assistant, Division of Hematology & Oncology, College of Medicine Job at Disability Solutions

 ...University of Cincinnati ranks among the nation's best urban public research universities. Home to 53,235 students, nearly 12,000 faculty...  ...Hematology and Oncology, is recruiting a part-time Research Assistant. Essential Functions Conduct online literature... 

Kashable

Marketing Intern (Paid) Job at Kashable

 ...Entry level marketing internship in a fast-growing FinTech Company Introduction: Kashable is a fast growing, venture-backed Fin...  ...the gamut from Fortune 500 companies and small businesses to nonprofits and governments. We are a dynamic, ambitious, and hard-working... 

Maury County Public Schools

25/26 School Year :ESL Teache Job at Maury County Public Schools

 ...needs and evaluate their progress through homework and assessments. ESL teacher skills also include building positive relationships with...  ...requirements (e.g. learning disabilities) Research new teaching methods for teaching English as a second language Create a supportive...