Data Analyst

Job type:

Vaughan

On-site

CAD 25,000 - 39,000

Full time

12 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

AdvantAge Ontario is seeking a Data Analyst Co-op student to support data collection, cleaning, analysis, and reporting for member and staff decision-making. The role focuses on building Power BI dashboards, preparing datasets, and contributing to surveys and data governance initiatives.

You will work with the IT & Data Strategy team to translate findings into actionable insights for diverse audiences, while handling confidential information per governance requirements.

Qualifications

  • Enrolled in a recognized post-secondary co-op program in Data Analytics, Data Science, Business Analytics, Computer Science, IT, Statistics, Mathematics, Health Informatics, or related discipline.
  • Completed coursework in databases, data analysis, statistics, or business intelligence.
  • Eligibility to participate in a co-op work term, including required documentation.

Responsibilities

  • Collect, clean, transform, validate, and document data from internal and external sources to support analysis and reporting.
  • Analyze data and translate findings into clear, actionable insights for technical and non-technical audiences.
  • Support year-over-year, trend, comparative, and benchmarking analyses to identify patterns, changes, and opportunities.
  • Build and maintain Power BI dashboards, reports, visualizations, KPIs, and data models in collaboration with the Data & Analytics Services team.
  • Use Excel, Power Query, Power BI, and other analytical tools to prepare and analyze datasets and improve repeatable reporting processes.
  • Support Salesforce reporting, data extracts, validation, and preparation of member and organizational data for analytics and dashboards.
  • Support the development, administration, analysis, and reporting of surveys using SurveyMonkey and Microsoft Forms.
  • Research and maintain relevant Ontario health, long-term care, seniors’ care, demographic, workforce, and other public datasets, contributing to a centralized data repository.
  • Apply data storytelling and visualization techniques to communicate findings clearly and effectively.
  • Assist with data quality assessments, data dictionaries, methodology documentation, and data governance practices.
  • Identify opportunities to automate data preparation, reporting, and synchronization processes using Power Query, Excel, Power BI, Python, or VBA.
  • Support exploratory statistical and predictive analyses to identify trends and inform organizational planning.
  • Handle member and organizational information in accordance with privacy, confidentiality, and data governance requirements.
  • Assist with data quality assessments and maintain data dictionaries, methodologies, data sources, assumptions, and process documentation to support governance and reproducibility.
  • Perform other related data and technology duties as assigned.

Skills

Data analysis
Excel
Data storytelling
Collaboration
Attention to detail
Adaptability
Time management
Critical thinking
Learning mindset

Education

Post-secondary co-op program

Tools

Power BI
Power Query
SQL
Python

Job description

For more than 100 years, AdvantAge Ontario has been the voice of not-for-profit seniors’ care in Ontario. We represent more than 540 providers of long-term care, seniors’ housing, supportive housing and community service agencies, including 96 per cent of all municipal long-term care homes and 89 per cent of all not-for-profit long-term care homes.

We are focused on the important work that members do and on giving them the supports and resources they need, including advocacy, education, communications, and member programs and services.

Organization Culture:

AdvantAge Ontario is a collaborative organization that supports its members, staff, and community with a shared purpose. We are nimble and responsive, and we are personable, professional, and empathetic.

Organization Values:
  • Inclusion and diversity – we strive to provide a workplace that recognizes diversity and is safe and inclusive.
  • Respect – we show respect by demonstrating trust and integrity in all interactions.
  • Empathy – we are empathetic and kind to our members, colleagues, and ourselves.
  • Fairness – we are fair and equitable in all we do.
  • Passion – we have a passion for innovation and continuous improvement.
Responsibilities:

Work with the Director of IT Innovation & Data Strategy and the Data & Analytics Services team to support data collection, preparation, analysis, reporting, visualization, and data management initiatives that help members and staff make informed, evidence-based decisions.

The Data Analyst Co-op student will:
  • Collect, clean, transform, validate, and document data from internal and external sources to support analysis and reporting.
  • Analyze data and translate findings into clear, actionable insights for technical and non-technical audiences.
  • Support year-over-year, trend, comparative, and benchmarking analyses to identify patterns, changes, and opportunities.
  • Build and maintain Power BI dashboards, reports, visualizations, KPIs, and supporting data models in collaboration with the Data & Analytics Services team.
  • Use Excel, Power Query, Power BI, and other analytical tools to prepare and analyze datasets and improve repeatable reporting processes.
  • Support Salesforce reporting, data extracts, validation, and preparation of member and organizational data for analytics and dashboards.
  • Support the development, administration, analysis, and reporting of surveys using SurveyMonkey and Microsoft Forms.
  • Research and maintain relevant Ontario health, long-term care, seniors’ care, demographic, workforce, and other public datasets, and contribute to a centralized data repository.
  • Apply data storytelling and visualization techniques to communicate findings clearly and effectively.
  • Assist with data quality assessments, data dictionaries, methodology documentation, and data governance practices.
  • Identify opportunities to automate data preparation, reporting, and synchronization processes using approved tools such as Power Query, Excel, Power BI, Python, or VBA.
  • Support exploratory statistical and predictive analyses, where appropriate, to identify trends and inform organizational planning.
  • Handle member and organizational information in accordance with organizational privacy, confidentiality, and data governance requirements.
  • Assist with data quality assessments and maintain data dictionaries, methodologies, data sources, assumptions, and process documentation to support data governance, knowledge transfer, and reproducibility.
  • Perform other related data and technology duties as assigned.
