Business Intelligence Developer III

First Canadian Insurance Corporation

$85K — $100K *
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Post-secondary education in IT, Computer Science, Data Analytics, or related field
  • 5-7+ years of experience in Business Intelligence or Data Analytics
  • Advanced proficiency in T-SQL and relational databases
  • Experience with Power BI and Microsoft Fabric
  • Familiarity with Python, PySpark or R is a plus
  • Fluent in English; French proficiency is an asset
  • Intermediate Microsoft Office skills (Word/Excel)

Responsibilities

  • Collaborate with stakeholders to create analytics solutions using Power BI
  • Transform business requirements into effective BI solutions
  • Design, build, and deploy BI reporting frameworks
  • Maintain and support data analytics and reporting systems
  • Monitor BI platform performance and manage user permissions
  • Manage development ticket queues for efficient delivery
  • Conduct unit testing and quality assurance on analytics deliverables

Benefits

  • Opportunities for mentoring and team collaboration
  • Potential for continuous learning and professional development
  • Involvement in change initiatives for data modernization
  • Strong stakeholder relationships and management of competing priorities
Full Job Description
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 a credit 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.

Similar Jobs

More Jobs at First Canadian Insurance Corporation

More Enterprise Technology Jobs

Find similar Business Intelligence Developer III jobs: