Data Analyst

STATUS: Permanent

LOCATION: Peterborough, ON

APPLY BY: March 17, 2025

SALARY RANGE: $40 - $45/hour

WHY WORK WITH CAMBIUM?

You want to be a part of a successful, dynamic and fast-growing consulting and engineering company built on quality people doing quality work in a rewarding environment. We help build Ontario. We have offices in Ottawa, Whitby, Barrie, Kingston, and Peterborough.

Our team is fun and friendly. Whether it's trips to sporting events, movie nights, monthly socials, or weekend retreats, our team likes to have a good time together.

Our team is hard-working. You’ll need to be flexible and able to manage priorities. Sometimes the days are long. But you are always compensated for your efforts. And we support balance with generous paid time off entitlements.

Our team is proud. Donating a portion of our net income each year to important causes and events. Winning awards. You’ll find it easy to feel good about working with Cambium.

CAMBIUM REWARDS

Our focus on caring for the employee as a whole person is apparent in the way we reward our people:

• A competitive salary and a 100% employer paid benefits program, that includes critical illness, long term disability, life insurance, and health and dental coverage
• Generous vacation entitlements, paid personal days plus sick time allotments to take care of you and your family
• The opportunity to participate in an employer sponsored Registered Pension Plan (RPP), company profit sharing opportunities, company ownership opportunities
• Financial support for your professional development and flexible scheduling to help you integrate work and family life

DO YOU HAVE THE RIGHT STUFF FOR CAMBIUM?

You are passionate about transforming data into actionable insights, and thrive in a fast-paced, innovative environment. You have a keen eye for detail, strong analytical skills, and a desire to make a significant impact. You have a strong set of personal values that align with Cambium’s values. You have a positive outlook and attitude. You fit well in a cohesive, cooperative team, where you want to make lasting relationships. You have an internal drive to meet high standards and provide quality effort for great outcomes. You engage with others to create mutual understanding and trust.

WHAT WILL YOU DO?

As a Data Analyst you will be at the forefront of extracting, analyzing and visualizing data varied external and internal database sources (including our ERP) to provide stakeholders with actionable insights from market, operational, and financial data. You will be responsible for designing BI outputs that drive business decisions and operational efficiency. You will support mangers across the company in their business intelligence and reporting needs. As a primary contributor to the deployment of a data warehouse solution, you will be implementing cutting-edge solutions (including artificial intelligence) to streamline the consolidation, transformation, and extraction of data. Your expertise will ensure that future reporting needs are met with precision and efficiency.

Job Duties

Stakeholder Collaboration:

• Collaborate closely with stakeholders to understand their information and knowledge requirements following a well defined work intake process to develop effective BI solutions that drive informed decision-making.
• Regularly prioritize the initiatives with the stakeholders and align expectations.

Data Modeling and Transformation:

• Source/extract/download data from relevant systems/sources, clean, massage and reprocess data as needed.
• Perform in-depth analysis to identify trends, patterns, and key performance indicators related to master data sets for market/business awareness and insights.
• Design and implement robust data models.

Data Integration:

• Understand the data opportunities and constraints from various systems – public and internal data sources including custom applications, to provide a comprehensive knowledge base for management and leadership.

AI Knowledge Base and Agent Creation:

• In response to business needs, establish knowledge bases using select data and information sources for use by purpose-built, proprietary artificial intelligence agents
• Design AI agents and support and guide employees to train agents in identified workflows and queries.

Dashboard and Report Development:

• Develop and maintain visually appealing and intuitive dashboards, reports, and visualizations using available platforms including Power BI.
• Support stakeholders with real-time insights into data related to project management, statuses, resource utilization/allocation, budget variance, time tracking and other critical metrics.

Performance Optimization:

• Optimize reports and queries to ensure fast and efficient performance, specifically when dealing with large volumes of data from multiple sources.

Data Quality:

• Implement rigorous data quality checks and validation processes to ensure the accuracy, consistency, and integrity of data used in dashboards/solutions.

Documentation and Training:

• Create comprehensive documentation for BI solutions, including data models, report specifications, and user guides.
• Provide training and support to end users to ensure they can effectively utilize BI reports and dashboards.

QUALIFICATIONS

• Bachelor's degree in Computer Science, Information Systems OR relevant work experience
• 3 years of experience working as a Power BI developer and data analyst preferably in consulting
• Excellent analytical skills with a keen attention to detail
• Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams
• Experience with data modeling techniques and best practices, particularly in the context of project management, time tracking, resource management, dashboard reporting, data extracts and other financial data
• Proficiency in SQL & Python for data manipulation and querying, with a solid understanding of relational data structures and schema
• Strong knowledge of software lifecycle, project management, time tracking, financial management and processes
• Proven track record of developing insightful dashboards and reports using Power BI in an enterprise environment
• Knowledge of Deltek and Netsuite data structures considered an asset
• Familiarity with cloud-based data platforms
• Relevant certifications in Power BI, data engineering, or data analytics
• Excellent customer service orientation
• Flexible and adaptable to changing needs
• A high level of integrity and pride in quality work
• Desire to succeed and continuously learn
• Valid Driver’s License and access to a reliable vehicle

BEHAVIOURAL COMPETENCIES - INDIVIDUAL CONTRIBUTOR LEVEL

AGILITY – Embraces innovation and change to foster improvements that move Cambium forward. Contributes ideas to positive change

• Seeks to understand, accept and navigate change
• Adjusts priorities to meet changing needs
• Maintains a calm and balanced approach when dealing with the unexpected
• Able to think critically and reorganize work to respond to change
• If struggling with change, seeks more information and support; avoids blame and negativity

RESOURCEFULNESS – Uses a “Can Do” approach to getting things done in a way that is efficient and resource-effective.

• Demonstrates a high work ethic
• Self-motivated
• Gives best efforts to achieve maximum quality output from minimum effort
• Contributes to clearly understood workflow evolution
• Understands when/where to get information that links to work performed
• Accomplishes goals as set in collaboration with others

TEAM FOCUS – Builds trust through interpersonal effectiveness and personal accountability.

• Helps others and does their part in the workload that is spread equitably across the team
• Steps up when a push to completion is required, but speaks to balance of work and life when needed to avoid burnout and overwork
• Keeps commitments and participates
• If workload demands become unreasonable, communicates the challenge and works to a positive resolution, and ensures needed adjustments to commitments are communicated
• Prioritizes positive workplace relationships through caring

COURAGE – Shows personal integrity and honesty, while also using diplomacy in difficult situations.

• Addresses rather than ignores challenges
• Uses diplomacy in difficult conversations
• Uses good judgement to evaluate situations
• Focuses on the problem without personal judgements
• Keeps confidential information completely confidential

SELF KNOWLEDGE AND CONTROL – Uses emotional intelligence to give and receive improvement feedback well, in good and difficult times.

• Reflects on own performance and accurately assesses strengths and areas for improvement
• Accepts performance feedback and takes action to improve

SERVICE – Acts professionally* with the internal or external client at the center and discovers emerging client needs.

• Makes client service a top priority
• Listens to understand and read between the lines
• Communicates respectfully, tactfully, and with effectiveness
• Shows sensitivity to the needs of others to build mutual trust and respect

*Professionalism at Cambium means being reliable and responsible. It means doing what you say you are going to do. It means communicating clearly and as frequently as needed as things change. It also means being respectful of differences, seeking to understand the perspectives of others, and being authentic, kind, honest, and sometimes vulnerable. It doesn’t mean being stoic or impersonal or overly formal.