Data & Reporting Analyst - 18 months

Co-operators; Guelph; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading Canadian financial services co-operative seeks a Data & Reporting Analyst to enhance project management through effective data solutions. The role requires a focus on reporting for strategic and financial initiatives, along with strong skills in Microsoft Tools like Excel and PowerBI. Candidates should have 2-5 years of relevant experience and a passion for data analysis. This position supports a hybrid work model, balancing personal and professional needs.

Benefits

Training and development opportunities

Flexible work options

Health programs

Volunteer opportunities

Qualifications

• 2-5 years of experience in project reporting, planning, or portfolio management.
• Expertise in Microsoft Tools with knowledge of analytics tools and languages.
• Ability to gather and document requirements for data and reporting needs.

Responsibilities

• Manage and design reporting assets through enterprise tools.
• Produce data and analytics for ad-hoc requests.
• Perform descriptive and diagnostic analysis to improve information flows.

Skills

Microsoft Excel

PowerBI

Communication skills

Problem solving

Time management

Education

Post-secondary education in Actuarial, Mathematics, Statistics, or Computer Science

Tools

Microsoft Powerpoint

MicroStrategy

SQL

SAS

Python

R

Job description

Company: CGL

Department: Enterprise Transformation Office

Employment Type: Temporary Full-Time

Work Model: Hybrid

Language: This role operates in English.

Additional Information: This/these role(s) is/are currently vacant

The Opportunity

We are a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society and our team is essential to deliver on this strategy. That’s why we prioritize our people, to ensure we provide a strong culture and development opportunities which enables our team to thrive and to live our purpose. The best part is that you will work with people that care passionately about you, our clients, and our communities.

As a Data & Reporting Analyst, you will contribute to the success of project and portfolio reporting across the organization by developing and managing data and reporting assets. This includes providing business value through the creation, maintenance, implementation of data and reporting solutions that effectively addresses business reporting needs with dynamic views on projects and initiatives for strategic, financial and portfolio management and planning. We invite you to join us and help shape the future of project management within our organization!

How You Will Create Impact

• Able to work closely with business and technology partners to gather and document requirements for Data, Dashboard, and reporting needs around the organization's projects and initiatives.
• Autonomously manage and design reporting assets through enterprise tools (ie. Project Management tools, Excel and PowerBI) to enable easy and effective analysis and reports.
• Produce data and analytics to support ad-hoc requests on strategic and operational projects and initiatives with expert knowledge to extract, clean, reconcile and prepare the data required for the analysis.
• Able to autonomously perform descriptive and diagnostic analysis using recommended methods to improve information flows and views of project information with a solid understanding of project life cycles and impacts.

How You Will Succeed

• You remain focused and optimistic in the pursuit of a goal, despite barriers, until the objective is achieved and effectively manage your time in the quest of client satisfaction.
• You leverage information about client’s needs and situations to qualify sales opportunities and exhibit strong communication skills that allow you to clearly convey messages.
• You are committed to continuous improvement and building productive client relationships in order to exceed client expectations.
• You’re an effective team player and provide guidance to support the development of your peers.

To Join Our Team

• You have 2-5 years of experience in a project reporting, planning or portfolio management.
• You have an engineering mindset with a passion for puzzling information together to provide fact-based analysis.
• You are an expert in Microsoft Tools (i.e. Excel and Powerpoint) and general knowledge of analytics tools and languages is an asset (e.g. MicroStrategy, PowerBI, SQL, SAS, Python, R, etc).
• Experience working with of project management and planning tools e.g. Planview, Clarity, Monday.com, Oracle, SAP etc.)is an asset.
• General knowledge of business operations tools (SalesForce, PolicyCentre, ClaimCentre, BillingCentre) is an asset.
• You have a post-secondary education in Actuarial, Mathematics, Statistics, computer sciences or any other relevant field.
• Strong communication, time management, problem solving and attention to detail skills.
• Proficiency in English is essential to the main duties in this role, including servicing and communicating primarily with majority non-francophone clients, groups, teams. Drafting complex English documents and preparing daily reports for anglophone leaders. The essential non-French duties are not assignable to adjacent or other team members.

What You Need To Know

• You will be required to adhere to our hybrid work model.
• Detail oriented work that requires a high degree of mental concentration for extended periods of time.

What’s in it for you?

• Training and development opportunities to grow your career.
• Flexible work options to support personal and family needs.
• A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture.
• Volunteer opportunities to give back to your community.