Solutions Designer - Senior(ETL & Data Integration Architecture)

Full-time

Upstaff

Toronto, ON

Job Description – Solutions Designer (ETL & Data Integration Architecture)

Location: 40 St. Claire Ave W, Toronto

Client: Land & Resources Cluster

Position Overview

We are seeking an experienced Solutions Designer with expertise in solution architecture, data integration, ETL technologies, and legacy system modernization. The successful candidate will lead the analysis, documentation, and design of complex enterprise solutions, with a strong focus on Informatica-based ETL environments, data architecture, and system integrations. This role requires close collaboration with business stakeholders, technical teams, and governance bodies to ensure scalable, secure, and compliant solutions that align with organizational standards and strategic objectives.

Key Responsibilities

Analyze, document, and modernize legacy application and data integration architectures.
Assess existing systems, interfaces, data flows, dependencies, and integration patterns.
Perform detailed analysis of Informatica ETL processes, including mappings, workflows, transformations, data lineage, and performance optimization.
Develop current-state and future-state architecture models, technical designs, system context diagrams, and integration specifications.
Translate business requirements into scalable, maintainable, and secure solution architectures.
Map business processes to supporting applications, databases, data flows, and ETL processes to ensure end-to-end traceability.
Collaborate with business stakeholders, developers, architects, and data teams to define and implement effective solutions.
Conduct impact assessments, dependency analysis, and risk evaluations related to system changes and modernization initiatives.
Ensure compliance with enterprise architecture standards, Information Management principles, security policies, and accessibility requirements.
Participate in architecture reviews, governance processes, and design workshops.
Provide technical leadership and architectural guidance throughout project delivery.
Promote reuse of existing services, integration components, and enterprise data assets.

Requirements

Required Qualifications

10+ years of experience in solution design, solution architecture, or enterprise application design.
Strong hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
Extensive experience in ETL development, data integration, and data architecture.
Strong understanding of data modeling, metadata management, data lineage, and data quality principles.
Experience documenting and analyzing complex legacy systems and integration environments.
Proven ability to develop architecture artifacts, including solution designs, technical specifications, data flow diagrams, and interface documentation.
Knowledge of Information Management principles, governance frameworks, and architecture best practices.
Understanding of accessibility standards (AODA) and their impact on solution design.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent stakeholder management, communication, and facilitation abilities.

Preferred Qualifications

Experience with data warehousing and dimensional modeling.
Knowledge of Azure Data Factory, Informatica IICS/IDMC, and other cloud-based integration platforms.
Experience with API design, microservices, and enterprise integration patterns.
Strong SQL skills with Oracle and SQL Server databases.
Familiarity with DevOps practices and CI/CD pipelines for integration and data solutions.
Experience with data governance, Master Data Management (MDM), and data quality frameworks.
Previous experience working within Ontario Public Service (OPS) or other public-sector environments.

Evaluation Criteria

Criteria	Weight
Solution Architecture & Legacy System Analysis Experience	25
Documentation & Technical Design Skills	25
ETL & Data Integration Expertise	20
Stakeholder Engagement & Communication Skills	15
Public Sector / OPS Experience	15

Key Competencies

Solution Architecture & Legacy System Modernization
ETL & Data Integration Design
Data Architecture & Data Modeling
Technical Documentation & Design Artifacts
Stakeholder Engagement & Communication
Information Management & Governance
Risk Assessment & Impact Analysis
Enterprise Integration & System Interoperability
Architectural Leadership & Technical Guidance

Vacancy posted 1 day ago

Similar jobs that could be interesting for youBased on the Solutions Designer - Senior(ETL & Data Integration Architecture) in Toronto, ON vacancy

