---

---

Location

North York, ON | Canada

---

Job description

This is a contract position for a Data Architect / Modeller for our public sector client.
Work location: North York
Duration: Twelve Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages
Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities
As part of the modernization of Social Assistance analytics platform, review existing data model and redesign to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting . Support data migration plan to redesign current on-premise or hybrid processes from a SqlServer environment to cloud-based delta lake built on Azure Data Lake service, using Azure Databricks.

- 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

Qualifications
- 7+ years in data modelling and data warehouse design
- 2+ years Azure Data Lake and Azure Databricks SQL Warehouse
- 5+ years SQL

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

Summary
If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process. show more

---

Job tags

---

---

Salary