Design, develop, test, and support enterprise ETL/ELT data integration and pipeline solutions using Talend and relational databases. Build mappings, transformations, reconciliation, and reusable components; optimize SQL; administer Talend tooling; integrate REST APIs via Azure API Management; monitor and troubleshoot production pipelines; support data quality, governance, metadata, lineage, security, and SDLC processes while collaborating with stakeholders and using AI/automation tools for productivity.
This is a remote position.
A public sector organization is seeking an experienced Data Engineer to support a large-scale initiative modernizing environmental and natural resource regulatory processes.
The Data Engineer will design, develop, maintain, and support enterprise data integration, ETL/ELT, and data pipeline solutions using Talend, SQL, Azure, and relational databases.
Requirements
- Design, develop, test, and support enterprise data integration and ETL/ELT solutions using Talend.
- Build data mappings, transformations, reconciliation processes, and reusable integration components.
- Develop and optimize SQL queries, stored procedures, and database processes using SQL Server, Oracle, or PostgreSQL.
- Administer and support Talend Management Console (TMC) and Talend Remote Engine.
- Schedule, monitor, troubleshoot, and resolve production data pipeline and integration issues.
- Develop scalable batch and near-real-time data pipelines.
- Design and integrate REST APIs using Azure API Management.
- Support data quality, governance, metadata, lineage, security, and data privacy requirements.
- Work across development, testing, and production environments following established SDLC practices.
- Collaborate with data engineers, architects, business stakeholders, platform teams, and vendors.
- Leverage AI and automation tools for code generation, testing, data analysis, documentation, and pipeline optimization.
- Post-secondary degree, diploma, or certificate in Computer Science, Engineering, or a related field.
- 3+ years of experience designing, developing, testing, and supporting enterprise data integration solutions.
- 3+ years of experience with Talend Management Console/Talend Administration Center.
- 3+ years of experience installing, configuring, supporting, and troubleshooting Talend Remote Engine.
- 2+ years of production support experience for enterprise integration solutions.
- 4+ years working within a mature Software Development Lifecycle (SDLC).
- 1+ year of experience using AI for code generation, data analysis, automation, or development productivity.
- 6+ years of experience in business/data requirements analysis.
- 6+ years of strong Microsoft SQL Server experience.
- Experience building scalable ETL pipelines, implementing data quality, and working with cloud platforms.
- 3+ years of experience integrating RESTful APIs.
- 3+ years of experience with message queuing technologies.
- Experience with ServiceNow and Azure-based data management integrations.
- Experience with data governance, metadata management, data classification, and data lineage.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Design, develop, deploy, monitor, and support Talend-based enterprise data integration solutions. Build ETL/ELT pipelines, SQL transformations, API integrations, and Talend administration (TMC, Remote Engine). Troubleshoot production data pipelines, perform data reconciliation, implement data governance and security controls, and collaborate with stakeholders to ensure compliant data movement across cloud and legacy systems.
Top Skills:
AzureAzure Api ManagementChatgptEtl/EltGithub CopilotMessage Queueing TechnologiesMicrosoft Sql ServerOraclePostgresRestful ApisServicenowSQLTalend Data FabricTalend Data IntegrationTalend Management Console (Tmc)Talend Remote EngineTalend Studio
Artificial Intelligence • Biotech
Build reusable Python libraries and reproducible analysis pipelines for image and experimental data; define data models and provenance; partner with wet‑lab scientists to translate requirements and validate methods; establish testing, validation, versioning, and observability for scientific workflows.
Top Skills:
AirflowDagsterGitPrefectPython
Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Lead end-to-end personalization data science initiatives: design and deploy machine learning and statistical models into production, optimize recommendations and content layouts, partner with engineering/product/analytics, monitor performance, and mentor junior scientists.
Top Skills:
Data VisualizationMachine LearningPersonalization AlgorithmsProduction Model DeploymentPythonStatistical Modeling
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
