Business Intelligence Developer III

First Canadian Financial Group; Sherwood Park; Hybrid; CAD 90,000 - 125,000; Full time

Benefits offered by this job

Early Fridays off

Vacation time-off

Retirement plan with employer match

Hybrid after six months

On-site gym

Ergonomic workspace

Education assistance

Benefits

Wellness account

EAP

Discount programs

Diversity initiatives

Recognition events

French language asset

Job summary

First Canadian Financial Group is seeking a seasoned Business Intelligence Developer III to design, develop, and optimize data intelligence solutions that drive strategic decisions across the organization. You will work with Microsoft and IBM data platforms, collaborating with stakeholders to deliver high-quality analytics and continuous improvement.

The role emphasizes BI development, data modeling, ETL, and mentoring teammates, with a hybrid model considered after six months.

Qualifications

• Post-secondary education in Information Technology, Computer Science, Data Analytics, or a related field.
• 5-7+ years of experience in Business Intelligence, Data Analytics, or related roles.
• Advanced proficiency in T-SQL and relational databases is required.
• Advanced proficiency in data warehousing concepts, data modeling and ETL processes is required.
• Experience with Power BI (Power BI Services, Desktop, Power Query, DAX, Administration) is required.
• Experience with Microsoft Fabric (Lakehouse, OneLake, Notebooks) or equivalent is required.
• Familiarity with scripting languages like Python, PySpark or R is an asset.
• Experience with Cognos v11.x (Framework Manager, Report Studio, Administration, Motio PI/CI) is an asset.
• Experience with IBM iSeries and DB2 Experience is an asset.
• Fluent in English with proven competencies in verbal and written communication is required.
• Fluent in French with proven competencies in verbal and written communication is an asset.
• Intermediate skill with Microsoft Office (Word/Excel) is required.
• Successful completion of a credit check, criminal background check, education verification, and employment reference checks is required before employment.

Responsibilities

• Collaborate with business stakeholders to develop analytics solutions using Power BI for new and existing applications, Power BI for innovated solutions, and adapting to emerging BI tools.
• Transform business requirements into effective BI solutions.
• Design, build, and deploy robust BI reporting frameworks and data visualization tools.
• Maintain and support data analytics and corporate reporting systems to for optimal performance and reliability.
• Monitor BI platform performance, manage user permissions, and ensure the scalability of the infrastructure.
• Evaluate, improve, and upgrade existing BI systems as needed.
• Manage development ticket queues with a focus on quality, problem-solving, and efficient delivery.
• Conduct unit testing, troubleshooting, and quality assurance on analytics deliverables.
• Ensure analytics solutions meet organizational standards and deliver high user satisfaction.
• Oversee customer communication, gather and provide feedback, share insights with team.
• Provide advanced data analysis through database querying with T-SQL or PySpark, ETL, and data pipelines.
• Provide data modeling for analytics to ensure efficient data processing and accessibility.
• Generate strategic insights from data and translate findings into actionable recommendations.
• Develop and update comprehensive technical documentation.
• Act as a trusted advisor and technical leader, influencing data strategy and analytics best practices across the organization.
• Mentor and support team members through knowledge sharing, coaching, and technical guidance.
• Lead complex analytics initiatives and provide direction on solution design, architecture, and development standards.
• Promote accountability, collaboration, and continuous learning within the team.
• Identify opportunities to improve team effectiveness, operational efficiency, and analytics maturity.
• Foster strong stakeholder relationships and effectively manage competing priorities to deliver business value.
• Champion change initiatives related to data modernization, reporting platforms, and analytics capabilities.
• Demonstrate workplace professionalism and contribute to team-oriented efforts.
• Adhere to all corporate business policies and procedures.
• Other duties as assigned.

Skills

T-SQL

Data warehousing

Data modeling

ETL

Python

R / PySpark

Education

Post-secondary education in IT/CS/Data Analytics

Tools

Power BI

Microsoft Fabric

Cognos v11.x

IBM iSeries / DB2

Job description

Description

First Canadian is a national organization and we are experiencing unprecedented growth!

Job Details

First Canadian is a national organization and we are experiencing unprecedented growth! We aim to hire bright, hard-working people who share our values. We seek employees who are committed to learning, career growth, and opportunity. We take pride in being an organization that our employees support long-term. We believe in our employees and celebrate their success by asking for employee opinions and feedback so that we continue to be a Great Place to Work.

We Award Our Team With The Following

