CrawlJobs Logo
Randstad Logo Randstad · IT - Software Development

Senior Software Developer - ETL

Canada, Toronto · Job Posted June 01, 2026
Apply Position
Job Link Share

Job Description

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 (OPGT) Modernization program. In this role, you will be responsible for migrating historical data from legacy systems and streaming data from core ERP/CRM environments into a modern Microsoft Azure data lakehouse. You will design automated data pipelines across multi-layered data structures, configure secure digital file migrations into an enterprise OpenText document management solution, and build analytical business intelligence assets using Power BI.

Job Responsibility

  • Data Lakehouse Engineering: Analyze business requirements to design and construct robust data assets within an Azure data lakehouse framework across multi-layered data stores (Bronze, Silver, and Golden layers)
  • Pipeline Automation & Orchestration: Build, automate, and orchestrate scalable enterprise ETL pipelines within Azure Synapse Workspaces utilizing triggers, data flows, integration runtimes, and performance monitors
  • Dynamics 365 Data Integration: Extract, transform, and ingest structured data from Dynamics 365 Customer Engagement (CE) and Dynamics 365 Finance & Operations (F&O) using Dataverse, Common Data Service (CDS), Data Entities, and native APIs
  • OpenText Document Migration: Define and implement automated ETL workflows to safely extract and migrate high-sensitivity digital files from legacy systems into an enterprise OpenText document management solution
  • Advanced Data Modeling: Design relational, physical, and logical data models that align with the organization's Minimum Viable Product (MVP) analytical and reporting needs
  • Query Performance Optimization: Write complex T-SQL/PL-SQL scripts, profile data streams, and perform deep database tuning to optimize query execution and overall lakehouse processing efficiency
  • Data Security & Governance: Implement strict data masking, column-level security controls, and encryption mechanisms to safeguard sensitive data within Azure SQL databases, Data Lakes, and Power BI dashboards
  • DevOps & CI/CD Deployment: Manage analytics source code within Azure Repos, log project deliverables in Azure DevOps, and construct continuous integration/continuous deployment (CI/CD) release pipelines for Synapse workspaces
  • Executive Visualization & Reporting: Develop precise data dashboards and Power BI reports, verifying data accuracy, profiling integrity, and compliance with public-sector architecture standards

Requirements

  • 5+ years of proven professional experience in a dedicated ETL Developer role, possessing an advanced grasp of ingestion design patterns, data cleansing, enrichment, and normalization
  • High proficiency navigating Azure Synapse Workspaces, Azure SQL Databases, Blob Storage, Key Vaults, and Azure Data Lake Storage (ADLS)
  • Demonstrated hands-on experience extracting and manipulating backend data structures mapped out of Dynamics 365 CE & F&O environments
  • Expert-level mastery of data manipulation languages (T-SQL/PL-SQL) alongside practical programming skills in Python and cloud automation via PowerShell or Azure CLI
  • Extensive experience using SQL Server Management Studio (SSMS), XRM Toolbox, and enterprise data modeling suites
  • Valid Microsoft credentials such as Azure Data Engineer Associate (DP-203), Azure Database Administrator Associate, or Azure Fundamentals are highly desirable

What we offer

  • Enterprise Migration Ownership: Command full technical delivery over a highly visible migration portfolio spanning big data pipelines and specialized enterprise document storage (OpenText)
  • Modern Architecture Stack: Broaden your cloud profile by manipulating raw data into refined, analytics-ready multi-tier data structures (Bronze/Silver/Gold) inside Azure Synapse
  • Long-Term Continuity: Benefit from a stable 10-month contract framework with potential extensions structured through a multi-year VOR master service agreement
  • Stable Schedule: Provide essential technical value under a reliable, standard daytime corporate schedule within an elite public sector-aligned data team based in downtown Toronto
Randstad - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Senior Software Developer - ETL

8 matching positions

Senior ETL Developer

Embark on a transformative journey as a Senior ETL Developer at Barclays, where ...
Location
Location
United States , Whippany
Salary
Salary:
120000.00 - 175000.00 USD / Year
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Designing and building large-scale, highly optimized data warehouses and data marts
  • Python, SQL, Informatica, and shell scripting
  • Writing and optimizing multi-layered SQL queries for performance and scalability
  • Overseeing large-scale batch processing and job scheduling using tools like Autosys
  • Supporting production environments and navigating the change management lifecycle
