- 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.
- Implement data design methodologies, historical and dimensional models
- Functionality Review, Data Load review, Performance Review, Data Consistency checks.
- Participate in end-to-end integrated testing for Full Load and Incremental Load and advise on issues
- Plan for Go Live, Production Deployment.
- Go Live Support and Review after Go Live.
- Proactively communicate with stakeholders on any changes required to conceptual, logical and physical models, communicate and review dependencies and risks.
- Knowledge Transfer, development of documentation on the work completed.
- 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
- 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)
- Knowledge of Curam IBM COTS solutions
- ETL design concepts
- Knowledge of Enterprise Architecture tools and frameworks (ArchiMate, TOGAF, Zachmann)
- 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
- Understanding of Data Modelling for Business Intelligence including:
- 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
- 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
- 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 Modeler
1 week ago
Compest Solutions Inc Toronto, Canada**Data Modeler with PowerDesigner or ERWin** · **Location: Toronto - ON** · **Rate CAD$60-65/hr on Inc/Corp to Corp** · Data Modeler (Toronto, Canada): · - 10+ years of **expertise **in **data modeling principles/methods including conceptual, logical & physical Data Models**: · - ...
-
Data Modeler
6 days ago
Royal Bank of Canada Toronto, Canada**Come Work with Us** · At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. · Whether you're helping clients find new opportunities, developing new tech ...
-
Data Modeler
2 days ago
Tata Consultancy Services Toronto, Canada**About TCS** · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide t ...
-
Data Modeler
6 days ago
Tata Consultancy Services Toronto, Canada**About TCS** · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide t ...
-
Data Modeling Analyst
2 days ago
Wellington-Altus Private Wealth Inc. Toronto, Canada**Data Modeling Analyst** · **Location**:This position will be in our Toronto or Winnipeg office. · **Our organization**: · Founded in 2017, Wellington-Altus Financial Inc. (Wellington-Altus) is the parent company to Wellington-Altus Private Counsel Inc., Wellington-Altus USA Inc ...
-
Lead Data Modeler
12 hours ago
The Salvation Army Canada and Bermuda Toronto, Canada**Lead Data Modeler** · **Location: Hybrid/GTA** · **Division: Information Technology, Enterprise Data Warehouse** · **About The Salvation Army** · For more than 130 years, The Salvation Army (TSA) has had the privilege of serving vulnerable people in communities across Canada an ...
-
Modeling and Data Science Consultant
6 days ago
BMO Financial Group Toronto, Canada33 Dundas Street West Toronto Ontario,M5G 3C2 · This role provides advanced analytical, data driven, and programming expertise to support the development, documentation, validation, monitoring, reporting, and implementation of AIRB models. Supports the research and development of ...
-
Data Scientist, Ai Model Risk
12 hours ago
Royal Bank of Canada Toronto, Canada**Come Work with Us** · At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. · Whether you're helping clients find new opportunities, developing new tech ...
-
Scotiabank Toronto, CanadaRequisition ID: 174107 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **Job Purpose** · The Global Sanctions & Screening Payment team is a risk management function responsible for the governance of sanctions screening so ...
-
Data Modeler
3 days ago
Adastra Corporation Markham, CanadaOverview: · Adastra corporation is hiring As Canada's leading Data and AI company, we are looking for a skilled Data Modeler with in-depth expertise with dimensional modeling and demonstrated experience with conceptual, logical and physical modeling. · **Location**: Remote · **St ...
-
Data Modeler
1 day ago
Cognizant Mississauga, CanadaThis is a remote position open to any qualified applicant in Canada and The United States. · **We are Cognizant Artificial Intelligence** · Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better th ...
-
Data Modeler
12 hours ago
Cognizant Technology Solutions Mississauga, CanadaThis is a remote position open to any qualified applicant in Canada and The United States. · We are Cognizant Artificial Intelligence · Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than e ...
-
epsilonsolutions Toronto, Canada**Title · - DATA Modeler** · **Job Type · - Long Term Contract** · **Job Location · - Toronto, ON** · **JD**: · **Data Modeler with SQL and DATA Volte.** · **Job Type**: Fixed term contract · **Salary**: Up to $60.00 per hour · Expected hours: 55 per week · **Benefits**: · - Dent ...
-
Data Modeler
4 days ago
Bevertec Toronto, CanadaDeep expertise in how to productionize data models(python, SQL and Power BI) · Expert in Python, data analysis, and analytics background. · Previous Pensions or Financial services/bank experience is a must · 3+ years of extensive experience converting predictive models to product ...
-
EY Toronto, CanadaAt EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build ...
-
Data Modeler
1 day ago
Bevertec Toronto, CanadaDeep expertise in how to productionize data models(python, SQL and Power BI)Expert in Python, data analysis, and analytics background.Previous Pensions or Financial services/bank experience is a must3+ years of extensive experience converting predictive models to production.Stron ...
-
Data Modellers
1 week ago
Tundra Technical Solutions Inc. Toronto, ON, CanadaPosition Title: Data Engineer · Downtown Toronto- 2 days per week · Build and maintain data pipelines in Azure Databricks. · Develop scalable and reliable solutions using Python and PySpark. · Construct complex SQL queries for data profiling, efficient data manipulation and r ...
-
Data Modeler
1 hour ago
Tundra Technical Solutions Inc. Toronto, ON, CanadaPosition Title: Data Modeler · Location: Hybrid Work closely with business stakeholders and analysts to align data needs with business requirements and organization's strategic goals · Conduct data discovery and trace data lineage · Write complex SQL queries for intricate dat ...
-
Data Modeler
4 days ago
Tundra Technical Solutions Inc. Toronto, ON, CanadaPosition Title: Data Modeler · Work closely with business stakeholders and analysts to align data needs with business requirements and organization's strategic goals · Conduct data discovery and trace data lineage · Write complex SQL queries for intricate data analysis, profil ...
-
Data Modeller
1 week ago
Insight Global Toronto, ON, CanadaDay-to-Day · Insight Global is looking for a Data Modeler to join a leading digital healthcare Solutions provider on a contract to hire. The resource will play a key role in designing and implementing data models for healthcare information exchange. In this role, you will leverag ...
Data Modeller 5782 - Toronto, Canada - Foilcon
Description
Description :
As part of the modernization of the analytics platform, review existing data model and redesign to be scalable and flexible to meet current program and client needs for analytical and operational reporting . Support data migration plan to redesign current on-premise or hybrid processes from a SQL Server environment to cloud-based data lake built on Azure Data Lake service, using Azure Databricks
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.
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
a) Help troubleshooting data mart design issues
b) Review performance of ETL with developers and suggest improvements
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
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
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.
Skills:
Assets:
Evaluation Criteria:
Design Documentation and Analysis Skills (30 points)
BI Data Modelling and Technical Skills (40 points)
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,
Quality Assurance (20 points)
Knowledge Transfer (10 points)