• Off work 1 hour early on Fridays.
• Earned Time-Off Program and vacation.
• Group Retirement Savings Plan with employer match.
• A hybrid work model may be considered after six months of employment.
• On-site gym including free weekly classes with a qualified trainer.
• Newly renovated facility with ergonomic desks/chairs.
• Educational assistance and career development.
• Employee benefits.
• Health and Wellness spending account.
• Employee Assistance Program (EAP).
• Employee discount programs.
• A Culture Team dedicated to diversity, inclusion, and employee programs.
• Employee recognition and appreciation events.
• French is not required for this role but is an asset, an uplift of 5% is applied after the probationary period for qualified professional level French bilingualism (both spoken and written).

Check out our company page for all the information on why we believe First Canadian is an employer of choice! If you are motivated to succeed by helping people, then this is the opportunity for you!

The Business Intelligence Developer III is a senior technical expert responsible for designing, developing, and optimizing data intelligence solutions that support strategic decision-making across the organization. This role leverages Microsoft and IBM data platforms, collaborates with internal and external stakeholders, and delivers high-quality analytics solutions while driving continuous improvement and supporting business intelligence initiatives.

Essential Responsibilities

BI Solution Development & Delivery

• Collaborate with business stakeholders to develop analytics solutions using Power BI for new and existing applications, Power BI for innovated solutions, and adapting to emerging BI tools.
• Transform business requirements into effective BI solutions.
• Design, build, and deploy robust BI reporting frameworks and data visualization tools.

Platform & Operations

• Maintain and support data analytics and corporate reporting systems to for optimal performance and reliability.
• Monitor BI platform performance, manage user permissions, and ensure the scalability of the infrastructure.
• Evaluate, improve, and upgrade existing BI systems as needed.

Intake Process and Ticket Management

• Manage development ticket queues with a focus on quality, problem-solving, and efficient delivery.
• Conduct unit testing, troubleshooting, and quality assurance on analytics deliverables.
• Ensure analytics solutions meet organizational standards and deliver high user satisfaction.
• Oversee customer communication, gather and provide feedback, share insights with team.

Database and Data Analysis

• Provide advanced data analysis through database querying with T-SQL or PySpark, ETL, and data pipelines.
• Provide data modeling for analytics to ensure efficient data processing and accessibility.
• Generate strategic insights from data and translate findings into actionable recommendations.
• Develop and update comprehensive technical documentation.

Leadership & Continuous Improvement

• Act as a trusted advisor and technical leader, influencing data strategy and analytics best practices across the organization.
• Mentor and support team members through knowledge sharing, coaching, and technical guidance.
• Lead complex analytics initiatives and provide direction on solution design, architecture, and development standards.
• Promote accountability, collaboration, and continuous learning within the team.
• Identify opportunities to improve team effectiveness, operational efficiency, and analytics maturity.
• Foster strong stakeholder relationships and effectively manage competing priorities to deliver business value.
• Champion change initiatives related to data modernization, reporting platforms, and analytics capabilities.

Professional Contributions

• Demonstrate workplace professionalism and contribute to team-oriented efforts.
• Adhere to all corporate business policies and procedures.
• Other duties as assigned.

Qualifications

• Post-secondary education in Information Technology, Computer Science, Data Analytics, or a related field
• 5-7+ years of experience in Business Intelligence, Data Analytics, or related roles
• Advanced proficiency in T-SQL and relational databases is required
• Advanced proficiency in data warehousing concepts, data modeling and ETL processes is required
• Experience with Power BI (Power BI Services, Desktop, Power Query, DAX, Administration) is required
• Experience with Microsoft Fabric (Lakehouse, OneLake, Notebooks) or equivalent is required
• Familiarity with scripting languages like Python, PySpark or R is an asset
• Experience with Cognos v11.x (Framework Manager, Report Studio, Administration, Motio PI/CI) is an asset
• Experience with IBM iSeries and DB2 Experience is an asset
• Fluent in English with proven competencies in verbal and written communication is required.
• Fluent in French with proven competencies in verbal and written communication is an asset
• Intermediate skill with Microsoft Office (Word/Excel) is required
• Successful completion of acredit check, criminal background check, education verification, and employment reference checks is required before employment

Thank you for considering our organization. If you are bilingual there will be a French and English assessment as a part of the recruitment process.

We are an equal opportunities employer and welcome applications from all suitably qualified persons. Accommodations are available upon request.