Associate BI Developer

Company Overview

Alimentation Couche-Tard Inc. (ACT) is a global Fortune 200 company. A leader in the convenience store and fuel space with over 16,700 stores in 31 countries, serving more than 9 million customers each day.

Position Summary

We are looking for an Associate BI Developer with a collaborative, “can-do” attitude and strong focus on Power BI development and data governance to join our growing analytics team. The one who is committed & strives with determination and motivation to make their team successful. Associate BI Developer who has experience implementing reporting solutions as part of a greater data visualization strategy. This role is responsible for hands on sourcing, manipulation, and delivery of reports from enterprise business systems to the business stakeholders. This role will help drive Circle K’s next phase in the business journey by transforming data to achieve actionable business outcomes. In this role, you will design, develop, and maintain BI solutions, create insightful dashboards, and establish best practices for data governance, security, and quality across the organization reports primarily using Power BI as tool and other reporting tools and rationalization process within the BI team.

Key Responsibilities

• Design, develop, and deploy Power BI dashboards, reports, and data models
• Support and monitor the existing reports in maintenance with clear documentation
• Optimize DAX queries and Power BI performance for scalability and responsiveness
• Automate the existing reports by removing manual steps and adhere reporting best practices
• Supports in analyzing reports, admin activities, usage monitoring, and licensing costs optimization
• Write custom scripts to extract data from unstructured/semi-structured sources from data warehouse or BI Cubes or from Snowflake
• Skilled in dashboard deployment, report consolidation, and enhancing report usability for end users
• Work with data engineers to define and validate data from the data sources for Power BI consumption
• Collaborate with business stakeholders to define KPIs and build self-service BI tools
• Proactive and clear communication about the report status with the stakeholders

Preferred Qualifications

• Microsoft Certified: Data Analyst Associate or equivalent Power BI certification
• Hands-on experience with Microsoft Power BI (including Power Query, DAX, dataflows, etc.)
• Working Knowledge of Dev-Ops processes (CI/CD), Azure DevOps, Git/Jenkins version control tool, reporting and maintenance of BI reports and SQL scripting
• Hands-on experience in extracting data from databases like (Azure SQL DB, MySQL/, Cosmos DB etc.), SharePoint, and Python/Unix shell scripting
• In-depth knowledge of report design, development and maintenance, data extraction from DWH and cubes layer and dimensional data modeling concepts
• Familiarity with data warehousing concepts and cloud data platforms (Azure, Snowflake, etc.) and their services like Azure Synapse Analytics, Azure Analysis Services, Azure Databricks, Azure SQL DW/Synapse
• Excellent communication and stakeholder management skills with Strong analytical abilities
• Self-starter and motivated with ability to work in a fast-paced development environment
• Proficiency in the development environment, including IDE, database server, GIT, Continuous Integration, unit-testing tool, and defect management tools

Keywords