Database Architect (Future Opportunity)

Job summary

Lead the assessment and modernization of the enterprise data ecosystem by analyzing and documenting data infrastructure. The role involves mapping data flows, evaluating APIs, and developing strategies for data cleansing and migration to modern cloud infrastructures.

Job details

Department: Public Service Alliance of Canada (PSAC) Location: Canada Description Job Title: Data Architect Location: Ottawa, ON (Remote) Contract Start Date: End of April 2026 Position Overview The Public Service Alliance of Canada (PSAC) is seeking an experienced Data Architect to lead the assessment and modernization of its enterprise data ecosystem. The successful candidate will be responsible for analyzing, documenting, and improving PSAC’s data infrastructure to support reliable, secure, and efficient information management across the organization. Key Responsibilities Key Responsibilities Conduct a comprehensive inventory of systems that store or process critical organizational data. Map data flows and integration patterns between existing systems, identifying opportunities for optimization and standardization. Assess data accuracy, completeness, and integrity, providing recommendations for improvement. Evaluate the current APIs, middleware, and scheduled integrations in use across platforms. Develop and recommend a data cleansing and reconciliation strategy to ensure consistency and quality. Identify and document technical and business dependencies impacting data management and integration. Assess legacy VM-based systems for readiness and suitability for migration to modern SaaS and PaaS infrastructures. Collaborate with IT leadership and business stakeholders to align data architecture initiatives with strategic objectives.

What you’ll do

Lead the assessment and modernization of the enterprise data ecosystem by analyzing and documenting data infrastructure. The role involves mapping data flows, evaluating APIs, and developing strategies for data cleansing and migration to modern cloud infrastructures.

Requirements

The candidate must be an experienced Data Architect capable of managing technical and business dependencies. They should have expertise in assessing legacy systems for migration to SaaS and PaaS environments.

Listed skills

• Flows · Preferred
• Technical · Preferred
• assessment · Preferred
• Leadership · Preferred
• management · Preferred
• Process · Preferred
• Integrations · Preferred
• Accuracy · Preferred
• future · Preferred
• Integration · Preferred
• data management · Preferred
• Mapping · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Architecture
• Enterprise Data Ecosystem
• Data Mapping
• API Evaluation
• Middleware
• Data Cleansing
• SaaS Migration
• PaaS Migration
• Information Management
• Data Integration

Job areas

• Data & Analytics
• Technology
• Consulting
• Government & Public Sector
• Software