Business Intelligence Developer III

First Canadian Insurance Corporation; Sherwood Park; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

On-site gym

Health benefits

Educational assistance

Hybrid work after 6 months

Wellness spending account

Employee Assistance Program

Employee discounts

Culture & diversity programs

Early Fridays off

Job summary

First Canadian Insurance Corporation is hiring a senior Business Intelligence Developer III to design, develop, and optimize data intelligence solutions across the organization. The role leverages Microsoft and IBM data platforms, collaborating with stakeholders to deliver high-quality analytics and drive continuous improvement.

You will lead BI solution development, platform operations, intake management, and data analysis initiatives, mentoring teammates and shaping data strategy with a strong

Qualifications

• Post-secondary education in Information Technology, Computer Science, Data Analytics, or a related field
• 5-7+ years of experience in BI, Data Analytics, or related roles
• Advanced proficiency in T-SQL and relational databases
• Advanced proficiency in data warehousing concepts, data modeling and ETL processes
• Experience with Power BI (Services, Desktop, Power Query, DAX, Admin)
• Experience with Microsoft Fabric or equivalent
• Familiarity with Python, PySpark or R is an asset
• Experience with Cognos v11.x is an asset
• Experience with IBM iSeries and DB2 is an asset
• Fluent in English; French is an asset

Responsibilities

• Develop analytics solutions using Power BI for new and existing applications
• Transform business requirements into BI solutions and data visualization
• Design, build, and deploy robust BI reporting frameworks
• Maintain and support data analytics and corporate reporting systems
• Monitor BI performance, manage user permissions, and ensure scalability
• Evaluate, upgrade, and improve BI systems as needed
• Manage development ticket queues with focus on quality
• Conduct unit testing, troubleshooting, and QA on analytics deliverables
• Provide advanced data analysis via SQL, PySpark, ETL and data pipelines
• Create data models and translate findings into recommendations
• Write technical documentation; mentor team members
• Lead analytics initiatives and set standards
• Foster collaboration, accountability, and continuous learning
• Identify opportunities to improve efficiency and maturity
• Build stakeholder relationships and manage priorities
• Champion data modernization and platform upgrades

Skills

BI experience

T-SQL

Data warehousing

Power BI

Python/PySpark/R

English fluent

French asset

Education

Post-secondary in IT/CS/Data Analytics

Tools

Power BI

Microsoft Fabric

Cognos

IBM DB2

Job description

Description

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.

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.
• 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 isrequired.
• Fluent in French with proven competencies in verbal and written communication is an asset
• Intermediate skill with Microsoft Office (Word/Excel)isrequiredSuccessful completion of acredit check, criminal background check, education verification, andemployment reference checksisrequiredbefore 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.