BI Specialist and Data Analyst

BI Specialist and Data Analyst

Position Summary

As a BI Specialist & Data Analyst, you will play a key role in data analysis, reporting and analytics tools to support strategic decision-making within the business. You will work closely with different departments to identify and prioritize data-related initiatives, drive data-driven decision-making across the organization, and ensure alignment with overall business strategy and goals.

Job Responsibilities

  • Analyze the needs in collaboration with the different internal teams to understand their reporting and data analysis requirements, identifying the relevant KPIs (key performance indicators);
  • Design and develop interactive reports and dashboards using Microsoft Power BI to provide actionable insights to stakeholders;
  • Extract and transform data using SQL to extract, cleanse and transform data from multiple sources, ensuring its integrity and quality;
  • Model data by creating efficient and optimized data models to facilitate analytics and ad-hoc queries;
  • Ensure the ongoing maintenance of existing reports and dashboards, ensuring their accuracy and performance;
  • Continuously monitor and evaluate the effectiveness of the tools developed;
  • Identify and prioritize data-related initiatives, thereby enabling data-driven decision-making across the organization while ensuring alignment with overall business strategy and objectives;
  • Train users on the use of reports and dashboards, and provide technical support to resolve any issues;
  • Lead initiatives to improve data literacy across the organization, enabling colleagues to become more effective at analyzing and interpreting data;
  • Stay up to date on the latest trends in Business Intelligence, Power BI and SQL, and propose improvements to optimize processes and analytics.

Education and experience required

  • University degree in computer science, data analytics, engineering science or a related field;
  • Hands-on experience using Power BI for interactive report and dashboard design.

Key skills required

  • Statistical analysis of Microsoft SQL Server data
  • Microsoft Power Query
  • DAX Business Intelligence (BI)
  • Data Modeling
  • Microsoft Power BI
  • Strong SQL skills for data extraction, transformation and analysis;
  • In-depth understanding of the principles of data modeling and database management;
  • Ability to analyze needs and transform these requirements into business intelligence solutions.

Location

  • Boucherville, Québec, Canada

Starting salary 73,000$ annually

Build your career with us. Apply now!