Business Applications Analyst

AIM KENNY U-PULL

Laval

On-site

CAD 65,000 - 95,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Paid vacation from day one

Group insurance plan

Telemedicine (24/7)

RRSP with employer matching

Tuition assistance

Referral program

Employee discounts on Kenny parts

Company events

Advancement opportunities

Job summary

Kenny U-Pull is seeking a highly analytical Business Applications & Data Analyst to design, automate, and optimize business processes using Microsoft Power Platform and SQL technologies. You will develop reports, dashboards, and data models to improve operational efficiency, collaborating with stakeholders across the organization.

Responsibilities include building Power Apps, automating workflows with Power Automate, and integrating with SQL Server, SharePoint, and REST APIs.

Qualifications

3+ years of experience developing business solutions using Microsoft technologies.
Strong experience with Power Apps (Canvas and Model-Driven Apps).
Strong experience with Power Automate cloud flows.
Advanced knowledge of SQL, including joins, subqueries, CTEs, stored procedures, and performance optimization.
Experience writing advanced DAX measures and calculations in Power BI.
Strong understanding of relational databases and data modeling.
Experience connecting Power Platform to SQL Server, SharePoint, Excel, and REST APIs.
Excellent analytical and problem-solving skills.
Strong communication skills with both technical and non-technical stakeholders.

Responsibilities

Design, develop, and maintain applications using Microsoft Power Apps.
Build and maintain automated workflows using Power Automate.
Develop, optimize, and troubleshoot SQL queries, stored procedures, and database views.
Create and maintain Power BI reports and dashboards using advanced DAX calculations.
Analyze business requirements and translate them into scalable technical solutions.
Integrate Power Platform solutions with SQL Server, SharePoint, Microsoft 365, APIs, and other enterprise systems.
Design data models that support efficient reporting and analytics.
Monitor application performance and identify opportunities for optimization.
Troubleshoot production issues and provide timely user support.
Document technical solutions, business processes, and user guides.
Participate in testing, deployment, and continuous improvement initiatives.
Ensure solutions follow security, governance, and best practices.

Skills

Power Apps

Power Automate

SQL

Power BI

Data modeling

Security governance

Analytical thinking

Stakeholder communication

Education

Bachelor's degree in Computer Science or related field

Tools

Azure SQL

SharePoint

Excel

REST APIs

Git/Azure DevOps

Power Query (M)

Dataverse

Job description

Kenny U-Pull is proud to give a second life to used vehicles. Our 27 auto recycling locations across Eastern Canada are supported by over 400 employees, all passionate about repurposing used cars and committed to a greener environment for future generations. Since 2008, we have recycled over one million vehicles, and we're just getting started!

At Kenny, we do things differently by offering our customers the opportunity to create their own self-service experience. Customers choose and remove the parts they need themselves for a fraction of the manufacturer's price, in a safe, clean, and environmentally responsible environment.

Our passion is at the heart of everything we do. We are a united and supportive company where your ambitions are also ours. Come aboard – we promise you a rewarding journey.

Job Description

We are seeking a highly analytical and technically skilled Business Applications & Data Analyst to develop, automate, and optimize business processes using Microsoft Power Platform and SQL technologies. The successful candidate will design business applications, automate workflows, develop reports and dashboards, and collaborate with stakeholders to improve operational efficiency through data-driven solutions.

What you're responsible for

Design, develop, and maintain applications using Microsoft Power Apps.
Build and maintain automated workflows using Power Automate.
Develop, optimize, and troubleshoot SQL queries, stored procedures, and database views.
Create and maintain Power BI reports and dashboards using advanced DAX calculations.
Analyze business requirements and translate them into scalable technical solutions.
Integrate Power Platform solutions with SQL Server, SharePoint, Microsoft 365, APIs, and other enterprise systems.
Design data models that support efficient reporting and analytics.
Monitor application performance and identify opportunities for optimization.
Troubleshoot production issues and provide timely user support.
Document technical solutions, business processes, and user guides.
Participate in testing, deployment, and continuous improvement initiatives.
Ensure solutions follow security, governance, and best practices.

Qualifications

To join our team

Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
3+ years of experience developing business solutions using Microsoft technologies.
Strong experience with Power Apps (Canvas and Model-Driven Apps).
Strong experience with Power Automate cloud flows.
Advanced knowledge of SQL, including joins, subqueries, CTEs, stored procedures, and performance optimization.
Experience writing advanced DAX measures and calculations in Power BI.
Strong understanding of relational databases and data modeling.
Experience connecting Power Platform to SQL Server, SharePoint, Excel, and REST APIs.
Excellent analytical and problem-solving skills.
Strong communication skills with both technical and non-technical stakeholders.

Preferred Qualifications