Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Senior Technical Specialist, Data Automation is a vital member of OMA’s Technology Department, responsible for designing, delivering, and supporting automated data and reporting solutions to ensure the organization has access to reliable data for informed decision-making. This role focuses on reducing manual processes, improving data reliability, and providing timely insights to OMA Insurance, Members, and Executive Leadership, acting as a trusted partner to translate complex requirements into scalable, automated analytics solutions.

Responsibilities

Leading the design, development, and maintenance of scalable automation workflows and data integrations across internal systems.
Replacing manual and spreadsheet-driven processes with reliable automated solutions.
Ensuring timely scheduled and on-demand data refreshes.
Developing and maintaining dashboards, reports, and analytics solutions using Power BI, Excel, and related technologies.
Defining and standardizing KPIs and performance metrics.
Providing clear, actionable insights to business stakeholders and senior leadership.
Critically assessing and validating data used in financial, operational, and strategic decision-making.
Collaborating with OMAI Insurance and cross-functional teams to understand reporting and automation needs.
Translating business questions into scalable data solutions.
Establishing and maintaining robust data validation, reconciliation, and quality control frameworks.
Ensuring the accuracy, completeness, and integrity of data received from external partners and vendors.
Aligning with organizational data governance, privacy, and security standards.
Maintaining comprehensive documentation of data sources, assumptions, and transformations.
Identifying opportunities to leverage automation, AI, and advanced analytics to improve business processes.
Contributing to the development of technology standards and best practices for data, reporting, and automation.
Managing and supporting the ongoing performance, maintenance, and enhancement of automated reporting environments.

Requirements

Undergraduate Degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent experience.
Five or more years of experience in data analytics, reporting and automation.
Strong experience with data automation and transformation tools (e.g., SQL, Power Automate, scripting tools).
Strong experience with business intelligence platforms (e.g., Power BI).
Strong experience with advanced Excel functions and tools, including Power Query, Power Pivot, and complex formulas.
Strong experience with Microsoft data platforms and technologies, including Microsoft Purview and Data Fabric/OneLake.
Proven ability to translate business requirements into effective technical solutions.
Microsoft certifications in relevant technologies (e.g., Power BI, Azure) and/or Certified Data Management Professional (CDMP) designation required.
Azure certification, experience with Microsoft Fabriq IQ, and Microsoft Purview considered an asset.
Experience working within a membership-based, healthcare, or not-for-profit organization.
Familiarity with enterprise data governance, privacy, security, and compliance standards.
Experience with cloud data platforms such as Snowflake, BigQuery, Redshift, Azure, AWS, or GCP.
Familiarity with CI/CD, version control (Git), and DevOps practices for data environments.
Experience with additional BI and analytics tools such as Tableau or Looker.
Experience working within the Microsoft 365 and Power Platform ecosystem.
Background checks and reference checks will be conducted as a condition of employment.

Skills

Data automation
Data integration
CRM platforms
Microsoft Purview
Data Fabric/OneLake
Power BI
Excel
SQL
Power Automate
Scripting tools
Advanced Excel functions
Power Query
Power Pivot
Complex formulas
Microsoft data platforms
Data analytics
Reporting
Business intelligence
Data validation
Data reconciliation
Data quality control
Data governance
Privacy standards
Security standards
AI
Advanced analytics
CI/CD
Version control (Git)
DevOps practices
Tableau
Looker
Microsoft 365
Power Platform

Location

Toronto

Work Type

Hybrid
Full-time

Experience Level

Senior
Five or more years of experience in data analytics, reporting and automation

Education Level

Undergraduate Degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent experience

Salary/Compensations

$96,315 - $98,640

Benefits

Pension plan
Bonus program
Exceptional group benefits package
Spending account
Robust wellness program
Paid professional development
Continuous in-house learning

About the Company

The Ontario Medical Association (OMA) advocates for and supports doctors, seeking to strengthen their leadership role in caring for patients.
We continually seek to be the trusted voice in transforming Ontario’s health-care system by courageously pursuing best practices, new ideas, solutions, and opportunities to improve.
A work environment whose values are to be respectful, bold, responsive, and transparent in our work and our behaviours.
An organization that is committed to the equity, diversity and inclusion principles of humility, accountability, collaboration, courage and integrity.
An organization that has been recognized as a Greater Toronto’s Top Employers for six consecutive years.

Equal Opportunity

The Ontario Medical Association is strongly committed to diversity within its community and welcomes applications from racialized persons/persons of colour, women, Indigenous People of North America, persons with disabilities, LGBTQ2S+ persons, and others who may contribute to the further diversification of ideas.
In accordance with the AODA Act, accommodation will be provided throughout the recruitment process to applicants with disabilities.