Job Title:Data Architect/Modeller - SeniorLocation:Toronto ON (Onsite)Duration:12+ Months (Possible Extension)Pay Rate:CAD 90-100/HourMust Have7+ years in data modelling and data warehouse design (Must Have)2+ years Azure Data Lake and Azure Databricks SQL Warehouse (Must Have)5+ years SQL (Must Have)Public sector experience prior MandateEvaluation Criteria:Design Documentation and Analysis Skills (30 points)Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.Work with the Client & Developer(s) assigned to refine/confirm Business RequirementsParticipate in defect fixing, testing support and development activities for ETL pipelines. Assist with defect fixing and testing support for PowerBI reports.Analyze and document solution complexity and interdependenciesBI Data Modelling and Technical Skills (40 points)Understanding of Data Modelling for Business Intelligence including:Expert Knowledge of data warehouse design methodologies, delta lake and dimensional modeling in particularUnderstanding of Extract/Transform/Load processes to transform data for reporting/BI purposesAbility to define schema for reporting databasesExperience with advanced modeling toolsKnowledge of BI tools for metadata modeling and report design (e.G. PowerBI, Cognos)Good knowledge and experience in MS SQL Server technology, Azure Databricks SQL Warehouse,



Azure Data LakeExperience using T-SQL, PL/SQL for development of Business Intelligence applications. Demonstrated skills in writing and reverse engineering SQL stored procedures and packages for datamarts and reporting.Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimizationQuality Assurance (20 points)Demonstrated experience in defining and executing test plans across the development lifecycle (unit testing, system testing, user acceptance testing) and in using results to refine database designKnowledge Transfer (10 points)The Architect / Modeler must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the internal staff receive the required knowledge to support the platform. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.Development of documentation and materials as part of a review and knowledge transfer to other membersDevelopment of specific activities as part of a review (hand over to ministry staff) and building block approach which,



build on knowledge transfer and skills development from the previous stage to the next.Development and facilitation of classroom based or virtual instructor demo led sessions for developersMonitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completedAssets:Knowledge of Curam IBM COTS solutions (Social Assistance Management System)ETL/ELT design conceptsKnowledge of Enterprise Architecture tools and frameworks (ArchiMate, TOGAF, Zachmann)If this prospect matches your experience and career goals, please share your most updated resume for consideration.As a certified minority-owned business, Pride Global and its affiliates - including Russell Tobin, Pride Health, and Pride Now - are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics.Russell Tobin is a leading minority-owned professional and technical recruitment and staffing advisory organization. We are comprised of specialized practices focusing on a variety of skill sets and industries. Having a depth and breadth of industry expertise, our subject matter experts are able to provide tailored and swift sourcing solutions to fulfill client hiring needs. In other words, we connect top talent with companies. We are the staffing arm of the Pride Global network, a minority-owned integrated human capital solutions firm, with additional offerings in vendor management, payroll programs, and business process optimization.#RTA#J-18808-Ljbffr

📌 Data Architect/Modeller- Senior - C$90 - C$100 An Hour (Toronto)
🏢 Pride Global
📍 Toronto