Data & Reporting Analyst

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

Benefits offered by this job

Training and development

Flexible work options

Total rewards package

Volunteer days

Job summary

CGL is seeking a data analytics professional to administer our project portfolio management platform and design SQL-based data models, dashboards, and reporting solutions. You will collaborate with business and technology partners to capture requirements and deliver insightful analytics across our strategic initiatives.

Ideal candidates have 2-5 years in project reporting or portfolio management, strong Excel/PowerPoint skills, and proficiency in Power BI, SQL and related tools; hybrid work

Qualifications

• 2-5 years in project reporting, planning or portfolio management.
• Engineering mindset with a passion for puzzling information to provide fact-based analysis.
• Expert in Microsoft tools (Excel, PowerPoint) and analytics tools/languages (MicroStrategy, PowerBI, SQL, SAS, Python, R).
• Ability to do simple coding/programming for reporting.
• Experience with project management/planning tools (Planview, Clarity, Monday.com, Oracle, SAP) is an asset.
• Strong communication, time management, problem solving and attention to detail.

Responsibilities

• Administer and maintain the project portfolio management platform (PPM Pro).
• Design and develop SQL-based data models, reporting solutions, and interactive Power BI dashboards.
• Gather and document requirements for Data, Dashboard, and reporting needs for projects and initiatives.
• Autonomously manage reporting assets through enterprise tools (Excel and PowerBI) for analysis and reporting.
• Produce data and analytics to support ad-hoc requests on strategic and operational projects.
• Perform descriptive and diagnostic analysis to improve information flows and project views.

Skills

Excel

PowerPoint

PowerBI

SQL

Analytical mindset

Reporting programming

Education

Post-secondary in actuarial/math/statistics or CS

Tools

Planview

Clarity

Monday.com

Oracle

SAP

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.