Junior Data Analyst | Hybrid (once a week onsite) - Eastwood, QC

About the role:

The Junior Data Analyst is responsible for collecting, cleaning, and analyzing data to support business decision-making. This role involves preparing reports, identifying trends and insights, maintaining data accuracy, and collaborating with stakeholders to provide meaningful recommendations that improve operational and business performance.

Key responsibilities:

Data Collection & Source Identification

• Assist in gathering, reviewing, and clarifying reporting and analysis requirements with stakeholders under the guidance of senior team members.

• Identify relevant data sources, required fields, access requirements, refresh schedules, and data owners using established documentation.

• Validate data availability and proactively escalate gaps, risks, or unclear data definitions before analysis begins.

Data Cleaning & Preparation

• Extract, clean, and structure data using SQL, Excel, Power BI, and related tools.

• Prepare analysis-ready datasets by resolving duplicates, missing values, and formatting issues.

• Apply basic calculations and business rules to support reporting and analysis.

Data Validation & Quality Control

• Validate data accuracy, completeness, and consistency against source systems and business rules.

• Perform KPI checks, data testing, and document data quality issues.

• Review reports, datasets, and dashboards for accuracy before submission or publication.

Analysis & Insight Generation

• Conduct basic analysis to identify trends, patterns, exceptions, and potential opportunities.

• Apply variance analysis, segmentation, trend analysis, and KPI comparisons using established methods.

• Summarize findings in clear business language and support insights, recommendations, and decision-support commentary for review.

Reporting & Dashboard Development

• Build and maintain recurring reports, dashboards, and trackers using approved templates.

• Create clear visuals, KPIs, and summaries using Excel, Power BI, Tableau, or similar tools.

• Test report accuracy, calculations, and functionality before release.

Role-Specific Dashboard Updates

• Maintain and update workforce, HR, and operational dashboards, ensuring data accuracy and timely reporting.

• Validate dashboard data, KPIs, and refreshes, and resolve or escalate issues before publication.

• Support dashboard enhancements, stakeholder feedback, and UAT activities.

• Maintain dashboard documentation, including KPI definitions, data sources, and refresh schedules.

• Identify opportunities to automate reporting processes and improve dashboard efficiency using approved tools.

Monthly Scorecard Management

• Support monthly scorecard updates by consolidating data, validating KPIs, and performing accuracy checks.

• Publish and distribute scorecards on schedule while highlighting key trends and variances.

• Ensure consistency of metrics, definitions, and reporting formats across reporting periods.

Stakeholder Collaboration

• Support stakeholder discussions to gather reporting requirements, KPIs, and business objectives.

• Communicate project updates, risks, and issues in a timely manner.

• Assist in presenting insights and incorporating stakeholder feedback into reports and dashboards.

Darwinbox Survey Facilitation

• Assist with Darwinbox survey setup, scheduling, and distribution.

• Monitor response rates and support timely survey completion.

• Extract, validate, and summarize survey results to provide actionable insights.

Process Improvement

• Identify opportunities to streamline reporting processes and improve data quality.

• Assist in developing reusable templates, queries, and workflow enhancements.

• Contribute to efficient, scalable, and reliable reporting practices.

Documentation & Handover

• Document data sources, KPI definitions, formulas, assumptions, and reporting requirements.

• Maintain report documentation, change logs, and handover materials.

• Support users with report interpretation and escalate complex issues when needed.

Ownership Expectations

• Manage routine and assigned work according to agreed priorities, timelines, review requirements, and escalation paths.

• Take ownership of assigned recurring reports and dashboards while seeking guidance for complex, sensitive, or high-impact matters.

• Protect confidential employee, client, and business data and comply with applicable governance, privacy, and security requirements.

Qualifications:

Education

• Bachelor's Degree in Analytics, Statistics, Mathematics, Computer Science, Information Technology, Business Analytics, Economics, or a related field.

• Equivalent experience in data analytics, business intelligence, or reporting may be considered.

Experience

• Minimum 1-3 years of experience in Data Analytics, Business Intelligence, Reporting, Workforce Analytics, HR Analytics, Operations Analytics, or related disciplines.

• Experience managing recurring reports, KPI scorecards, dashboards, and data-driven business insights.

• Experience supporting stakeholders through requirements gathering, report delivery, and business recommendations.

Technical Skills

• Strong proficiency in SQL, Microsoft Excel, Power BI, Power Query, Power Automate, Power Apps, and API integrations.

• Hands-on experience with business intelligence and data visualization platforms, including Power BI, Tableau, Looker, AWS Analytics, or equivalent reporting solutions.

Analytical Skills

• Ability to perform trend analysis, variance analysis, KPI performance monitoring, data reconciliation, data validation and quality assurance and statistical and operational analysis.

• Proven ability to translate complex data into clear business insights and actionable recommendations.

Preferred Qualifications:

• Experience with survey administration and reporting.

• Familiarity with Darwinbox or similar HRIS and survey platforms.

• Experience in automating reports and processes to improve efficiency and reduce manual work.

Why IntoGREAT?

• Competitive Compensation Package: An attractive salary and comprehensive benefits aligned with market standards.

• Day 1 HMO Coverage + 2 Free Dependents: Enjoy comprehensive healthcare coverage from your first day of employment, including HMO coverage for up to two dependents at no additional cost.

• Mental Health & Wellness Support: Your well-being matters. Access programs and benefits designed to support your mental health, wellness, and overall work-life balance.

• 20 PTO Benefits: Take the time you need to rest, recharge, and attend to personal commitments with our paid time-off program.

• Career Growth and Development: Opportunities for training and development to help employees advance their skills and grow within the company.

• Supportive Leadership: A collaborative environment with leaders who provide guidance, mentorship, and recognition to empower employees in their roles

Ready to Shape the Future?

• Step into a role where your skills will fuel growth, inspire change, and create a lasting impact. We’re eager to see how you can make a difference with us!