Azure Data Architect

Azure Data Architect (contract to December 2026)Are you looking to join one of Greater Toronto's Top 2025 Employers? 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.Job SummaryIn this role, the Azure Data Architect holds primary accountability for designing, deploying, and sustaining robust data solutions utilizing Microsoft Azure technologies. The position requires deep expertise in SQL Server, Azure Synapse Analytics, and Microsoft Fabric to facilitate seamless data integration, advanced transformation, and comprehensive governance. The incumbent ensures that all technical specifications align with core business requirements, while also fostering innovation through the adoption of modern platforms and frameworks. Operating within a collaborative, agile team environment, this position is integral to delivering secure, scalable, and high-performing data architectures that drive organizational objectives.ResponsibilitiesDesigning and developing scalable data pipelines and ETL processes using Azure Data Factory, Synapse Analytics, and Microsoft Fabric Notebooks (PySpark)Building and optimizing data models, creating insightful reports, and managing interactive dashboardsCollaborating with stakeholders to gather data requirements and deliver tailored, data-driven solutionsMonitoring, troubleshooting, and enhancing performance of data pipelines and workflows across platformsEnsuring data security, privacy, and compliance with organizational and regulatory policiesDocumenting data pipelines, workflows, tables, and analytical processes for transparency and maintainabilityQualificationsInformation Technology, Computer Science, Computer Engineering or equivalentFour to five years of experience with designing and deploying Azure solutions, including coding and infrastructure developmentProven ability to work collaboratively across technical teams and communicate with diverse stakeholder groupsProficient in business analysis, including documentation and technical specificationsWork arrangementsThe OMA has moved to a permanent hybrid work environment. As such, the individual in this position will be required to work a minimum number of days in our Toronto office.What we have to offerA work environment whose values are to be respectful, bold, responsive, and transparent in our work and our behavioursA fantastic opportunity to grow with the team and help shape the strategic direction of the OMA, its members and the health-care systemAn organization that is committed to the equity, diversity and inclusion principles of humility, accountability, collaboration, courage and integrityA friendly and flexible hybrid work environmentCompetitive compensationAn organization that has been recognized as Greater Toronto's Top Employers for five consecutive yearsAs a condition of employment, OMA conducts background checks and reference checks for all open positions.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. #J-18808-Ljbffr