Data Architect/Modeller – Senior (Azure Databricks,BI Data Architect,ADF)
Toronto, ON, Canada
Applications have closed
Arthur Grand Technologies Inc
federal contracting opportunities, federal contracting, federal contracting companies, federal contracting for small business, federal contracting agencies, us federal contracting corp, federal contracting services, federal contracting...Company Description
Arthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years.
We are a minority owned staff augmentation and technology consulting company
To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.
Job Description
Position: Data Architect/Modeller – Senior
Location: Toronto, Ontario (Hybrid)
Hybrid - 3 days on site and 2 days remote
Duration: Long Term Contract
MUST HAVES:
Experience and Skill Set Requirements
Data Modeler Requirements:
- 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, Databricks, 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, 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 ETL pipelines. Assist with defect fixing and testing support for PowerBI 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. PowerBI, 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 tests across the development lifecycle (unit testing, system testing, user acceptance testing) and 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 resources will receive the required knowledge to support the system. 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 members
- Development 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 developers
Additional Information
All your information will be kept confidential according to EEO guidelines.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Consulting Databricks Data warehouse Data Warehousing DevOps Engineering ETL MS SQL Oracle Pipelines Power BI Security SQL Testing TOGAF T-SQL
Perks/benefits: Career development Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open DevOps-related jobs