Solutions Designer Senior

Job Title: Solutions Designer - Senior
Location: Toronto Ontario
Work Model: Hybrid

Description / Responsibilities / Skills

Must Have

• 10 years of experience
• Strong hands-on experience with ETL tools particularly Informatica PowerCenter and/or Informatica Cloud (IDMC) including mappings workflows transformations and performance tuning
• Expertise in data architecture data integration and data modeling including data lineage metadata management and data quality
• Experience documenting and analyzing legacy systems and complex integration environments
• Knowledge of Information Management principles concepts policies and practices
• Experience developing technical and solution architecture artifacts such as high-level designs detailed designs data flow diagrams and interface specifications
• Understanding of OPS I&IT standards architecture frameworks and governance processes
• Knowledge of AODA and accessibility standards and their impact on solution design
• Ability to assess and recommend technology solutions tools and integration approaches
• Strong analytical and problem-solving skills to decompose complex systems and troubleshoot data and integration issues
• Ability to identify dependencies and impacts across systems and recommend effective design solutions
• Strong stakeholder engagement skills including the ability to explain architecture decisions and manage expectations

Description

Responsibilities

• Lead analysis documentation and modernization of legacy system architectures
• Map current-state and future-state data flows integrations and system dependencies
• Analyze ETL processes to identify lineage transformation logic dependencies and modernization opportunities
• Translate business requirements into scalable maintainable and compliant solution designs
• Ensure alignment with OPS architecture principles security policies regulatory requirements and information management standards
• Facilitate design reviews and support architectural governance activities
• Support delivery teams by resolving design issues and maintaining architectural integrity during implementation
• Identify risks constraints and impacts related to legacy systems and integration processes
• Map business processes to systems data flows and technical components to ensure traceability
• Promote reuse of existing services components and data assets to improve efficiency

General Skills

• Leads architecture planning and strategy aligned with ministry and business objectives
• Translates business requirements into end-to-end technical and integration designs
• Develops and maintains system diagrams interface mappings and architecture documentation
• Provides architectural guidance to development teams to ensure adherence to standards and best practices
• Coordinates across business data infrastructure and application teams for cohesive delivery
• Identifies and mitigates technical risks and technical debt especially in legacy environments
• Supports impact analysis for releases changes and enhancements across integrated systems
• Ensures solutions are scalable maintainable secure and cost-effective
• Bridges business and technical architecture to ensure end-to-end traceability
• Participates in governance forums and provides architecture status risks and recommendations to stakeholders
• Supports knowledge transfer and documentation handoff for solution sustainability

Desirable Skills

• Experience with data warehousing concepts and dimensional modeling
• Knowledge of modern data integration tools and cloud ETL platforms such as Azure Data Factory and Informatica IICS
• Experience with API design microservices architecture and integration patterns
• Familiarity with Oracle SQL Server and advanced SQL
• Knowledge of DevOps practices and CI/CD pipelines for data and integration solutions
• Experience working in public sector or OPS environments
• Exposure to data governance data quality frameworks and master data management (MDM)

Skills

Experience and Skill Set Requirements

Solution Architecture and Legacy System Analysis Experience - 25%

• Experience modernizing legacy solution environments
• Ability to analyze architectural dependencies across systems and integrations
• Experience mapping business processes to technical solution components
• Experience identifying technical risks constraints and modernization opportunities

Documentation and Technical Design Skills - 25%

• Experience producing current-state and future-state architecture documentation
• Strong experience with technical design specifications system context diagrams interface mappings and architecture diagrams
• Experience producing integrated architecture documentation connecting business data and solution architecture
• Ability to document architecture clearly for both technical and non-technical stakeholders

ETL and Data Integration Expertise - 20%

• Experience analyzing and designing ETL and data integration processes
• Strong knowledge of transformation logic data lineage metadata and data quality
• Experience supporting optimization and simplification of integration processes
• Experience promoting interoperability and best practices in integration design

Stakeholder Engagement and Communication Skills - 15%

• Strong stakeholder collaboration and expectation management
• Ability to explain technical concepts and architecture decisions clearly
• Strong communication and facilitation skills across business and technical audiences
• Ability to support design reviews governance discussions and working sessions

Public Sector / OPS Experience - 15%

• Experience working with OPS or public sector governance processes and standards
• Knowledge of OPS architecture principles and review processes
• Awareness of public sector compliance accessibility and policy requirements