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. As a "super user" with Microsoft's back office, you will use your expertise to collect, extract, manipulate and present data via traditional reports or interactive tools in Excel or Access.
Develop and maintain sophisticated end-user spreadsheets and database applications to support head office and field operations (involves VBA programming)
Create customized ad hoc reports using Access and Excel to compile and analyze data
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 and experience in Excel and Access: considered a "power user" or "super user" when using Microsoft's back office.
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), SQL, and Cognos tools 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
Canada Life is a leading insurance, wealth management and benefits provider focused on improving the financial, physical and mental well-being of Canadians. For more than 170 years, individuals, families and business owners across Canada have trusted us to provide sound guidance and deliver on the promises we’ve made.
As of January 1, 2020, Great-West Life, London Life and Canada Life became one company – Canada Life, and today, we proudly serve more than 13 million customer relationships from coast to coast to coast.
Discover your opportunity….Apply today!
Canada Life offers competitive compensation, great benefits such as medical, dental, life insurance, wellness account and personal days not to mention onsite cafeteria and fitness in our head office facilities. If you’d like to join our team submit your information online and introduce yourself.
Canada Life serves the financial security needs of more than 13 million people across Canada, with additional operations in Europe and the United States. As members of the Power Financial Corporation group of companies, we’re one of Canada’s leading insurers with interests in life insurance, health insurance, investment and retirement savings. We offer a broad portfolio of financial and benefit plan solutions for individuals, families, businesses and organizations.
We are committed to providing an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employee has the opportunity to reach their potential.
Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted