Database architect Jobs in Markham, ON

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.

Rate : $600.69-$635.47 / diem

Advantages

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.

Responsibilities

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.

Qualifications

Core Expertise : 7+ years of experience in BI Data Architecture, data warehouse design, and dimensional modelling.

Azure Mastery : 2+ years of hands-on experience with Azure Data Lake and Azure Databricks SQL Warehouse.

SQL Proficiency : 5+ years of advanced SQL experience (T-SQL and PL / SQL), including writing stored procedures and packages for datamarts.

Tools : Extensive knowledge of modelling tools such as PowerDesigner or Visio, and BI metadata tools like Power BI.

Cloud DevOps : Demonstrated experience within the Azure DevOps environment.

Design Excellence : Proven track record in creating both Functional (FDD) and Detailed Design Documents (DDD).

Niche Knowledge (Assets) : Familiarity with IBM Cúram (SAMS) and Enterprise Architecture frameworks like TOGAF or ArchiMate.

Summary

If you are a seasoned Data Architect with a passion for Azure Databricks and enterprise-scale modelling in Toronto, we encourage you to apply today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.