RQ11023 Solutions Designer Senior

Major Responsibilities:

• Leads the analysis documentation and modernization of legacy system architectures with a strong focus on understanding and mapping existing data flows integrations and dependencies particularly Informatica ETL processes.
  
• Develops comprehensive architectural documentation (current-state and future-state) including system context diagrams data architectures integration patterns and technical specifications.
  
• Provides expert-level analysis of ETL processes (especially Informatica) identifying data lineage transformation logic dependencies and opportunities for optimization simplification or modernization.
  
• Collaborates closely with business stakeholders developers and data teams to translate business requirements into scalable maintainable and compliant solution designs.
  
• Ensures solutions align with OPS architecture principles Information Management standards security policies and regulatory requirements.
  
• Facilitates design reviews and architectural governance processes to ensure consistency quality and adherence to standards.
  
• Communicates complex technical concepts clearly and effectively to both technical and non-technical stakeholders.
  
• Supports project delivery by guiding development teams resolving design issues and ensuring architectural integrity throughout implementation.
  
• Identifies risks constraints and impacts related to legacy systems and ETL processes and proposes mitigation strategies.
  
• Maps business processes to supporting systems data flows and ETL processes ensuring traceability and alignment between business and technical layers.
  
• Collaborates with business stakeholders to understand operational workflows and translate them into architectural representations.
  
• Promotes reuse of existing components services and data assets to improve efficiency and reduce duplication.
  
• 
  

Requirements

Mandatory Skills:

• Strong knowledge and hands-on experience with ETL tools particularly Informatica PowerCenter and/or Informatica Cloud (IDMC) including mapping workflows transformations and performance tuning.
  
• Expertise in data architecture data integration and data modeling including understanding of 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 (e.g. high-level designs detailed designs data flow diagrams 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.
  

General Skills:

• Leads architecture planning and strategy aligned with business and ministry objectives.
  
• Analyzes business requirements and translates them into end-to-end technical solutions and data integration designs.
  
• Develops and maintains architecture documentation including system diagrams data flow diagrams and interface mappings.
  
• Provides guidance and oversight to development teams to ensure adherence to architectural standards and best practices.
  
• Coordinates across multiple teams (business data infrastructure application) to ensure cohesive solution delivery.
  
• Identifies assesses and mitigates technical risks and technical debt especially within legacy systems.
  
• Supports impact analysis for changes releases and enhancements across integrated systems.
  
• Ensures solutions are scalable maintainable secure and cost-effective.
  
• Promotes best practices in data integration ETL design and system interoperability.
  
• Ability to bridge business and technical architecture ensuring end-to-end traceability from business requirements through to implementation.
  
• Experience producing integrated architecture documentation that connects business architecture data architecture and solution architecture.
  
• Participates in governance forums architecture review boards and stakeholder meetings.
  
• Provides clear and concise reporting on architecture status risks and recommendations to senior stakeholders.
  
• Supports knowledge transfer and documentation to ensure sustainability of solutions.
  

Desirable Skills:

• Experience with data warehousing concepts and dimensional modeling.
  
• Knowledge of modern data integration tools and cloud-based ETL platforms (e.g. Azure Data Factory Informatica IICS).
  
• Experience with API design microservices architecture and integration patterns.
  
• Familiarity with database technologies (e.g. 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 including familiarity with governance processes.
  
• Exposure to data governance data quality frameworks and master data management (MDM).
  

Evaluation Criteria

Must Haves: (10 year of experience)

• Strong knowledge and hands-on experience with ETL tools particularly Informatica PowerCenter and/or Informatica Cloud (IDMC) including mapping workflows transformations and performance tuning.
  
• Expertise in data architecture data integration and data modeling including an understanding of 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 (e.g. high-level designs detailed designs data flow diagrams 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.