O

Ontario Medical Association

Represents physicians; shapes policy, improves care.

Senior Technical Specialist - Data Automation

Data Engineering +1Confirmed live in the last 24 hours
Full-timeToronto, ON, Canada

About the Job

Requirements

  • An 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 such as SQL, Power Automate, and scripting tools.
  • Strong experience with business intelligence platforms such as 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 such as Power BI or Azure, and/or Certified Data Management Professional (CDMP) designation are required.
  • 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 using Git, and DevOps practices for data environments.
  • Experience with additional business intelligence and analytics tools such as Tableau or Looker.
  • Experience working within the Microsoft 365 and Power Platform ecosystem.

Responsibilities

  • Design, deliver, and support automated data and reporting solutions that provide reliable data for organizational decision-making.
  • Lead the design, development, and maintenance of scalable automation workflows and data integrations across internal systems, including CRM platforms, Microsoft Purview, and Data Fabric/OneLake.
  • Replace manual and spreadsheet-driven processes with reliable automated solutions and ensure timely scheduled and on-demand data refreshes.
  • Develop and maintain dashboards, reports, and analytics solutions using Power BI, Excel, and related technologies.
  • Define and standardize key performance indicators and performance metrics, and provide clear, actionable insights to business stakeholders and senior leadership for operational, financial, and strategic decision-making.
  • Assess and validate data used in financial, operational, and strategic decision-making.
  • Collaborate with OMA Insurance and cross-functional teams to understand reporting and automation needs, translate business questions into scalable data solutions, and deliver strategic insights that improve efficiency, service delivery, and outcomes.
  • Establish and maintain data validation, reconciliation, and quality control frameworks across internal and external data sources.
  • Validate, challenge, and reconcile data received from external partners and vendors to ensure its accuracy, completeness, and integrity.
  • Align data practices with organizational governance, privacy, and security standards, and maintain documentation of data sources, assumptions, and transformations.
  • Identify opportunities to use automation, artificial intelligence, and advanced analytics to improve business processes.
  • Contribute to technology standards and best practices for data, reporting, and automation across the organization.
  • Manage and support the performance, maintenance, and enhancement of automated reporting environments to ensure reliability, scalability, and alignment with evolving business needs.

Desired Qualifications

  • Azure certification, experience with Microsoft Fabric IQ, and Microsoft Purview are considered assets.

About the Company

Ontario Medical Association

Represents physicians; shapes policy, improves care.

The Ontario Medical Association (OMA) is a professional body that represents more than 43,000 physicians and medical students in Ontario. What it does: it speaks for doctors’ political, clinical, and economic interests and supports front-line patient care. How its products work: the OMA helps doctors work with patients to promote healthy living and disease prevention, while also shaping health-care policy and leading initiatives to improve Ontario’s health system. How it differs from competitors: it combines advocacy, professional representation, and policy work for doctors, a long-standing organization founded in 1880 that aims to align medical practice with health-system improvements. Its goal: to support physicians and strengthen Ontario’s health care system so patients receive good care and the system runs effectively.

Company size
201-500
Company stage
Not listed
Total funding
Not listed
Headquarters
Toronto, Canada
Founded
1880

Recently Posted Jobs

Explore more opportunities at Ontario Medical Association

See more jobs