This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a Senior Data Architect/Modeller to lead the development and implementation of enterprise data architecture within a complex, distributed environment. This role is focused on designing high-performance data warehouse and data lake solutions using the Microsoft Azure Stack. You will be responsible for determining data flow, optimizing database performance, and translating complex business needs into executable technical work packages. The successful candidate will play a pivotal role in maintaining enterprise data models and ensuring the seamless integration of Business Intelligence (BI) tools.
Job Responsibility:
Architectural Design: Develop and implement data architectures for application development, including data distribution, database location strategy, and access methodologies
Modelling & Warehousing: Create and maintain enterprise-level logical and physical data models using dimensional and Delta Lake concepts
Technical Leadership: Design and articulate complex technical concepts into development work packages
oversee the construction of data warehouses on the MS Stack (ADF, Databricks, SQL)
BI Optimization: Perform deep performance tuning of BI applications, including schema optimization and SQL stored procedure refinement
Documentation: Expand documentation of business processes relative to available data
maintain a comprehensive data dictionary
Testing & QA: Define and execute test plans (Unit, System, UAT) across the development lifecycle to ensure functionality and security
Collaboration: Coordinate with Business Analysts and Developers to refine requirements and address interdependencies
Requirements:
7+ years of experience in BI Data Architecture, data warehouse design, and dimensional modelling
2+ years of hands-on experience with Azure Data Lake and Azure Databricks SQL Warehouse
5+ years of advanced SQL experience (T-SQL and PL/SQL), including writing stored procedures and packages for datamarts
Extensive knowledge of modelling tools such as PowerDesigner or Visio, and BI metadata tools like Power BI
Demonstrated experience within the Azure DevOps environment
Proven track record in creating both Functional (FDD) and Detailed Design Documents (DDD)
Nice to have:
Familiarity with IBM Cúram (SAMS) and Enterprise Architecture frameworks like TOGAF or ArchiMate
What we offer:
Long-Term Engagement: 12-month initial contract with a strong potential for extension
Modern Tech Stack: Work extensively with Azure Databricks SQL Warehouse, Azure Data Lake, and Power BI
Strategic Impact: Influence enterprise-level data strategy for large-scale provincial systems
Professional Stability: Consistent onsite schedule at a premier Toronto office location