Sr Data & Reporting Analyst

Job summary

The Senior Data and Reporting Analyst is responsible for designing, implementing, and maintaining sales reporting and data models to provide actionable insights for distribution channels. This role involves translating stakeholder needs into custom dashboards and reports while proactively identifying business opportunities through data analysis.

Job details

Permanent Full Time - The Senior Data and Reporting Analyst plays a critical role in the design, implementation and maintenance of sales reporting and analysis for our various distribution channels as well as to other internal business partners. The role will be responsible for bringing actionable analysis and insights to team members and key stakeholder groups. The role will be required to work independently and demonstrate strong problem-solving skills. An outward focus and ability to translate complex problems into simple concepts will be essential to this role’s success. What you will do Translating needs of various sales stakeholders into actionable analysis. Derive insights from various sources of data with varying levels of integrity Become intimately familiar with data-sets stored across several systems Build, implement and maintain data models, custom reports and dashboards Develop numerous reports for our distribution channel business partners on various metrics to help them better understand our business Ownership of setting sales targets for our distribution channel business partners Leverages understanding of the business environment and business partner needs to proactively identify opportunities through data analysis Present and communicate the insights and recommendations generated in a visual and simplified language Fulfilling numerous industry surveys What you will bring Undergraduate Degree in Math, Business, Economics or similar 2+ years in an Analyst role Strong background using Microsoft Access, Microsoft Excel and Power BI Knowledge of Power Automate (and/or other Microsoft Power Platform tools) would be an asset Demonstrated ability to read + write SQL is an asset Ability to communicate effectively with senior management Creative thinker with the ability to understand the root cause of an issue by using data to dive deeper into the situation Strong analytical skills for problem solving purposes Ability to work with little, to no documentation or instructions Pays close attention to detail Ability to think outside the box and identify solutions to overcome obstacles Well-developed planning and organizational skills with the ability to prioritize and handle multiple complicated tasks while meeting tight deadlines Focused on high standards and high quality work Ability to work in team setting as well as independently Knowledge of our organization, products, distribution channels is an asset - The base salary for this position is between $59,800 - $109,700 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. Career opportunities will be open a minimum of 5 business days from the date of posting, closing dates will vary depending on the search activity. All applications received will be reviewed on a rolling basis. Grow with Canada Life We’re united by a shared purpose: to improve the financial, physical and mental well-being of Canadians. Our company is trusted by 1 in 3 Canadians and contributes to the strength of communities across the country. We’re looking for people who live our values everyday: we step up, we do the right thing, and we deliver – for our customers, communities and each other. Are you someone who always strives to do the right thing, who steps up for themselves and others, and who delivers with impact? Then we want to hear from you! What we offer: We’re committed to supporting our employees through every stage of their career. Here’s what you can expect as a full-time or part-time permanent team member: Career Development: Opportunities for career advancement, access to industry-leading learning programs and up to $2,000 annually towards education reimbursement. Health & Wellness: Flexible health and dental benefits, plus a $5,000 mental health benefit to support your well-being. Time Off: In addition to regular vacation and personal days, we support community involvement with a volunteer day. Financial Security: Company-matching pension plan, share ownership program and additional investment options. Rewards and Recognition: Employee recognition programs, service milestone celebrations, employee discounts and more! Emphasis on Community: We provide a workplace where employees feel connected and supported through Employee Resource Groups (ERGs), mentorship programs, social clubs and events. Learn more about Canada Life. We’re committed to removing barriers and ensuring equal access to employment. Applicants requiring reasonable accommodation during the application process may contact talentacquisitioncanada@canadalife.com. All information provided will be handled in accordance 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. #LI-Hybrid

What you’ll do

The Senior Data and Reporting Analyst is responsible for designing, implementing, and maintaining sales reporting and data models to provide actionable insights for distribution channels. This role involves translating stakeholder needs into custom dashboards and reports while proactively identifying business opportunities through data analysis.

Requirements

Candidates must hold an undergraduate degree in Math, Business, Economics, or a related field with at least 2 years of experience in an analyst role. Proficiency in Microsoft Access, Excel, and Power BI is required, with additional skills in SQL and Power Platform tools considered an asset.

Benefits

• Career development
• Education reimbursement
• Flexible health and dental benefits
• Mental health benefit
• Volunteer day
• Company-matching pension plan
• Share ownership program
• Employee recognition programs
• Employee discounts

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Sales Reporting · Preferred
• Problem solving · Preferred
• Attention to detail · Preferred
• Data analysis · Preferred
• Microsoft Excel · Preferred
• Planning · Preferred
• Communication · Preferred
• Reporting · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data analysis
• Reporting
• Microsoft Access
• Microsoft Excel
• Power BI
• Power Automate
• SQL
• Data modeling
• Problem-solving
• Communication
• Analytical skills
• Planning
• Organizational skills
• Attention to detail
• Sales reporting
• Sales Reporting
• Overcoming Obstacles
• Advanced Mathematics
• Organizational Skills
• Microsoft Power Automate
• Microsoft Power Platform
• Business Ownership
• Analytical Skills
• Data Analysis
• Mental Health
• Dashboard
• Business Economics
• Management
• Data Modeling
• Sales
• Problem Solving
• Mentorship
• Sales Management
• SQL (Programming Language)
• Surveys
• Prioritization
• Detail Oriented

Job areas

• Data & Analytics
• Finance & Accounting
• Sales
• Technology
• Data Reporting Analyst
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists

More jobs from Canada Life