Senior Data Architect / Data Modeller

• Develop and implement data architecture solutions for application development in complex and distributed IT environments.
  
• Determine data flows, data distribution, database locations, and appropriate data access methods.
  
• Review and analyze business needs, requirements, existing IT applications, and associated data structures to design effective target data models.
  
• Review and analyze source data models and databases for existing MECP applications.
  
• Analyze, design, and develop logical data model specifications for target systems.
  
• Create, develop, maintain, and manage logical and physical data models in accordance with established standards and requirements.
  
• Conduct detailed research and data analysis to assess existing data structures, identify gaps, and develop effective IT data model designs.
  
• Develop source-to-target data mappings and validate data transformation requirements to ensure data consistency, accuracy, and completeness.
  
• Apply strong SQL and RDBMS expertise to perform in-depth data analysis, investigate data structures, and confirm or validate data.
  
• Collaborate with business stakeholders to ensure target data models adequately address business requirements and data needs.
  
• Work with development teams to support the preparation and development of technical artefacts and implementation deliverables.
  
• Coordinate with Business Analysts, SMEs, Developers, Business Architects, Information Architects, Solution Architects, and Technology Architects to ensure the quality and alignment of IT deliverables.
  
• Support related IT initiatives to ensure alignment with enterprise data modelling standards, architecture requirements, and applicable client policies.
  
• Apply industry best practices and relevant IT trends to data architecture and modelling activities.
  
• Conduct independent research using multiple sources to identify appropriate data modelling approaches, technologies, and practices.
  
• Communicate data modelling specifications, design decisions, data mappings, and analysis findings clearly to technical and business stakeholders.
  
• Provide information-sharing and technical support to IT architects, including Business, Information, Solution, and Technology Architects, as required.
  
• Work independently with minimal supervision, adapt quickly to changing requirements, and manage assigned deliverables effectively.
  

1. Business Requirements Analysis and Target Data Modelling: Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data, and designing target data models.
   
2. Data Analysis and Data Model Design: Strong experience in research, data analysis, and developing effective IT data model designs.
   
3. Source Data Model Analysis: Proven ability to analyze and understand source data models, existing databases, and underlying data structures.
   
4. Data Mapping and Validation: Expert analytical skills and experience developing source-to-target data mappings and validating data across source and target systems.
   
5. RDBMS and SQL: Excellent knowledge of relational database management systems and strong SQL skills for deep data analysis, querying, and data validation.
   
6. Logical and Physical Data Modelling: Demonstrated knowledge and experience creating, developing, and managing logical and physical data models.
   
7. Data Modelling Tools: Expert skills and practical experience using data modelling tools to develop, document, and maintain data models.
   
8. Enterprise Data Standards: Experience supporting related IT initiatives and aligning data models with enterprise data modelling standards and requirements.
   
9. Business and Technical Collaboration: Ability to work effectively with multidisciplinary teams, including Business Analysts, SMEs, Developers, and Architects, to ensure high-quality IT deliverables.
   
10. Business and Technical Communication: Ability to understand the problem domain, interpret target IT and business requirements, and communicate data modelling outputs effectively.
    
11. Independent Research and Problem-Solving: Strong research and analytical capabilities, with the ability to investigate multiple sources and apply current IT trends and industry best practices.
    
12. Independent Delivery: Ability to learn quickly, adapt to evolving requirements, and work independently with little or no supervision.
    
13. Architecture and Governance Alignment: Ability to support IT architects and ensure integration with corporate and client cluster policies, standards, and industry best practices.
    

Requirements

• Experience with applications similar to MECP systems, particularly environmental inspections, compliance, enforcement, and hazardous waste management systems.
  
• Experience using Computer-Aided Software Engineering (CASE) tools.
  
• Experience using Python to support data processing, data analysis, and related activities.
  
• Knowledge and understanding of Information Management principles, concepts, policies, and practices.
  
• Knowledge of Parquet and Delta Lake data formats.
  
• Experience with Azure Data Lakehouse architectures.
  
• Knowledge of dimensional modelling concepts, including star schema design.
  
• Knowledge of Snowflake data platforms and associated data modelling practices.
  

• The selected candidate must be available to work in a hybrid arrangement, attending the designated Toronto office three days per weekand working remotely two days per week.
  
• The resource must be available to work full-time at 100% allocation.
  
• The candidate must be capable of working independently and collaborating effectively with multidisciplinary business and technical teams.
  
• No security clearance is required.