Data Architect
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Our client, the Ontario Ministry of Land & Resources has a 12 month renewable hybrid remote contract for a Data Architect.
- Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data and designing target data models .
- Strong experience in research, data analysis and development of effective IT data model designs.
- Work with related IT initiatives as required to align with the enterprise data modeling standards and requirements.
- Expert analytical skills and experience to analyze and understand source data models and data including developing data mappings for source and target systems.
- Excellent RDBMS knowledge including SQL skills for carrying out deep analysis and/or to confirm/validate data.
- Able to work and effectively engage with a multi-functional (e.g. Business Analysts, SME, Developers, Architects etc.) team to ensure IT deliverables produced are of high quality.
- Able to understand the problem domain and target IT/business requirements and communicate data modeling outputs as required.
- Quick learner with ability to adapt and work independently with little or no supervision.
- Able to carry out research from a variety of sources to ensure alignment with current IT trends and best practices.
- Expert skills and experience with the use of data modeling tools.
- Ability to engage and provide information sharing support to IT architects (Business, Information, Solution, and Technology) as may be required.
- Ensures integration with related corporate and client cluster policies and standards, and incorporation of best practices in the industry.
- Knowledge and experience in creating, developing and managing logical and physical data models.
Desirable Skills and Experience:
- Experience with similar MECP applications covering environmental (inspections, compliance, enforcement) systems, and hazardous waste management systems
- Experience with Computer Aided Software Engineering (CASE) tools
- Experience with use of Python in aiding data processing activities.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
- Knowledge of Parquet, Delta-Lake data formats.
- Knowledge of Azure Data Lakehouses, Star schema, Snowflake.
More about this job
Responsibilities
Analyze business requirements and existing application data, then design target data models and source-to-target mappings that align with enterprise standards. Collaborate with multidisciplinary teams and IT architects to validate data, support related initiatives, and ensure high-quality deliverables that follow corporate policies and industry best practices.
Requirements
The role requires strong experience in data analysis, data modeling, SQL and RDBMS, data mapping, and the use of data modeling tools, along with the ability to work independently and communicate effectively with technical and business stakeholders. Desirable experience includes environmental or hazardous-waste systems, CASE tools, Python, information management, Parquet, Delta Lake, Azure Data Lakehouses, star schemas, and Snowflake.
Skills
- Data Modeling
- Logical And Physical Data Models
- Data Analysis
- Data Mapping
- SQL
- RDBMS
- Data Modeling Tools
- Python
- Information Management
- Azure Data Lakehouses
- Parquet
- Delta Lake
- Star Schema
- Snowflake
- Stakeholder Collaboration
- Enterprise Data Standards
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Government & Public Sector
- Environmental & Sustainability
Keywords
- Data Architecture
- Data Modeling
- Logical Data Models
- Physical Data Models
- Data Analysis
- Data Mapping
- Source And Target Systems
- SQL
- RDBMS
- Data Modeling Tools
- Enterprise Data Modeling Standards
- Python
- Information Management
- Environmental Systems
- Inspections
- Compliance
- Enforcement
- Hazardous Waste Management
- CASE Tools
- Parquet
- Delta Lake
- Azure Data Lakehouses
- Star Schema
- Snowflake
- Data Validation
- Business Requirements
- Industry Best Practices