General Responsibilities
- Review business requirements, familiarize with and understand business rules and transactional data model
- Define conceptual, logical model and physical model mapping from data source to curated model and data mart.
a) Analyze requirements and recommend changes to the physical model.
b) Develop scripts for the physical model, create database and / or delta lake file structure.
c) Access Oracle DB environments, set necessary tools for developing solution.
Implement data design methodologies, historical and dimensional models
a) Develop curated model to store historical data captured incrementally from source
b) Design dimensional data mart models, create source-to-target-mapping documentation, design and document data transformation from curated model to data mart
c) Perform data profiling, assess data accuracy, design and document data quality and master data management rules
Functionality Review, Data Load review, Performance Review, Data Consistency checks.
a) Help troubleshooting data mart design issues
b) Review performance of ETL with developers and suggest improvements
- Participate in end-to-end integrated testing for Full Load and Incremental Load and advise on issues
- Plan for Go Live, Production Deployment.
a) Work with system administrator, ETL developers and ministry team to define production deployment steps.
b) Configure parameters, scripts for go live. Test and review the instructions.
c) Review release documentation
Go Live Support and Review after Go Live.
a) Review data models, ETL process, tools and provide recommendation on improving performance and reduce ETL timelines.
b) Review Infrastructure and any performance issues for overall process improvement
- Proactively communicate with stakeholders on any changes required to conceptual, logical and physical models, communicate and review dependencies and risks.
- Knowledge Transfer to Ministry staff, development of documentation on the work completed.
a) Document share and work on the architecture end-to end-working knowledge, Troubleshooting steps, configuration and scripts review.
b) Transfer documents, scripts and review of documents.
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, 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 te am 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) and amp; 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 and amp; 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 :
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 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
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 and amp; 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
- Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed
Data Architect Modeler 5782
Perform data profiling, assess data accuracy, design and document data quality and master data management rules. BI Data Architect experience in enterprise applications and solutions design/development and related with data warehousing, data lake implementations and dimensional modelling. Design dim...
Senior Manager - Project Accounting
Senior Manager - Project Accounting to join a dynamic team environment. Manage and oversee the full accounting cycle for multiple development projects. Monthly review of projects’ trial balances and maintenance of key schedules for letters of credit, loan amortizations, other and accrued liabilities...
Technical Business Analyst
Technical Business Systems Analyst". Job Title: Technical Business Systems Analyst. Product Owner or Business Systems Analyst designing technical IT applications and systems solutions. Determine operational objectives by studying business functions and gathering requirements from multiple stakeholde...
Senior Project Manager (Fire Protection)
Project Manager/Estimator (Sprinkler Contractor) – GTA. As a Project Manager/Estimator, you’ll be welcomed into a culture that values every team member’s expertise and growth. A proven track record in project management and estimating within fire protection, with successful project...
Data Entry Clerk (Remote) - Work Independently
Data Entry Clerk Work From Home - Part Time Remote Focus Group Panelists. Data entry clerk experience is not necessary. If you are a data entry clerk or someone just looking for a flexible part time remote work from home job, this is a great way to supplement your income. No Data Entry experience ne...
Educator, Data Scientist
Data Scientist or Analytics professional and a Bachelor’s degree relevant to the subject matter OR 8+ years work experience in the vocation. BrainStation is a global leader in digital skills training and development, offering a 12-week bootcamp program in Data Science. BrainStation is currently hiri...
data modeler
Research and document data requirements, data collection and administration policy, and data access rules. Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models. Conduct research regarding availability and suitability of data. ...
Senior Database Administrator
Understands data in terms of its business and technical lifecycle (Create, Release, Update, and Delete), technical underpinnings of database theories (e. Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Proac...
Senior IT Project Manager
Within Manulife's Canadian Segment, the Technology Planning & Delivery team is seeking a hardworking Senior IT Project Manager to join the team. The successful candidate will join a team of established IT Project Mangers. Strong Project Management skills (PMP and/or Agile certifications are a plus!)...
Solution Architect/Sr techncila Architect MSD 365
Create and Manage the EE Implementation architecture with very strong knowledge in Microsoft Dynamics architecture, customization, configuration, integration, coding, design patterns and custom business logic. Responsible for architecting the Dynamics system. Design review of D solutions including i...