Lead Reporting Analyst

**Description:
- Permanent Full Time-
**Accountabilities**:

- Deliver ad-hoc reports and analyze data using a variety of tools which include Power BI, Microsoft Azure Databricks, and some Access, and Excel.
- 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 technology partners to develop new or enhanced data structures and reporting tools. This includes gathering requirements from business partners, designing data models, and ensuring results are accurate.

**Qualifications and Competencies**:

- Related post-secondary degree or equivalent with a minimum of three years of work experience.
- Strong technical skills, advanced knowledge of SQL, experience in Microsoft Power BI, Azure, Excel and Access.
- Working knowledge of Visual Basic (VB, VBA), C#, PHP and GIT.
- Well-developed organizational skills with an ability to handle and prioritize multiple tasks, and deadlines.
- Demonstrated written and verbal communication skills.
- Proven analytical and problem-solving skills; experience working with systems development methodology from a business perspective an asset.
- 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.
- The base salary for this position is between **$67,200****:

- $84,000** annually. This represents base salary only and does not represent other variable compensation components of our total compensation ( i.e. annual bonus, commission etc). If you are selected to move forward in our recruitment process, your recruiter will be able to discuss additional details of our total rewards program with you.-
- Be your best at Canada Life- 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.-
- Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted.- #LI-Hybrid