Job Description
Key Responsibilities
- Design and implement enterprise-grade data architecture in a complex, distributed application environment.
- Define data flow, distribution models, database locations, and access methods.
- Develop technology-agnostic Conceptual and Logical Data Models (CDM/LDM) and support prototype development.
- Contribute to data migration strategies and planning activities.
- Support Alpha prototyping and Proofs-of-Concept (POCs) based on CDM recommendations.
- Assist in preparing enterprise architecture artefacts for submission to the Architecture Review Board (AGP0 Summer 2025, AGP1 Fall/Winter 2025).
- Collaborate with stakeholders to develop a standard business vocabulary and align data architecture with enterprise strategies.
- Monitor and enforce data modeling standards and quality across conceptual, logical, and physical data models.
Must-Have Skills (50%)
- 10+ years of experience in data architecture and data modeling in large/complex environments
- Proficiency with modeling tools (e.g., ERWIN, Visio, PowerDesigner)
- Experience with structured methodologies for application design, development, and implementation
- Experience with multiple database technologies, platforms, operating systems, and communication protocols
- Knowledge of metadata structures, data dictionaries, and repository functions
- Demonstrated experience in CASE tools and data modeling standards enforcement
- Familiarity with performance considerations across various database designs and environments
- Strong systems analysis, documentation, and data normalization skills
- Proven ability to deliver high-quality enterprise architecture deliverables
- Strong analytical thinking, problem-solving, decision-making, communication, and collaboration skills
Desirable Skills (30%)
- Experience designing automated data distribution mechanisms and middleware/gateway solutions
- Knowledge of object-oriented analysis and design techniques
- Experience integrating dimensional and relational data models across systems
- Familiarity with information management principles, policies, and best practices
- Experience creating reusable data standards and reviewing data models for quality/adherence
- Awareness of emerging IT trends and technologies relevant to data modeling and architecture
Communication & Soft Skills (15%)
- Excellent communication (verbal/written) and presentation skills
- Ability to present technical findings, options, and recommendations to both technical and non-technical audiences
- Collaborative team player with a strong record of client engagement and relationship management
- Self-starter with a proactive mindset and attention to detail
- Demonstrated ability to manage multiple tasks under tight deadlines
- Experience in project triage/rescue situations is a strong asset
Public Sector Experience (5%)
- Previous work in government or broader public sector environments
- Experience with the Ontario Design System and knowledge of Ontario Government Enterprise Architecture frameworks
- Ability to develop EA deliverables in alignment with Ontarios architecture review processes
#J-18808-Ljbffr
Job Tags
Summer work,