Senior BI Engineer

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 Data Engineering team at Circle K. We are driving a well-supported cloud-first strategy to unlock the power of data across the company and help teams to discover, value and act on insights from data across the globe. With strong BI expertise, this position will play a key role in partnering with our technical development stakeholders to enable BI dashboards and reports for the right business decision and long-term success.

We are looking for a highly motivated Senior BI Engineer with a passion for developing and supporting Power BI applications to join our team. As the BI Engineer, you will be responsible for designing, implementing, and testing the cubes/dashboards/reports, coaching, and mentoring the team, and ensuring that the team is following the industry best-practices. You will work closely with the end users, developers, and stakeholders to ensure that the project is delivered on time and within budget, by ensuring data quality and process efficiency.

Responsibilities:

• Responsible for developing, administrating, supporting, monitoring, and tuning the Power BI reports.
• Designing and Optimizing Power BI dashboards/data models to provide up-to-date and accurate reports to end the user/s.
• Designing and developing advanced multidimensional and tabular SSAS models (cubes) based on business requirement.
• Optimizing cube performance by fine-tuning measures, aggregations, partitions, and processing strategies.
• Develop, test, and deploy DAX based scripts, queries and functions in Power BI.
• Design and develop Power BI dashboards and reports and optimize the complex DAX expressions.
• Serves and implement the industry Best Practices for Power BI initiatives within organization.
• Conducts training, mentor juniors and organize user-group sessions on Power BI technology.
• Acts as primary escalation point for Power BI-related issues arises in production environment.
• Creating comprehensive documentation for SSAS models, DAX expressions, Power BI reports, and Paginated Reports to facilitate knowledge sharing within the team.
• Mentoring and providing guidance to junior team members on SSAS, DAX, Power BI, and Paginated Reports development best practices.

Required Experience & Skills

• Full-Time bachelor’s degree in engineering/technology, computer science, information technology, or related fields.
• 5+ years of relevant experience in Power BI Development experience (including DAX, Paginated Reports, Power BI Gateway, Data Security) and Power BI admin activities.
• Good hands-on experience in Data Analytics & Dashboarding/Reporting.
• Strong proficiency in SQL, SSAS/AAS tabular modeling, SSRS, and Data Fabric.
• Experience working with Azure-based BI solutions including Azure SQL, Azure Synapse, Data Factory, Databricks, Blob Storages & Data Lakes.
• Excellent problem-solving and documentations skills.
• Strong communication and collaboration skills.
• Ability to work effectively in a team and independently.
• Strong proficiency in SQL, including complex query writing and optimization.
• Proficiency in MDX and DAX for data modeling and calculations.
• Hands-on experience with SQL Server Analysis Services (SSAS) and developing OLAP and Tabular models.
• Relevant certifications on Microsoft Technologies (Microsoft Certified: Power BI developer) are a plus.

#LI-DS1