Senior Data Architect

This is a fully remote position, open to applicants in Canada.

📋 Description

• Design and manage the information platform.

• Establish data integration strategies and guidelines.

• Maintain consistency across technology platforms.

• Enhance infrastructure.

• Create a data architecture that promotes analytics and innovation.

• Ensure the interoperability of developed solutions.

• Adhere to data governance and quality standards.

⛳️ Requirements

• Proficient in both spoken and written French.

• Bachelor's degree in information technology, business administration, management, or a related discipline.

• MIFI equivalency is mandatory for degrees obtained outside of Québec.

• A minimum of TWENTY (20) years of experience in business intelligence, with at least FIFTEEN (15) years in data architecture and development team management.

• Involvement in at least FIVE (5) projects related to the development of analytical solutions that integrate clinical and administrative information systems.

• Experience in implementing at least one data governance strategy within a Québec healthcare network organization.

• Participation in at least FIVE (5) projects aimed at executing an organizational digital transformation plan centered on data management within Québec’s healthcare network.

• Proficiency in implementing event-driven and metadata-driven data architectures in the healthcare network.

• Advanced understanding of the Microsoft Office 365 suite.

• Skilled in the Microsoft Fabric platform, including Lakehouse, Data Warehouse, Direct Lake, Pipelines, and Notebooks.

• Expertise in Fabric development environments, including advanced use of Notebooks for data ingestion, transformation, exploratory analysis, and analytical solution prototyping.

• Comprehensive knowledge of Power BI and the Power Platform, which includes Power Automate, Power Apps, and Copilot Studio.

• Strong command of T-SQL, M, R, JSON, Python, and DAX.

• Expertise in data modeling and optimization techniques, including star and snowflake schemas, data warehouses, and managing aggregations, partitions, and refresh strategies in Fabric.

• Familiarity with Québec healthcare network clinical and administrative systems (essential).

• Extensive knowledge of MS SQL Server, Oracle, DB2, Sybase, Dataverse, NoSQL databases, Spark, and data flows using ELT, ETL, APIs, and formats like JSON.

• Experience with HL7 data integration.

• Familiarity with event-driven architectures and real-time data processing.

• Proven practical experience in implementing dynamic ETL processes and developing event-driven and metadata-driven development accelerators.

• Strong hands-on experience with SSIS, SSAS, and SSRS.

• Knowledge of security standards such as ISO 27001, GDPR, and SOC 2, along with cryptography and access management.

• Only candidates legally authorized to work for any employer in Canada will be considered.

🏝️ Benefits

• A minimum of 3 weeks of vacation starting from the first year.

• Comprehensive group insurance with a substantial employer contribution.

• Employer contributions to a group RRSP.

• Full remote work flexibility: hybrid, remote, or on-site.

• A warm, bright, and inviting office providing fresh fruit, coffee, beverages, occasional meals, and more.

• Annual IT equipment budget.

• A balanced work environment supporting flexible working hours.

• Career development opportunities, including training and certifications, online or in-person learning, Wepoint Academy, and more.

• An international community of experts eager to share their knowledge.

• A company culture that prioritizes individual needs and fosters a strong sense of community.