Job Description :
Technology Architect - Level 3 Toronto, ON Contract Must Have (please read full requirements) Previous experience with Azure ETL & Datafactory Deliverables The Services and Deliverables to be provided by the Vendor will include the following: Delivery of full scope of solution on-time Participate in the review of project artefacts User story, System Requirement Specification, System Architecture, System Design, etc.; Provide direction to Development teams (ETL developers, Data modelers, DevOps team), including but not limited to: - Guidance on ETL design, error handling, data model design, exception handling, data integrity/validation - Recommendations on ETL/solution design based on benefit/drawback analysis - Assistance with triage of issues related to data integrity, ETL performance, etc. Facilitate and ensure cross-team collaboration towards effective/timely decision-making Act as liaison with Program Management/Leadership, Business/Product Owners throughout delivery phase for key activities such as but not limited to: - Risk prevention and management - Identify critical path and key dependencies - Provide delivery activity estimations (durations, resourcing) Iterative review of and approval for system/solution design documents and any other supporting documentation conforming to Ministry standards Provide effective knowledge transfer to Ministry staff at all stages of this assignment : Skills and Experience: Extensive experience with performance optimizing techniques for Azure Synapse databases Extensive experience with data warehouse design, fact/dimension tables, star/snowflake schema Extensive knowledge of Azure SQL DB and Synapse platforms, including: Distributed vs. Replicated tables Dynamic scaling Polybase (vs. BCP) MPP/table distribution design Extensive experience with Azure Data Factory including Self-Hosted Integration Runtime Expert-level knowledge with T-SQL and Azure Synapse stored procedure development Extensive experience with CI/CD (DevOps) pipelines and concepts, including Azure Resource Management Extensive experience with Azure DevOps, including: Azure Boards Azure Test Plans Azure Pipelines Azure Repos Azure Artifacts 10+ years experience with data warehouse design/build, data analytics 10+ years experience with leading large-scale 3M+) IT Project delivery teams delivering data warehouse solutions 5+ years experience with Agile delivery methodologies (i.e. Scrum) Experience with managing multiple parallel development environments/repositories, including branching, managing merges/conflicts etc. Excellent analytical, problem solving skills Excellent interpersonal, communication and presentation skills Solid business acumen, ability to dialogue with Business teams/leadership to understand their priorities/goals, with intense focus on delivering Business value

Similar Jobs you may be interested in ..