Lead Reporting Analyst

The Lead Reporting Analyst, Disability Solutions and Shared Services, will apply their strong technical skills and problem solving ability to provide reports, data and tools for business partners in Group Plan Member Services. You will use your expertise to collect, extract, manipulate and present data in both traditional and modern reporting methods with a focus on process improvement and data architecture. Accountabilities Develop and maintain complex end-user spreadsheets, Power BI reports and database application to support head office and filed operations.

Deliver ad-hoc reports and analyze data using a variety of tools which include MS Access, Excel and Power BI. Work with different types of enterprise data sources such as SQL Server, IBM DB2 and Databricks using Structured query language (SQL). Develop complex reporting processes to provide insight on business issues to senior leadership.

Support the production of timely and accurate operational reporting for the claim payment operation (e.g. volumes, service results, etc). Work with Group Technology partners to develop new or enhanced data structures and reporting tools. Includes obtaining requirements from business partners, contributing to the design of the data model, and testing to ensure accuracy of data and calculations.

Qualifications and Competencies Education acquired through completion of a post‑secondary degree or equivalent with a minimum of two years of work experience. Strong technical skills, specifically advanced knowledge of SQL, experience in Excel, MS Access and Power BI. Proven analytical and problem‑solving skills; experience working with systems development methodology from a business perspective an asset.

Working knowledge of Visual Basic (VB, VBA), C#, PHP and GIT would be an asset. Well‑developed organizational skills with an ability to handle and prioritize multiple tasks, and work to deadlines. Demonstrated written and verbal communication skills.

Knowledge of Canada Life systems such as BEN, PAS, EAS and DCT, as well as an understanding of group disability benefits would be an asset. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Canada Life policies.

Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted. #J-18808-Ljbffr