Data & Reporting Analyst

Co-operators; Burlington; Hybrid; CAD 61,000 - 101,000; Full time

Job summary

CGL is seeking a data and reporting professional to join the Strategic Execution team on a hybrid schedule (2 days in office) in Canada. You will administer the PPM Pro platform, design SQL data models and Power BI dashboards, and collaborate with business and tech partners to meet reporting needs.

With 2–5 years of project reporting experience, you will leverage Excel, PowerPoint and analytics tools to deliver fact-based insights and support decision-making across projects and initiatives.

Qualifications

• 2–5 years of experience in a project reporting, planning or portfolio management.
• Engineering mindset with a passion for solving information puzzles and providing fact-based analysis.
• Expertise with Microsoft Excel and PowerPoint and analytics tools such as SQL, SAS, Python or R.
• Ability to perform simple coding for reporting.

Responsibilities

• Administer and maintain the project portfolio management platform (PPM Pro) including configuration, user workflows, and reporting integration.
• Design and develop SQL-based data models and Power BI dashboards to support BI and decision-making.
• Gather and document requirements with business and technology partners for data, dashboards and reporting needs.
• Autonomously manage and design reporting assets across enterprise tools for analysis.
• Produce data and analytics to support ad-hoc requests on strategic initiatives.
• Perform descriptive and diagnostic analysis to improve information flows and project views.

Skills

Excel

PowerPoint

SQL

PowerBI

MicroStrategy

SAS

Python

R

MS Project/PM tools

Education

Actuarial/Math/Statistics/CS degree

Tools

Planview

Clarity

Monday.com

Oracle

SAP

PowerBI

Job description

Company: CGL
Department: Strategic Execution
Employment Type: Regular Full-Time
Work Model: Hybrid (2 days in office)
Language: This role operates in English.

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.

How You Will Create Impact

• Administer and maintain project portfolio management platform (PPM Pro), including system configuration, user workflow management, reporting integration, and ongoing system support.
• Design and develop SQL-based data models, reporting solutions, and interactive Power BI dashboards to support business intelligence and decision-making.
• 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.

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 knowledgeable on analytics tools and languages (e.g. MicroStrategy, PowerBI, SQL, SAS, Python, R, etc).
• You have the ability to do simple coding/programming for reporting.
• Experience working with of project management and planning tools e.g. Planview, Clarity, Monday.com, Oracle, SAP etc.)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.

How You Will Succeed

• You influence change and are committed to continuous improvement, in order to exceed client expectations.
• You leverage critical thinking skills to identify problems and proactively propose solutions.Your strong communication skills allow you to clearly convey messages.
• You’re an effective team player who shares knowledge to support our peers.

What You Need To Know

• You will be subject to a Background check as a condition of employment, in the event you are the successful candidate.

What’s in it for you?

• Training and development opportunities to grow your career.
• Flexible work options and paid time off to support your personal and family needs.
• A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture.
• Paid volunteer days to give back to your community.
• In addition to our competitive salary and incentive programs, eligible employees also benefit from a comprehensive total rewards package including group retirement savings plans, pension and benefits (e.g., health and wellness, dental, disability and life coverage), mental health support and an employee assistance program.

Salary information

Expected salary range $60,574 to $100,956

The salary amount for the successful candidate is determined by Co-operators in its discretion and will vary depending on several criteria including but not limited to: local market conditions, geography and relevant job-related factors such as knowledge, skills, qualification, experience and education.

Employees may also have the opportunity to participate in incentive programs and earn additional compensation tied to individual and/or business performance, or other business metrics.