Data and Platform Solutions Developer (Microsoft SSRS, and Power Platform) 

Permanent, Hybrid Role (Toronto Office) 

OntarioMD has an exciting opportunity for a Data and Platforms Solutions Developer to join our Development team. In this role you will support enterprise reporting, analytics and business platform solutions. The primary focus of the role is reporting and analytics (using Microsoft SSRS and PowerBI as a secondary tool). Additional job responsibilities are concentrated on low-code/ no-code business applications development  using Microsoft Power Platform (Power Apps and Power Automate).  

Specific Job Duties:  

Reporting and Analytics 

• Collaborate with stakeholders to translate business requirements into data models, SQL queries, analytics structures, and reporting solutions that support operational and analytical needs.  

• Design, maintain, and evolve logical and physical data models supporting application, reporting, and analytics use cases.  

• Provide application‑level SQL development expertise in partnership with development and delivery teams, ensuring scalable, maintainable, and well‑documented data access patterns.  

• Maintain and incrementally enhance existing reporting and analytics assets, including report definitions, SQL query logic, and supporting data structures.  

• Review and improve application SQL and data access patterns, providing performance, scalability, and data‑quality recommendations as appropriate. 

• Support application‑level data changes and controlled data movement activities for development, testing, and solution delivery, in collaboration with Operations and database administrators.  

• Support Operations by analyzing data‑related or solution‑related issues in non‑production environments and supplying technical findings or recommendations, without platform administration responsibility.  

• Document data models, solution designs, configurations, and data flows across analytics and no‑code solutions to promote knowledge sharing and reduce single points of failure. 

Low-Code/ No-Code Business Applications 

• Design, develop, and support low‑code/no‑code business applications and workflow automations on enterprise platforms, including ongoing enhancements and operational support.  

• Partner with business users to improve solution usability, performance, data quality, and adoption across both analytics and no‑code solutions.  

The role has high confidentiality expectations and no people management responsibilities or budget authority 

Requirements that are important to us: 

• Minimum 5 years' experience working with Microsoft technologies including SSRS and Power Platforms (Power Apps, and Power Automate).  

• Degree or diploma in Computer Science, Engineering, or a related field/ equivalent experience. 

• Strong experience with T‑SQL and relational data concepts, including query design and optimization in an application‑development context (Microsoft SQL Server).  

• Experience maintaining and enhancing SSRS reports, including report logic and definitions.  

• Hands‑on experience developing and supporting low‑code/no‑code business solutions using Microsoft 365 platforms (e.g., Power Platform, SharePoint Online, Dynamics 365).  

• Experience using analytics and reporting tools such as Power BI and Excel. 

• Experience supporting application‑level data changes and data migration activities, including ETL processes.  

• Working knowledge of Microsoft Azure data services used to support application, reporting, and analytics solutions, including relational and non‑relational data platforms (e.g., Azure SQL and other Azure‑hosted data services). 

What we Offer: 

Base salary range of $80,000 - $95,000 annually; final compensation offered will be determined based on experience, skill set, education, training, and internal equity.  

• Fun, friendly, and dynamic work environment with a passion for digital health. 

• Hybrid working model. 

• Participation in our discretionary bonus program, in accordance with our policy.  

• Matched defined contribution pension plan. 

• Comprehensive health, dental and vision plans, with 100% employer-paid premiums. 

• Extended mental health coverage. 

• Maternity and parental leave top-up programs. 

• Short-term and long-term disability programs. 

• Employee/family assistance programs. 

• Professional development opportunities. 

• Two (2) annual paid volunteer days to contribute to causes that matter to you. 

• One (1) annual floater day. 

• Fantastic opportunity to grow within the team and throughout the organization. 

• An organization recognized as one of the Best Places to Work in Canada for 2025 by HRD Canada. 

How to Apply:   

We are excited to share this opportunity, which is for an existing vacancy. Kindly be advised that our recruitment process does not involve the use of Artificial Intelligence.  

Interested candidates are invited to apply online through our careers page. Applications will be considered until May 20th, 2026 at 4 pm.   

For further information, visit our website at www.ontariomd.ca. We regret that only those selected for an interview will be contacted. OntarioMD 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.