Business Intelligence Analyst (Ref 20241029)

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
21 hours ago