Job Responsibility
Job Responsibility
  • Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools. Ensuring that code is scalable, maintainable, and optimized for performance
  • Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives
  • Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing
  • Stay informed of industry technology trends and innovations and actively contribute to the organization’s technology communities to foster a culture of technical excellence and growth
  • Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions
  • Implementation of effective unit testing practices to ensure proper code design, readability, and reliability
What we offer
What we offer
  • Competitive holiday allowance
  • Life assurance
  • Private medical care
  • Pension contribution
  • Medical, dental and vision coverage
  • 401(k)
  • life insurance
  • other paid leave for qualifying circumstances
  • incentive award eligibility
  • Fulltime
Read More
Arrow Right

Senior Software Engineer

In your role as a Software Engineer with expertise in backend, you will work wit...
Location
Location
Sweden , Malmö
Salary
Salary:
Not provided
https://www.ikea.com Logo
IKEA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • At least 5 years of experience working with development & API design
  • develop, test, and deploy RESTful and GraphQL APIs using a variety of frameworks
  • implement API authentication and authorization mechanisms (OAuth 2.0, JWT, API keys)
  • optimize backend performance through caching, indexing, and query optimization
  • hands-on experience building modern, responsive web applications using React
  • good understanding of component-based architecture, design systems, and styling approaches
  • good experience with front-end and UI automation testing
  • experience integrating front-end applications with RESTful APIs
  • design and develop serverless and containerized applications
  • leverage event-driven architectures
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable and secure digital and data products in a cloud environment
  • setup development practices working in product teams
  • ensure good code quality
  • build CI/CD pipelines
  • collaborate with the technology team of software and data engineers
  • assist the product manager with technical inputs
  • collaborate with business and IT stakeholders to improve solution architectures.
  • Fulltime
Read More
Arrow Right

Senior Talend Developer

Looking for Sr Talend Developer in Flowood, MS area
Location
Location
United States , Flowood
Salary
Salary:
Not provided
phasorsoft.com Logo
PhasorSoft Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in computer science/Electronics or closely related field
  • 5 yrs as Talend/ETL Developer
  • Willing to travel/relocate to various client sites in USA
Job Responsibility
Job Responsibility
  • Analyze, design, and develop software systems and applications using Big Data technologies
  • Gather and analyze requirements
  • Design and implement system functionalities and validate them
  • Ensure consistent design standards
  • Implement software development life cycle process
  • Develop APIs & GUIs
  • Be responsible for customer deployments and provide customer support
  • Fulltime
Read More
Arrow Right

Senior Software Engineer - Data Integration & JVM Ecosystem

The Connectors team is the bridge between ClickHouse and the entire data ecosyst...
Location
Location
Germany
Salary
Salary:
Not provided
clickhouse.com Logo
ClickHouse
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of software development experience focusing on building and delivering high-quality, data-intensive solutions
  • Proven experience with the internals of at least one of the following technologies: Apache Spark, Apache Flink, Kafka Connect, or Apache Beam
  • Experience developing or extending connectors, sinks, or sources for at least one big data processing framework such as Apache Spark, Flink, Beam, or Kafka Connect
  • Strong understanding of database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases
  • A track record of building scalable data integration systems (beyond simple ETL jobs)
  • Strong proficiency in Java and the JVM ecosystem, including deep knowledge of memory management, garbage collection tuning, and performance profiling
  • Solid experience with concurrent programming in Java, including threads, executors, and reactive or asynchronous patterns
  • Outstanding written and verbal communication skills to collaborate effectively within the team and across engineering functions
  • Understanding of JDBC, network protocols (TCP/IP, HTTP), and techniques for optimizing data throughput over the wire
  • Passion for open-source development
Job Responsibility
Job Responsibility
  • Own and maintain critical parts of ClickHouse's Data engineering ecosystem
  • Own the full lifecycle of data framework integrations - from the core database driver to SDKs and connectors
  • Build the foundation that thousands of Data engineers rely on for their most critical data workloads
  • Collaborate closely with the open-source community, internal teams, and enterprise users to ensure our JVM integrations set the standard for performance, reliability, and developer experience
