Lead Reporting Analyst

Job Description 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. Be your best at Canada Life- Apply today Being a part of Canada Life means you have a voice. This is a place where your unique background, perspectives and talents are valued, and shape our future success. You can be your best here. You’re part of a diverse and inclusive workplace where your career and well-being are championed. You’ll have the opportunity to excel in your way, finding new and better ways to deliver exceptional customer and advisor experiences. Together, as part of a great team, you’ll deliver on our shared purpose to improve the well-being of Canadians. It’s our driving force. Become part of a strong and successful company that’s trusted by millions of Canadians to do the right thing.  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. It is our priority to remove barriers to provide equal access to employment. 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. To request a reasonable accommodation in the application process, contact . Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted . #LI-Hybrid