Job Title

Job Overview 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 handson experience with Azure Data Lake and Azure Databricks SQL Warehouse. SQL Proficiency: 5+ years of advanced SQL experience (TSQL 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 Cram (SAMS) and Enterprise Architecture frameworks like TOGAF or ArchiMate. Summary If you are a seasoned Data Architect with a passion for Azure Databricks and enterprisescale modelling in Toronto, we encourage you to apply today! Equal Employment Opportunity Statement 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 equityseeking groups who are usually underrepresented in Canadas workforce, including those who identify as women or nonbinary/gender nonconforming, 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 [email protected] to ensure their ability to fully participate in the interview process. #J-18808-Ljbffr