Senior BI Developer: Data Insights & Strategy

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

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.