Job Description & How to Apply Below
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)
Description
Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.
Responsibilities
Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.
Skills
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)
Expert knowledge developing data warehouse solutions on MS Stack (Azure Data Lake, SQL, ADF, Databricks, Power
BI) 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 business analysts to identify future needs and requirements.
Extensive knowledge of data modelling tools (e.g. Power Designer, 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, 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 Dev Ops
Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization
Please note, this position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day
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)
Knowledge of Enterprise Architecture tools and frameworks (Archi Mate, 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 ETL pipelines. Assist with defect fixing and testing support for Power
BI reports.
Analyze and document solution complexity and interdependencies
BI Data Modelling and Technical Skills (40 points)
Understanding of Data Modelling for Business Intelligence including:
a. Expert Knowledge of data warehouse design methodologies, delta lake and dimensional modeling in particular
b. Understanding of Extract/Transform/Load processes to transform data for reporting/BI purposes
c. Ability to define schema for reporting databases
d.
Experience with advanced modeling tools
Knowledge of BI tools for metadata modeling and report design (e.g. Power
BI, Cognos)
Good knowledge and experience in MS SQL Server technology, Azure Databricks SQL Warehouse, Azure Data Lake
Experience 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 optimization
Quality 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 design
Knowledge 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…
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×