BI Analyst (Sr.) - FOP Experts Conseils inc.

Bilinguallink; Longueuil; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive compensation

Group insurance

Professional liability insurance

Remote-work flexibility

3 weeks vacation

3 paid sick days

Transportation allowance

Career advancement

Ongoing training

Job summary

FOP CONSULTANTS is seeking BI Analysts to analyze information needs, develop BI solutions, design data models and dashboards, and ensure data quality. The role involves automating data pipelines and supporting users to leverage data effectively.

The candidate should have a university degree, extensive IT experience, BI analyst tenure, and relevant certifications, with proficiency in Power BI, SQL, and Azure DevOps, and fluency in French and English.

Qualifications

• University degree in computer science, management or any related discipline.
• Minimum ten (10) years of experience in information technology.
• Eight (08) to fifteen (15) years of experience as a BI Analyst.
• Experience with one of the following frameworks: Scrum, Kanban, Lean, DSDM, SAFe, Nexus.
• Hold one of the following certifications: DP-700, Certified Analytics Professional (CAP).
• Hold one of the following certifications (an asset): Certified Business Intelligence Professional (CBIP), AI-102.
• Experience with one of the following tools: Power BI, Microsoft Fabric, SQL, Azure DevOps.
• Experience in Canadian public or private organizations.
• Language: French and English

Responsibilities

• Analyze information needs and define indicators and calculation rules.
• Design and develop data models, reports and dashboards.
• Develop and maintain data ingestion and transformation pipelines (ETL/ELT).
• Ensure the quality, consistency and reliability of data and deliverables.
• Optimize the performance of models, queries and reports.
• Document models, data dictionaries and operating procedures.
• Support business users and foster analytical self-sufficiency.

Job description

POSITION DESCRIPTION

FOP CONSULTANTS is looking for BI Analysts motivated to deliver on mandates. The main assignments would be to analyze information needs and develop business intelligence solutions, design data models and dashboards, ensure data quality and reliability, automate data pipelines and support users in making the most of their data.

KEY RESPONSIBILITIES

• Analyze information needs and define indicators and calculation rules.
• Design and develop data models, reports and dashboards.
• Develop and maintain data ingestion and transformation pipelines (ETL/ELT).
• Ensure the quality, consistency and reliability of data and deliverables.
• Optimize the performance of models, queries and reports.
• Document models, data dictionaries and operating procedures.
• Support business users and foster analytical self-sufficiency.

CANDIDATE PROFILE

• University degree in computer science, management or any related discipline.
• Minimum ten (10) years of experience in information technology.
• Eight (08) to fifteen (15) years of experience as a BI Analyst.
• Experience with one of the following frameworks: Scrum, Kanban, Lean, DSDM, SAFe, Nexus.
• Hold one of the following certifications: DP-700, Certified Analytics Professional (CAP).
• Hold one of the following certifications (an asset): Certified Business Intelligence Professional (CBIP), AI-102.
• Experience with one of the following tools: Power BI, Microsoft Fabric, SQL, Azure DevOps.
• Experience in Canadian public or private organizations.
• Language: French and English

WORK MODE

• Remote, Hybrid, On-site

WHAT WE OFFER

At FOP CONSULTANTS, we invest in the success and well-being of our experts. By joining our team, you benefit from an environment designed to support your performance and respect your work-life balance, including:

• Competitive compensation that reflects your expertise;
• Complete protection through our group insurance plans;
• Professional liability insurance so you can practise with confidence;
• Remote-work flexibility, based on client needs;
• 3 weeks of vacation to recharge;
• 3 paid sick days, to take care of yourself;
• A monthly allowance for your transportation costs;
• Real opportunities for advancement within the organization;
• Ongoing access to training to grow your skills.