Data Analyst

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.

Skills & Competencies:

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.