BI Developer

Job Description

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.

It is an exciting time to be a part of the growing Enterprise BI team at Circle K. We are driving a well-supported cloud-first strategy to unlock the power of data reports across the company and help business stakeholders to discover, value and act on insights from reports across the globe. With our strong data visualization reports, this position will play a key role partnering with our technical development and business stakeholders to enable analytics for long-term success.

About the role

We are looking for a skilled 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. A 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.

Roles & 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

• Provide Power BI training, support, and up to date documentation for business users and conduct KT sessions for the junior resources to guide and mentor them

Job Requirements

Education

• Bachelor's degree in computer engineering, Computer Science, Data Analytics, or related field

• Master's degree preferred (MBA/MS Computer Science/M.Tech Computer Science, etc.)

Relevant Experience

• 3-4 years of experience in BI engineering or data analytics and advanced SQL programming like PL/SQL

Technical Skills

• Microsoft Certified: Data Analyst Associate or equivalent Power BI certification

• Hands-on experience with Microsoft Power BI (including Power Query, DAX, dataflows, etc.)

• Basic understanding of reporting governance and Power BI administration.

• 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

Behavioural Skills

• Delivery Excellence

• Business disposition

• Social intelligence

• Innovation and agility

• Purposeful leadership

Knowledge

• In-depth knowledge of report design, development and maintenance, data extraction from DWH and cubes layer and dimensional data modeling concepts

• Strong hands-on experience with Python/Spark scripting and shell (Unix/Linux) scripting.

• 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

#LI-DS1