Senior Data Architect Modeller Contract

*************************************************
Client: Government
Location: Toronto (hybrid)
Type: Contract
Role: Data Architect
Term: 150 working days + extension
Rate: Open
Start date: 2/3 weeks
Req ID: 5782
*************************************************
On behalf of our Government client, Wirehead has a new contract opportunity for a Senior Data Architect/Modeller.

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications

• 7+ years BI Data Architect experience in enterprise applications and solutions design/development and related with data warehousing, data lake implementations and dimensional modelling.
• Collect business-level questions and propose approaches to address business needs and provide data insights.
• Expand documentation and knowledge of business processes relative to available data to provide contextual guidance for operation/project, reporting and insights generation.
• Ability to design and articulate complex technical concepts into executable development work packages.
• Knowledge of BI tools for metadata modeling and report design (e.g. Power BI)
• MS SQL Server Technology, Azure Data Lake, Azure Databricks
• Expert knowledge developing data warehouse solutions on MS Stack (Azure Data Lake, SQL, ADF, Databrciks, PowerBI) to store and retrieve centralized information. Experience designing the data warehouse using dimensional and delta lake concepts.
• Create/maintain enterprise data model and data dictionary. Help development team to optimize database performance. Coordinate with the Integration department to identify future needs and requirements.
• Extensive knowledge of data modelling tools (e.g. SAP PowerDesigner, Visio)
• Review, install and configure information systems to ensure functionality and security. Analyze structural requirements for new data warehouse and applications
• Experience using Oracle database server and tools (12c, 19c), PL/SQL for development of Business Intelligence applications.
• Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting.
• Demonstrated experience in Azure DevOps
• Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization

Skills:

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

Assets:

• Knowledge of Curam IBM COTS solutions (Social Assistance Management System)
• ETL design concepts
• Knowledge of Enterprise Architecture tools and frameworks (ArchiMate, TOGAF, Zachmann)

Evaluation 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 Requirements
• Participate in defect fixing, testing support and development activities for Informatica/ETL tool. Assist with defect fixing and testing support for Cognos reports.
• Analyze and document solution complexity and interdependencies

BI 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 particular
• Understanding of Extract/Transform/Load processes to transform data for reporting/BI purposes
• Ability to define schema for reporting databases
• Experience with advanced modeling tools,
• Knowledge of BI tools for metadata modeling and report design (e.g. PowerBI, Cognos 10/11)
• Extensive knowledge and experience in MS SQL Server Technology, Azure Databricks SQL Warehouse, Azure Data Lake
• Experience using Oracle database server and tools (12c, 19c), 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 optimization

Quality Assurance (20 points)

• Demonstrated experience in defining and executing tests across the development lifecycle (unit testing, system testing, user acceptance testing) and using results to refine database design

HOW TO APPLY

Please apply for this opportunity by using the Apply button or sending your resume directly to careers@wirehead.com

We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.

***This opportunity is in Toronto; preference will be given to local candidates. Wirehead does not offer a relocation package. We encourage you continue to refer to our Job listing page as new opportunities become available and updated on a regular basis. Thank you again for your interest in Wirehead!

Tagged as: azure databricks