Data & Integration Architect

Socket.dev; Mississauga; On-site; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Hybrid work culture

Training & development

Generous time-off

Job summary

AtkinsRéalis in Canada is seeking a Data & Integration Developer to design and support enterprise integrations, data pipelines and the organization’s data platform. You will collaborate with business and technology stakeholders to connect applications, improve data quality and enable reporting, analytics, automation and AI initiatives.

The role requires 5+ years of experience with system integrations and data platforms, with expertise in Azure Logic Apps, DataBridge Pro and related technologies.

Qualifications

• 5+ years of experience developing and supporting system integrations, data pipelines, enterprise applications or data platforms.
• Experience designing, implementing and supporting production integrations using an enterprise integration platform such as Microsoft Azure Logic Apps, DataBridge Pro, Apache NiFi, or a comparable technology.
• Strong experience with REST APIs, JSON, XML, SQL and secure file-based integrations.
• Experience with Microsoft Azure data services, Microsoft Fabric, Azure Data Factory, SQL Server, Power BI or comparable technologies is preferred.
• Knowledge of authentication, authorization, service accounts, certificates and secure system-to-system connectivity.
• Excellent written and oral communication skills.

Responsibilities

• Design, configure, test, deploy and support integrations between enterprise applications, databases and data sources using platforms such as DataBridge Pro and Microsoft Azure Logic Apps.
• Develop and maintain integration workflows using APIs, database connections, messaging, secure file transfer and other appropriate integration patterns.
• Build data transformation, validation, routing, reconciliation and error-handling processes to support reliable information exchange between systems.
• Assist in establishing and evolving an enterprise data warehouse and data platform that consolidates information from business, engineering and operational systems.
• Develop and maintain ETL/ELT pipelines, curated datasets and data models for reporting, analytics, automation and AI use cases.
• Work with business stakeholders, application owners and technical teams to define interface, data and reporting requirements.
• Analyze source-system data structures, business rules and data quality issues, and recommend practical solutions.
• Apply appropriate security, access, governance, data quality, lineage and retention requirements to integration and data solutions.
• Monitor production integrations and data pipelines, investigate failures, resolve defects and support ongoing operational reliability.
• Prepare and maintain solution documentation, including interface specifications, data mappings, architecture diagrams, operating procedures and support runbooks.
• Participate in solution testing, deployment planning, change management and the transition of new capabilities into operation.
• Contribute to reusable integration patterns, technical standards and continuous improvement of the organization’s data and integration practices.
• Other duties and responsibilities as assigned.

Skills

Analytical skills

Troubleshooting

Interpersonal skills

Communication skills

Education

Degree in CS/IT or related field

Equivalent practical experience

Tools

REST APIs

JSON

XML

SQL

Microsoft Azure Logic Apps

DataBridge Pro

Apache NiFi

Power BI

Job description

AtkinsRéalis in Canada is seeking a Data & Integration Developer to design and support enterprise integrations, data pipelines and the organization’s data platform. You will collaborate with business and technology stakeholders to connect applications, improve data quality and enable reporting, analytics, automation and AI initiatives.

The role requires 5+ years of experience with system integrations and data platforms, with expertise in Azure Logic Apps, DataBridge Pro and related technologies.