What we offer
What we offer
  • Flexible work environment - ClickHouse is a globally distributed company and remote-friendly
  • Healthcare - Employer contributions towards your healthcare
  • Equity in the company - Every new team member who joins our company receives stock options
  • Time off - Flexible time off in the US, generous entitlement in other countries
  • A $500 Home office setup if you’re a remote employee
  • Global Gatherings – opportunities to engage with colleagues at company-wide offsites
Read More
Arrow Right

Senior Software Engineer - Data Integration & JVM Ecosystem

The Connectors team is the bridge between ClickHouse and the entire data ecosyst...
Location
Location
United Kingdom
Salary
Salary:
Not provided
clickhouse.com Logo
ClickHouse
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of software development experience focusing on building and delivering high-quality, data-intensive solutions
  • Proven experience with the internals of at least one of the following technologies: Apache Spark, Apache Flink, Kafka Connect, or Apache Beam
  • Experience developing or extending connectors, sinks, or sources for at least one big data processing framework such as Apache Spark, Flink, Beam, or Kafka Connect
  • Strong understanding of database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases
  • A track record of building scalable data integration systems (beyond simple ETL jobs)
  • Strong proficiency in Java and the JVM ecosystem, including deep knowledge of memory management, garbage collection tuning, and performance profiling
  • Solid experience with concurrent programming in Java, including threads, executors, and reactive or asynchronous patterns
  • Outstanding written and verbal communication skills to collaborate effectively within the team and across engineering functions
  • Understanding of JDBC, network protocols (TCP/IP, HTTP), and techniques for optimizing data throughput over the wire
  • Passion for open-source development
Job Responsibility
Job Responsibility
  • Serve as a core contributor, owning and maintaining critical parts of ClickHouse's Data engineering ecosystem
  • Own the full lifecycle of data framework integrations - from the core database driver that handles billions of records per second, to SDKs and connectors that make ClickHouse feel native in JVM-based applications
  • Build the foundation that thousands of Data engineers rely on for their most critical data workloads
  • Collaborate closely with the open-source community, internal teams, and enterprise users to ensure our JVM integrations set the standard for performance, reliability, and developer experience
What we offer
What we offer
  • Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in 20 countries
  • Healthcare - Employer contributions towards your healthcare
  • Equity in the company - Every new team member who joins our company receives stock options
  • Time off - Flexible time off in the US, generous entitlement in other countries
  • A $500 Home office setup if you’re a remote employee
  • Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites
  • Fulltime
Read More
Arrow Right

Senior Software Engineer

We're hiring a Senior Software Engineer to join Data Platform squad. We are look...
Location
Location
France , Paris
Salary
Salary:
55000.00 - 60000.00 EUR / Year
implicity.com Logo
Implicity
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Master's degree in Computer Science, Data Engineering, or equivalent
  • 5+ years of experience in backend development
  • Strong experience in backend development (Java, Node.js)
  • Hands-on experience with data engineering tools (Airflow, dbt, Kafka, Spark, Flink)
  • Solid understanding of SQL and NoSQL databases, including query optimization
  • Familiarity with cloud data services (AWS Redshift, Google BigQuery, Snowflake)
  • Knowledge of containerization and orchestration (Docker, Kubernetes)
  • Experience working with APIs and integrating data from multiple sources
  • Highly aware of secure development practices (Top 10 OWASP)
  • At least one experience in a micro-services architecture
Job Responsibility
Job Responsibility
  • Develop and maintain scalable backend applications with a focus on data-intensive workflows
  • Design, implement, and optimize ETL pipelines for efficient data processing
  • Work with streaming and batch data processing frameworks (Apache Kafka, Spark, Flink)
  • Optimize relational (PostgreSQL, MySQL) databases for performance
  • Ensure data integrity, reliability, and scalability across distributed systems
  • Collaborate with data scientists, analysts, and DevOps teams to integrate data-driven solutions
  • Deploy and manage applications in cloud environments (AWS) using CI/CD pipelines
What we offer
What we offer
  • Health care plan: Alan (50% employer)
  • Luncheon voucher: 9€ (50% employer)
  • Transport: 50% of your pass OR sustainable mobility pass
  • Eligible for stock option (BSPCEs) according to the company's existing rules
  • Regular team events, especially every Thursday evenings
  • Shareholder: you will be incentivized with company equity
  • Fulltime
