Data Analyst

• Reports to: Manager, Application Support
• Salary Range: $80,000 – $100,000 annually
• Work Model: Hybrid – requirement of 2 days per week/8 days per month in office. All duties carried out remotely must be completed from the employee’s approved home office within Ontario.
• Why Join Us?
  • Competitive salary
  • 100% employer-paid medical, dental, and vision coverage
  • Health care spending account and wellness spending account
  • Vacation time, starting at three weeks and Service Milestone Program
  • Personal, wellness, birthday, volunteer, and sick/caregiving days, plus additional OMVIC holidays
  • Parental leave top-up program
  • Employer Group Registered Retirement Savings Plan (GRRSP) contributions
  • Employee discount program and gym membership savings
  • Professional development and learning support
  • Hybrid work environment for head office employees

Role Summary: 

Reporting to the Manager, Application Support, the Data Analyst collects, cleans and interprets complex data sets into clear insights, reports, and dashboards that support decision-making across the organization.

Working with Application Support and business stakeholders, the Data Analyst delivers analytics that align with business needs, apply consistent definitions, and strengthen data literacy and self-service reporting. The role supports operational, management, and regulatory reporting and contributes to analytics standards, processes, and practices.

Responsibilities:

• Develop, maintain, and enhance dashboards, reports, surveys, and analytics solutions using tools such as Power BI and ClickDimensions.
• Gather and document business requirements; translate business needs into analytical solutions, reports, and actionable insights.
• Analyze trends, performance metrics, and data patterns to support operational, tactical, regulatory, and strategic decision-making.
• Develop, transform, integrate, validate, and maintain analytics-ready datasets, data models, and semantic layers.
• Ensure data accuracy, consistency, and adherence to business rules by reconciling data and coordinating the resolution of data quality issues with stakeholders and vendors.
• Support recurring and ad hoc reporting requests while managing multiple priorities, timelines, and business needs.
• Present findings and insights to technical and non-technical audiences, including senior leadership, and support self-service analytics adoption and data literacy initiatives.
• Collaborate with Application Support, business stakeholders, and external vendors on reporting, analytics, data integrations, and platform enhancements.
• Contribute to analytics standards, best practices, governance, documentation, certified datasets, dashboards, and continuous improvement initiatives.
• Ensure the secure and compliant use of data by applying appropriate privacy, security, and access controls to analytics solutions.
• Other duties as required.

Qualifications:

• University degree in data analytics, information systems, computer science, statistics, or related discipline.
• Three to five years of experience in data analysis or business intelligence, including developing reports, dashboards, and data-driven insights.
• Strong proficiency in SQL and data analysis techniques, with experience preparing, transforming, and modelling data using relational data models and analytics-ready datasets.
• Hands-on experience with Power BI or a similar business intelligence tool, including Power Query and dataflows.
• Strong familiarity with Dynamics 365 Customer Service (CS/CRM) data structures, tables, and Dataverse entities (Microsoft Dataverse).
• Experience with data import/export frameworks, Excel add-ins, and basic API integrations.
• Proficiency with Microsoft Excel for data analysis, validation, and reporting.
• Strong analytical and problem‑solving skills, with attention to detail.
• Strong written, verbal, and presentation skills, with the ability to explain analytical findings clearly to technical and non-technical audiences, including senior leadership.
• Experience working in regulated, public sector, or complex enterprise environments is an asset.
• Demonstrated ability to exercise sound judgement in balancing analytical rigor, business priorities, and regulatory considerations.
• Relevant certifications in data analytics, Power BI, Microsoft Fabric, data management, or cloud technologies and familiarity with AI-enabled analytics tools an asset.

We respectfully thank all applicants for their interest in working at OMVIC. However, we will only contact those meeting the qualifications for an interview.

OMVIC fosters a workplace that respects the dignity, ideas, and beliefs of all individuals and is committed to promoting diversity, equity, inclusion, and a culture of fairness, respect, and belonging. OMVIC is committed to providing accessible employment practices in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and to ensuring that all individuals are treated with dignity and respect throughout the recruitment process.

As part of the recruitment process, OMVIC may use artificial intelligence (AI) tools to assist with the screening, assessment, and evaluation of employment applications. These tools are intended to support, not replace, human decision-making. All hiring decisions are reviewed and made by qualified individuals based on candidates’ skills, qualifications, experience, and overall suitability for the role. OMVIC is committed to the responsible and fair use of AI in a manner that supports equitable employment opportunities.

If you require accommodation due to a disability at any stage of the recruitment process, please contact the Human Resources department.