Senior Data Architect/Modeller

• 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

• 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)

Familiarity with IBM Cúram (SAMS) and Enterprise Architecture frameworks like TOGAF or ArchiMate

• 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