Read More
Arrow Right

Senior Software Engineer - Data Integration & JVM Ecosystem

The Connectors team is the bridge between ClickHouse and the entire data ecosyst...
Location
Location
Israel
Salary
Salary:
Not provided
clickhouse.com Logo
ClickHouse
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of software development experience focusing on building and delivering high-quality, data-intensive solutions
  • Proven experience with the internals of at least one of the following technologies: Apache Spark, Apache Flink, Kafka Connect, or Apache Beam
  • Experience developing or extending connectors, sinks, or sources for at least one big data processing framework such as Apache Spark, Flink, Beam, or Kafka Connect
  • Strong understanding of database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases
  • A track record of building scalable data integration systems (beyond simple ETL jobs)
  • Strong proficiency in Java and the JVM ecosystem, including deep knowledge of memory management, garbage collection tuning, and performance profiling
  • Solid experience with concurrent programming in Java, including threads, executors, and reactive or asynchronous patterns
  • Outstanding written and verbal communication skills to collaborate effectively within the team and across engineering functions
  • Understanding of JDBC, network protocols (TCP/IP, HTTP), and techniques for optimizing data throughput over the wire
  • Passion for open-source development
Job Responsibility
Job Responsibility
  • Own and maintain critical parts of ClickHouse's Data engineering ecosystem
  • Own the full lifecycle of data framework integrations - from the core database driver that handles billions of records per second, to SDKs and connectors that make ClickHouse feel native in JVM-based applications
  • Build the foundation that thousands of Data engineers rely on for their most critical data workloads
  • Collaborate closely with the open-source community, internal teams, and enterprise users to ensure our JVM integrations set the standard for performance, reliability, and developer experience
What we offer
What we offer
  • Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in 20 countries
  • Healthcare - Employer contributions towards your healthcare
  • Equity in the company - Every new team member who joins our company receives stock options
  • Time off - Flexible time off in the US, generous entitlement in other countries
  • A $500 Home office setup if you’re a remote employee
  • Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites
Read More
Arrow Right

Senior Software Engineer - Data Integration & JVM Ecosystem

The Connectors team is the bridge between ClickHouse and the entire data ecosyst...
Location
Location
United States
Salary
Salary:
125600.00 - 185500.00 USD / Year
clickhouse.com Logo
ClickHouse
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of software development experience focusing on building and delivering high-quality, data-intensive solutions
  • Proven experience with the internals of at least one of the following technologies: Apache Spark, Apache Flink, Kafka Connect, or Apache Beam
  • Experience developing or extending connectors, sinks, or sources for at least one big data processing framework such as Apache Spark, Flink, Beam, or Kafka Connect
  • Strong understanding of database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases
  • A track record of building scalable data integration systems (beyond simple ETL jobs)
  • Strong proficiency in Java and the JVM ecosystem, including deep knowledge of memory management, garbage collection tuning, and performance profiling
  • Solid experience with concurrent programming in Java, including threads, executors, and reactive or asynchronous patterns
  • Outstanding written and verbal communication skills to collaborate effectively within the team and across engineering functions
  • Understanding of JDBC, network protocols (TCP/IP, HTTP), and techniques for optimizing data throughput over the wire
  • Passion for open-source development
Job Responsibility
Job Responsibility
  • Own and maintain critical parts of ClickHouse's Data engineering ecosystem
  • Craft tools that enable Data Engineers to harness ClickHouse's incredible speed and scale
  • Own the full lifecycle of data framework integrations - from the core database driver that handles billions of records per second, to SDKs and connectors that make ClickHouse feel native in JVM-based applications
  • Build the foundation that thousands of Data engineers rely on for their most critical data workloads
  • Collaborate closely with the open-source community, internal teams, and enterprise users to ensure our JVM integrations set the standard for performance, reliability, and developer experience
What we offer
What we offer
  • Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in 20 countries
  • Healthcare - Employer contributions towards your healthcare
  • Equity in the company - Every new team member who joins our company receives stock options
  • Time off - Flexible time off in the US, generous entitlement in other countries
  • A $500 Home office setup if you’re a remote employee
  • Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites
  • Fulltime
Read More
Arrow Right