Core Competencies
  • Strong analytical, critical-thinking, and problem-solving skills.
  • Strong attention to detail and commitment to data accuracy.
  • Ability to translate analysis into clear, actionable business insights.
  • Strong written, verbal, and data storytelling skills.
  • Flexible and adaptable to changing priorities, assignments, and organizational needs.
  • Self-motivated and proactive, with the ability to work independently and take ownership of assigned work.
  • Strong organizational and time-management skills, with the ability to manage multiple assignments and competing priorities.
  • Strong collaboration and interpersonal skills, with the ability to work effectively across teams.
  • Curiosity and willingness to learn new analytical methods, technologies, and business processes.
  • Ability to maintain confidentiality and appropriately handle sensitive organizational and member data.
Technical Skills –Required or strongly preferred
  • Intermediate to advanced Microsoft Excel, including PivotTables, lookup functions, formulas, charts, and data manipulation.
  • Working knowledge of Power BI and Power Query, with experience creating reports, dashboards, visualizations, or data models through coursework, projects, or employment.
  • Understanding of relational databases, data structures, and basic data modelling concepts.
  • Experience analyzing and visualizing structured datasets.
  • Familiarity with survey or data collection tools.
Assets
  • Familiarity with SQL and querying relational databases.
  • Familiarity with Python, particularly pandas or other data-analysis libraries.
  • Exposure to Salesforce reporting or CRM data.
  • Understanding of statistical analysis or predictive modelling.
  • Experience with Microsoft Forms or SurveyMonkey.
  • Familiarity with AI-assisted data analysis, research, or productivity tools, and an understanding of responsible AI use, privacy, and human review.
Qualifications:
  • Currently enrolled in a recognized post‑secondary co‑op program in Data Analytics, Data Science, Business Analytics, Computer Science, Information Technology, Statistics, Mathematics, Health Informatics, or a related discipline.
  • Completed coursework in databases, data analysis, statistics, or business intelligence.
  • Eligibility to participate in a co‑op work term, including any confirmation or documentation required by the educational institution.

We thank all applicants for their interest. Only those selected for an interview will be contacted.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data and Analytics Specialist
Data and Analytics Specialist

Recruiting In Motion - Eastern Ontario • Toronto

On-site
CAD 85,000 - 110,000
RQ08480 - Data Analytical Specialist/Scientist - Junior
RQ08480 - Data Analytical Specialist/Scientist - Junior

Rubicon Path • Toronto

On-site
CAD 60,000 - 80,000
Professional development opportunities
Flexible work hours
Data Solutions and Visualization Officer
Data Solutions and Visualization Officer

Altis • Ottawa

Hybrid
CAD 70,000 - 110,000
Lead, Methodologist, Analytics
Lead, Methodologist, Analytics

Ontario Health • Canada

On-site
CAD 90,000 - 110,000
Health coverage
Pension plan
Wellness accounts
+1
Lead, Methodologist, Analytics
Lead, Methodologist, Analytics

Ontario Health • Toronto

On-site
CAD 90,000 - 120,000
Health benefits
Wellness spending accounts
Defined benefit pension
+3
Lead, Methodologist, Analytics
Lead, Methodologist, Analytics

Ontario Health | Santé Ontario • Canada

On-site
CAD 90,000 - 120,000
Health benefits
Pension plan
Career development
Senior Analyst, Data Analytics
Senior Analyst, Data Analytics

Njoyn • Toronto

On-site
CAD 80,000 - 110,000
Retirement Planning Program
Generous vacation days for permanent
Work-life balance
+1
Data and Analytics Specialist
Data and Analytics Specialist

Options Consulting Solutions • Toronto

Hybrid
CAD 80,000 - 100,000
Competitive salary and annual bonus
Strong focus on professional development
Inclusive and collaborative culture
+2
Data Operations Analyst (10-Month Contract)
Data Operations Analyst (10-Month Contract)

Omers • Toronto

On-site
CAD 72,000 - 108,000
Annual incentive plan
Group benefits
Retirement plans
Data Analyst
Data Analyst

Acquird.io • Toronto

Hybrid
CAD 70,000 - 80,000
Health and Dental benefits + Annual 0%