Designer - Architectural Solutions
...working out of our impeccably designed and furnished office in... ...We are looking for a DIRTT Designer to join our COI Team. A DIRTT... ...creating better and sustainable solutions. Provide clients with an innovative... ...experience working in an architectural and/or interior firm....
Suggested
Full time
Contract work
For contractors
For subcontractor
Work at office
Monday to friday
Contemporary Office Interiors Ltd.
Toronto, ON
4 days ago
senior solutions designer.
We are seeking a highly accomplished and analytical Senior Solutions Designer for an enterprise-level contract opportunity based in Toronto. In... ...this role, you will take on a leadership capacity within the architecture and integration streams, specializing in the analysis,...
Data
Senior
Contract work
Work at office
Remote work
3 days per week
Randstad
Toronto, ON
1 day ago
Telecom Integration Solution Designer
...Required Skills: · HLD → LLD Design Execution · Integration Design & Delivery · Telecom Domain Application... ...· Application Integration Architecture · System Integration, SI architecture... ...· Interface specifications and data mappings · Ensure clarity for development...
Data
Contract work
Astra North Infoteck Inc.
Toronto, ON
6 days ago
RQ11023 - Solutions Designer - Senior
...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...
Data
Senior
Contract work
Maarut
Toronto, ON
13 hours ago
Dayforce Integration Data Management - Senior Consultant
$80k - $138k per year
...collaborative team, supporting senior consultants and engaging... ...configurations, create functional design documents, and assist in the... ..., Human Resources, Solution Architect, Recruiting, and Talent... ...4+ years of experience in HCM integrations and data management, with at...
Data
Senior
Permanent employment
Flexible hours
Deloitte
Toronto, ON
1 day ago
Senior Salesforce Solution Designer
$94.6k - $176k per year
...Dundas Street West Job Family Group: Technology Senior Salesforce Solution Designer (Hybrid) Position Overview This is a senior... ...Apex, Lightning Web Components (LWC), Flow, and enterprise integration frameworks . As a key design authority, you will bridge...
Data
Senior
Full time
Contract work
Part time
Work at office
Remote work
Toronto, ON
6 days ago
senior solutions designer crm.
Position Summary We are seeking a highly skilled Senior Solutions Designer CRM to lead the design, implementation, and evolution of complex, large... ...) technologies to deliver robust, high-performance web and data solutions that align perfectly with enterprise security, capacity...
Data
Senior
Long term contract
Remplacement
Contract work
Temporary work
Monday to friday
Randstad
Toronto, ON
15 days ago
senior software developer - etl.
We are seeking an expert Senior Software Developer - ETL to lead critical data migration and engineering tracks for the Office of the Public Guardian and Trustee... ...a modern Microsoft Azure data lakehouse. You will design automated data pipelines across multi-layered data structures...
Data
Senior
Long term contract
Contract work
Work at office
Randstad
Toronto, ON
8 days ago
Solutions Designer - CRM - Senior
...Position Overview We are seeking an experienced Senior Solutions Designer – CRM to support the design, implementation, and enhancement... ...with client business requirements, enterprise standards, architectural best practices, accessibility standards, and operational objectives...
Senior
Remplacement
Full time
Contract work
Monday to friday
SereneAid
Toronto, ON
13 days ago
(Remote) Senior Solutions Architect
We are seeking a senior-level Solutions Designer to lead the design and development of advanced Business Intelligence solutions. This role is instrumental... ..., and installation of new BI systems, ensuring seamless integration between existing platforms and new cloud/on-premise...
Data
Senior
Remote work
Randstad
Toronto, ON
more than 2 months ago
Data Architecture and Engineering Leader
...You'll focus on managing the design and implementation of technology... ...business growth. Our Chief Data and Analytics Office provides... ...and infrastructure, enterprise architecture, enterprise applications, large... ...to maintain data accuracy and integrity Design and manage enterprise...
Data
Full time
Live In
Work at office
Pwc Canada
Toronto, ON
7 days ago
Architectural Designer - CA
$90k - $115k per year
...Architectural Contract Administrator Mid to Large Architecture Firm $90-$115k + Flexible WFH + excellent benefits Toronto... ...Administrator, CCCA, Architectural Designer About The Client And Role... ...offices seeks an intermediate to senior contract administrator to join their...
Senior
Contract work
Work from home
Flexible hours
Night shift
1 day per week
TalentSphere Staffing Solutions
Toronto, ON
3 days ago
Conseiller en architecture de solution
...TEHORA est présentement à la recherche d’ un(e) conseiller en architecture de solution ayant une solide expérience dans son domaine d’expertise... ...besoins métiers et techniques pour concevoir des solutions intégrées ; Définir les architectures logicielles et les composantes...
Hourly pay
Contract work
Apprenticeship
Remote work
Flexible hours
TEHORA
Toronto, ON
9 days ago
PRODUCT DESIGN SENIOR SPECIALIST
...Senior Product Designer Location: Office-based/Hybrid - Toronto, Canada Focus: Team enablement... ...clarity, coherence, and craft. An integral part of this work lies with the Digital... ...Fluency in Figma — including component architecture, auto layout, variables, and...
Data
Senior
Daily paid
Work at office
Local area
Worldwide
Bentley Systems
Toronto, ON
1 day ago
Senior Industrial Engineer (Solution Design)
$120k - $135k per year
...General Information Job Title: Senior Industrial Engineer (Solution Design) Location: Toronto, ON (Onsite/Hybrid) Job Type: Full-Time Reporting Line: Director of Product Strategy Travel Expectations: 0-10% Salary Range: Base Compensation: ~$120k–$135k CAD...
Senior
Long term contract
Full time
Internship
Local area
Remote work
Flexible hours
Fulfillment IQ
Toronto, ON
7 days ago
(Senior) IT Solution Architect H/F
We are seeking a strategic and highly analytical Solutions Designer to lead the architecture and design of complex hosting technology solutions. This role... ...creating business architecture artifacts. - Knowledge of integrated networking technologies, midrange servers, and...
Senior
Randstad
Toronto, ON
a month ago
senior solutions designer - crm.
...experience with developing business design document, functional & non-... ...of experience designing solutions with Oracle Siebel CRM? If so... ...Our client is looking for a Senior Solutions Designer - CRM for... ...standards, standard facilities architecture management, facility service...
Senior
Long term contract
Remplacement
Contract work
Temporary work
Randstad
Toronto, ON
a month ago
Interior Design and Architectural Technologist
...Job Responsibility: The opportunity We're looking for gifted Interior Designers and Architectural Technologists with a passion for creating and implementing retail design solutions and services. Whether you're established in the field or looking to make your mark on our industry...
Full time
Internship
Work at office
1 day per week
G. L. Smith Planning & Design Inc.
Toronto, ON
1 day ago
Senior Data Management Specialist
$95k - $145k per year
Senior Data Analyst Position Description CGI is a global business and technology service... ...management, investment fund and asset management solutions. This role is hybrid and requires you... ...them into data-driven insights. 5. Design and implement data models, ensuring data...
Data
Senior
Work at office
Worldwide
3 days per week
Toronto, ON
6 days ago
Journey Design & Experience Architecture Manager
...world-class networks, AI-powered solutions, and digital experiences that... ...needs strong journey design practitioners to reduce ambiguity... ...decisions Contribute to experience architecture (journeys, service blueprints,... ...intake and early shaping with data-driven insights to guide...
Data
Full time
Work at office
3 days per week
Bell
Toronto, ON
7 days ago
Senior Tech and Data Strategy Manager
$128k - $178k per year
...Technology Group (CTTG) is seeking an experienced Senior Manager to help define and scale our data-driven strategy, offerings, and solutions. This is a leadership role and plays a... ...leader who can define data strategy and architecture, experiment with new approaches, and guide...
Data
Senior
Long term contract
Manual labor
Weekend work
Ernst & Young
Toronto, ON
26 days ago
senior solutions designer - crm.
...have at least 10 years of experience in design, development, implementation and... ...for you! Our client is looking for a Senior Solutions Designer - CRM for a 9 month contract in... ...At least 10 years of experience in J2EE integration with other systems such as Oracle Siebel...
Senior
Contract work
Randstad
Toronto, ON
more than 2 months ago
Conseiller(ère) senior en architecture d entreprise et d intégration
...TEHORA est présentement à la recherche d’ un(e) conseiller(ère) senior en architecture d’entreprise et d’intégration ayant une solide expérience en transformation numérique, en alignement stratégique des systèmes et en architecture de référence. La personne retenue interviendra...
Senior
Hourly pay
Full time
Contract work
Apprenticeship
Remote work
Flexible hours
Day shift
TEHORA
Toronto, ON
a month ago
ETL DataStage Developer
...Skills: Hands on experience in using Data Stage 8.5 and higher versions of the tool... ...in using Datastage 11.x Experience in solution architecture. Roles & Responsibilities: Understand business requirements and create design documentation. Get Design documentation reviewed...
Data
Hourly pay
Permanent employment
Full time
Internship
Monday to friday
Q1 Technologies
Toronto, ON
12 days ago
Senior Sensor Fusion & Data Architecture Lead - LIFT Program
$100.2k - $131.7k per year
...Job Description Overview Our team is hiring a Senior Sensor Fusion & Data Architecture Lead to join our growing team to work on one of the most important... ...systems, and IT platforms is intentionally designed, fit for purpose, and aligned to the airport's event driven...
Data
Senior
Long term contract
Full time
Internship
Work at office
Local area
Monday to friday
Flexible hours
AtkinsRéalis
Toronto, ON
22 days ago
Senior Solutions Architect - Full Time
$75 - $80 per hour
...Senior Data Architect Be part of large-scale technology and transformation initiatives within the insurance sector, working with modern cloud platforms, enterprise integrations, and advanced analytics solutions. This hybrid opportunity offers exposure to Azure, DataBricks...
Data
Senior
Hourly pay
Full time
Contract work
Work at office
3 days per week
Recrute Action
Toronto, ON
3 days ago
Senior Manager, Business Architecture
$94.6k - $176k per year
...Technology Role Summary The Senior Manager, Business Architecture owns the evolution of business architecture... ...new opportunities (e.g., cloud and data platform evolution). 2) Delivery... ...architecture translates into executable solutions and implemented use cases Support...
Data
Senior
Full time
Contract work
Part time
Toronto, ON
2 days ago
Senior Data Engineer
...Description WHAT IS THE OPPORTUNITY? The Senior Data Engineer bridges analytical expertise and... ...group. This role leads end-to-end data solutions—from requirements gathering through... ..., and validation against requirements Design and develop conceptual, logical, and physical...
Data
Senior
Full time
Flexible hours
Royal Bank of Canada
Toronto, ON
24 days ago
IT Senior Solution’s Architect - CRM Configuration & Deployment
$116 - $139.14 per hour
...RQ11061 - Sr. Solutions Designer - CRM 1-year contract (250 business days) - possible extension... ...Services ~ Experience completing Architecture and Technical documentation ~ Azure... ...and customize a Salesforce solution and integrating Salesforce with other applications...
Data
Senior
Contract work
Source Code
Toronto, ON
9 days ago
Senior Manager Data Engineering
$94.6k - $176k per year
..., Toronto About the team Data and AI Technology (DAT) Engineering... ...Lead in the planning, design, development, testing, implementation... ...as a specialist resource to senior leaders and stakeholders. What... ...with extract, transform, load (ETL) for various sources and downstream...
Data
Senior
Full time
Contract work
Part time
Work at office
2 days per week
Toronto, ON
1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Solutions Designer - Senior(ETL & Data Integration Architecture). Be the first to apply!