Business Applications Analyst

Job summary

Design, develop, and maintain business applications and automated workflows using the Microsoft Power Platform and SQL. Collaborate with stakeholders to create data-driven reports and dashboards that optimize operational efficiency.

Job details

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: Experience with Microsoft Dataverse. Knowledge of Power BI administration and workspace management. Experience with Azure SQL or Azure Data Services. Familiarity with Power Automate Desktop (RPA). Experience with version control (Git or Azure DevOps). Knowledge of Power Query (M language). Experience working in Agile/Scrum environments. Microsoft Power Platform or Power BI certifications are considered an asset. Additional Information The advantages (!): Eligible for paid vacation from the first day; Comprehensive group insurance plan; Telemedicine (Unlimited access to a doctor 24/7); Group RRSP with employer matching contributions; AIM tuition assistance grants; Referral program; Exclusive employee discounts on parts at any Kenny location; Company-organized events throughout the year (barbecue, Christmas party, etc.). Exceptional advancement opportunities.

What you’ll do

Design, develop, and maintain business applications and automated workflows using the Microsoft Power Platform and SQL. Collaborate with stakeholders to create data-driven reports and dashboards that optimize operational efficiency.

Requirements

Requires a Bachelor's degree in a technical field and over 3 years of experience with Microsoft Power Platform and advanced SQL. Candidates must be proficient in DAX for Power BI and have strong analytical and communication skills.

Benefits

• Paid vacation from the first day • Comprehensive group insurance plan • Telemedicine • Group RRSP with employer matching contributions • AIM tuition assistance grants • Referral program • Employee discounts on parts • Company-organized events

Listed skills

• Technical Documentation · Preferred
• Power BI · Preferred
• SQL · Preferred
• REST APIs · Preferred
• Microsoft 365 · Preferred
• SharePoint · Preferred
• Business analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Microsoft Power Apps
• Power Automate
• Power BI
• SQL
• DAX
• Data Modeling
• Relational Databases
• REST APIs
• SharePoint
• Microsoft 365
• Business Analysis
• Technical Documentation

Job areas

• Data & Analytics
• Technology
• Software
• Environmental & Sustainability