Job Description

BI Analyst - Contract - 18173
About the Opportunity
The Business Intelligence Analyst will be responsible for creating reports, designing dashboards, and validating data to help inform business decisions. This role will play a critical part in developing and monitoring key performance indicators (KPIs) and metrics to drive business growth and efficiency. The analyst will work closely with stakeholders to understand their needs and align with the company and operations.
Duties include but are not limited to:

• Develop and maintain Power BI apps and dashboards to support data-driven decision-making
• Build and maintain Power Automate flows and Azure Logic Apps integrated to operational systems to enhance user experience and automate repetitive tasks
• Validate and clean data to ensure accuracy and reliability
• Merge legacy SQL and .csv data sources with Dataverse repositories into Power BI apps and paginated reports
• Maintain and migrate legacy Excel reports and workbooks using Power Query connections to Dataverse
• Collaborate with cross-functional teams and stakeholders to identify relevant metrics, KPIs, and business needs
• Gain a deep understanding of company operations to provide meaningful insights and recommendations
• Analyze data trends and provide actionable insights to drive business improvement
• Experiment with new technologies and propose use cases to enhance data analysis capabilities
• Assist in the creation and maintenance of documentation for data sources, metrics, and KPIs
• Participate in the ongoing evaluation and improvement of ERP systems, data collection, and reporting processes

About You
The successful candidate will have the following:

• Post-secondary education in Business, Computer Science, Data Science, or a related field
• 2+ years of experience in data analysis, reporting, or a similar role
• Proficiency in SQL, Microsoft Excel, Power Automate, and Power BI
• Experience with SSRS reports
• Experience developing custom data connectors and working with APIs
• Familiarity with Microsoft Dataverse, including the ability to design data models, integrate various data sources, and leverage Dataverse for complex data analysis and reporting
• Strong analytical, problem-solving, and critical thinking skills
• Ability to work with large datasets and identify trends and patterns
• Excellent attention to detail and data accuracy
• Strong communication skills, both written and verbal

About the Job

• 6-month term contract with the potential to go full-time after
• Opportunity to work with industry leaders and innovative technology solutions.
• Professional development and growth opportunities.
• A collaborative and supportive team environment.
• This position is primarily in office, would need to be able to get to Stoney Creek

LROIT
How to Apply
Please apply by clicking the Apply Now button below and follow the instructions to submit your rxc3xa9sumxc3xa9. You can also apply by submitting your rxc3xa9sumxc3xa9 directly to If you are already registered with us, please contact your Senior Recruiter. Please quote job 18173
Thank you for your interest in this role. One of our Recruiters will be in touch with you if your profile meets the requirements for the role and the expectations of our clients. Please note that all candidates must be permitted to work in Canada to be considered for this opportunity.