CrawlJobs Logo

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

Nice to have

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: Operate under a reliable, standard daytime corporate schedule within an elite public sector-aligned data team based in downtown Toronto

Looking for more opportunities?

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

Similar Jobs for

Senior Software Developer - ETL

8 matching positions

Senior Software Developer - ETL

We are seeking a highly accomplished Senior Software Developer - ETL to lead the...
Location
Location
Canada , North York
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
August 17, 2026
Flip Icon
Requirements
Requirements
  • 10+ years of progressive professional experience translating complex system specifications into tested, working applications for large-scale, mission-critical environments
  • 10+ years of verified hands-on experience designing and implementing Medallion Data Lakehouse architectures, utilizing tools such as Databricks (PySpark, SQL, Delta Live Tables), Delta Lake, and dbt
  • Demonstrated success constructing and automating enterprise ETL/ELT data pipelines using Azure Data Factory (ADF) and configuring job schedules
  • Mastery of relational database management systems (SQL Server, Synapse, PostgreSQL) and dimensional modeling alongside advanced SQL query optimization and replication tuning
  • Practical development experience manipulating Apache Spark distributed environments and working with storage formats including Parquet, ORC, and JSON
  • High proficiency navigating cloud ecosystems, specifically Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Event Hubs, and Azure Functions
  • Direct, practical experience implementing enterprise data access controls, cloud security models, data lineage tracking, and Unity Catalog data governance
  • Strong experience integrating front-end systems like Power BI (DAX, performance tuning) with cloud warehouses and data pipelines
  • Proven background applying continuous integration and automated deployment protocols via Azure DevOps or GitHub Actions
  • 5+ years of explicit experience running gap analyses, assessing technical options for architecture issues, and delivering robust system integration designs
Job Responsibility
Job Responsibility
  • Design, implement, and maintain highly scalable Medallion Data Lakehouse architectures (Bronze, Silver, and Gold tiers) to capture, store, and process massive enterprise datasets
  • Build, automate, and tune complex ETL/ELT pipelines using data integration factories, orchestration workflows, and transformation tools to handle both structured and unstructured data streams
  • Develop data-driven logic and streaming frameworks utilizing distributed clusters, optimizing query execution, data indexing, partitioning schemes, and storage file formats
  • Design logical and physical dimensional data models, integrating disparate data sources into optimized star and snowflake schemas ready for downstream analytics
  • Investigate and resolve data loading exceptions, performing deep root-cause analysis to distinguish between software failures and source-data quality anomalies
  • Build and connect high-performance data models with cloud data warehouses, implementing advanced calculations and performance tuning to support seamless user reporting
  • Operationalize advanced cataloging engines and data governance frameworks, managing fine-grained data permissions, data lineage tracking, and role-based access controls (RBAC)
  • Implement automated deployment packages and release routines using continuous integration pipelines to manage the lifecycle of data platform infrastructure
  • Conduct detailed technical design evaluations, option analyses, and gap assessments for complex integration components to resolve architectural blockers
  • Produce and maintain comprehensive technical specifications, logical system models, metadata dictionaries, and operational deployment guides to support long-term environment maintenance
  • Fulltime
Read More
Arrow Right

Senior Software Developer - ETL

We are seeking an expert Senior Software Developer - ETL to lead critical data m...
Location
Location
Canada , Toronto
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
July 25, 2026
Flip Icon
Requirements
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
Job Responsibility
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
What we offer
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
  • Fulltime
!
Read More
Arrow Right

Software Developer - Senior / Senior Data Engineer

Imagine being at the forefront of protecting financial integrity and enabling cr...
Location
Location
United States , Southlake, TX or Austin, TX
Salary
Salary:
55.92 - 62.13 USD / Hour
aquent.com Logo
Aquent
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field
  • 8+ years of hands-on experience in data management, including gathering data from diverse sources, consolidating it into centralized locations, and transforming it with business logic for consumption in visualization and data analysis
  • Strong expertise in BigQuery, Cloud Storage, Dataflow, Pub/Sub, Cloud Composer, and related cloud platform services
  • Proficiency in Python and SQL for data processing and automation
  • Extensive experience with ETL processes and data pipeline design
  • Excellent problem-solving skills and meticulous attention to detail
  • Strong communication and collaboration skills, with the ability to actively listen, dialogue freely, and verbalize ideas effectively
  • Ability to thrive in an Agile work environment, delivering incremental value to customers by effectively managing and prioritizing tasks
Job Responsibility
Job Responsibility
  • Design, build, and maintain robust and scalable data pipelines using cloud platform tools such as BigQuery, Cloud Storage, Dataflow (Apache Beam), Cloud Composer (Airflow), and Pub/Sub
  • Develop high-performance, production-grade Python and SQL code, optimizing queries for efficient data extraction, transformation, and loading (ETL) processes
  • Implement complex data models in BigQuery, leveraging partitioning, clustering, and materialized views to achieve optimal performance
  • Collaborate closely with cross-functional teams, including business customers and Subject Matter Experts, to gather data requirements and deliver impactful solutions
  • Implement and uphold best practices for data quality, data governance, and data security
  • Proactively monitor and troubleshoot data pipeline issues, ensuring high availability and performance of critical data flows
  • Contribute to strategic data architecture decisions, providing recommendations for continuous improvement of data pipelines
  • Stay current with emerging trends and technologies in cloud-based data engineering and cyber security to drive innovation
  • Lead investigation and resolution efforts for identified data issues, taking ownership to resolve them in a timely manner
  • Document processes and procedures thoroughly for producing accurate metrics and ensuring operational clarity
What we offer
What we offer
  • subsidized health, vision, and dental plans
  • paid sick leave
  • retirement plans with a match
Read More
Arrow Right

Senior Software Developer - Full Stack

We are seeking an expert Senior Full Stack Software Developer to drive the techn...
Location
Location
Canada , Toronto
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
July 26, 2026
Flip Icon
Requirements
Requirements
  • J2EE Mastery: 10+ years of dedicated professional experience utilizing J2EE development tools, enterprise Java programming languages, and hosting platforms (WebLogic/Tomcat)
  • Spring Framework Seniority: 10+ years of hands-on experience building enterprise backend solutions with the Spring Framework
  • DevOps Tooling Seniority: 10+ years of proven working experience automating release management, configuration scripting, and continuous delivery with IBM UrbanCode tools
  • Front-End Proficiency: Demonstrated engineering experience building complex user-centric web applications with the React framework, HTML5, CSS3, and modern JavaScript modules
  • Advanced API Engineering: Deep practical knowledge of designing resilient API architectures (load balancing, discovery, fallback caching mechanisms) and working with OpenAPI/Swagger definitions
  • Domain Context: Direct, prior project experience working on the Digital Dealership Registration (DDR) project or highly similar public-sector registry solutions
  • Education: Bachelor’s degree in Computer Science, Software Engineering, or a related technical discipline (or an equivalent combination of formal education and experience)
Job Responsibility
Job Responsibility
  • Full-Stack Application Engineering: Translate complex technical systems specifications into secure, deployable, and performant multi-tier applications. Develop programming specifications, write clean code, and execute comprehensive unit tests
  • API Architecture & Integration: Design, build, and maintain commercial RESTful and SOAP API services. Implement advanced runtime strategies for API gateways, including load balancing, service discovery, traffic throttling, and circuit-breaking resiliency patterns
  • Front-End Development: Build responsive, modular, and reusable user interface components using React (along with Angular/AngularJS utilities) to ensure an optimized client-side experience and seamless UI-to-API communication
  • Back-End & Framework Delivery: Orchestrate complex server-side enterprise applications utilizing the Spring Framework, EJB, Servlets, and Java application servers such as Tomcat and Oracle WebLogic
  • DevOps & CI/CD Automation: Configure, manage, and scale deployment automation frameworks using IBM UrbanCode release management suites and Azure DevOps pipelines to continuously build, test, and deploy applications
  • Database & Data Pipeline Management: Design relational database structures (Oracle, SQL Server), write highly optimized SQL queries, and construct automated ETL pipelines to handle complex data ingestion, transformation, and movement
  • Technical Problem Solving: Diagnose, troubleshoot, and resolve critical tier-3 issues during systems implementation, legacy database conversions, and multi-environment software migrations
  • Governance & Standards Compliance: Participate in architecture design walkthroughs and maintain strict code compliance with corporate data security policies and the Accessibility for Ontarians with Disabilities Act (AODA)
What we offer
What we offer
  • High-Impact Domain Leadership: Lead the technical expansion of the mission-critical DDR project, directly improving transactional velocity and enterprise platform connectivity
  • Elite Technical Depth: Maximize your market value by commanding an exceptionally robust full-stack architecture that unites standard Spring backends, React frontends, and enterprise UrbanCode automation
  • End-to-End Architectural Impact: Own your features completely—from data mapping, schema tuning, and API gateway routing down to custom UI rendering and CI/CD pipelines
  • Stable Daytime Operations: Benefit from a predictable, highly structured 7.25-hour daily work model within a professional, collaborative engineering branch in downtown Toronto
  • Fulltime
Read More
Arrow Right

Senior ETL Developer

The Applications Development Senior Programmer Analyst is an intermediate level ...
Location
Location
India , Chennai
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years of relevant experience
  • Experience in systems analysis and programming of software applications
  • Design, develop, and maintain ETL pipelines
  • Develop and optimize Informatica mappings, workflows, and sessions
  • Write and maintain PL/SQL scripts, stored procedures, and performance-tuned queries
  • Java / Python scripting
  • Perform data validation, reconciliation, and troubleshooting
  • Work with UNIX/Linux environments
  • Monitor ETL jobs, analyze failures, and implement fixes
  • Experience in managing and implementing successful projects
Job Responsibility
Job Responsibility
  • Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs
  • Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users
  • Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement
  • Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality
  • Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems
  • Ensure essential procedures are followed and help define operating standards and processes
  • Serve as advisor or coach to new or lower level analysts
  • Fulltime
Read More
Arrow Right

Senior Software Developer

We are looking for a Senior Software Developer with a strong hands on mindset to...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
ericsson.com Logo
Ericsson
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 4–8 years of experience as a hands on software developer
  • Strong practical experience with Java and Spring Boot
  • Experience building and consuming REST APIs and microservices
  • Hands on experience with Kafka and asynchronous messaging
  • Strong knowledge of PostgreSQL and SQL tuning
  • Experience working with Docker and Kubernetes
  • Familiarity with ETL concepts and large volume data processing
  • Experience in Agile/DevOps ways of working
  • Tools: Git, Jira, Confluence
Job Responsibility
Job Responsibility
  • Develop, test, and maintain software components using Java (8/11+) and Spring Boot
  • Implement business logic, data processing, and transformation rules in code
  • Build and integrate microservices using REST, JSON/XML, and Kafka
  • Work extensively with PostgreSQL, including SQL optimization and performance tuning
  • Contribute to high volume data processing with a strong focus on efficiency and stability
  • Debug complex issues across application, database, and integration layers
  • Work with Docker and Kubernetes in cloud based environments
  • Support testing, validation, and execution activities in delivery projects
  • Follow established designs and contribute feedback for continuous improvement
  • Produce and maintain technical documentation related to implemented functionality
Read More
Arrow Right

Senior Software Developer

ELEKS Software Engineering and Development Office is looking for a Senior Softwa...
Location
Location
Ukraine
Salary
Salary:
Not provided
eleks.com Logo
ELEKS
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of experience with Python, C# or JavaScript
  • Domain experience in trading, logistics, or mining (must-have)
  • Previous experience with Aspect or similar mining/commodities systems (CTRM/TERM/Endur)
  • Strong SQL skills, including queries, stored procedures, and performance optimization
  • Experience with API integrations (REST/SOAP), ETL interfaces, and file-based data flows
  • Familiarity with Windows Server, application logs, and troubleshooting tools
  • Hands-on experience with Git, CI/CD pipelines, and standard software development practices
  • Ability to understand and work with large data models, relational schemas, workflows, and business rules
  • Unit testing experience (essential)
  • Experience supporting or developing line-of-business systems (ERP, production accounting, CTRM, planning tools)
Job Responsibility
Job Responsibility
  • Design, develop, and maintain reliable software in line with technical requirements
  • Analyze requirements, and independently estimate and set up tasks’ acceptance criteria
  • Evaluate and coordinate tasks’ deadlines with the Technical Leader or Project Manager
  • Apply the best software development practices and coding standards to produce high-quality and performant solutions
  • Stay up-to-date with modern technology and optionally obtain professional certifications
  • Participate as a trainer or a trainee in various learning programs outside the main project
What we offer
What we offer
  • Close cooperation with a customer
  • Challenging tasks
  • Competence development
  • Ability to influence project technologies
  • Team of professionals
  • Dynamic environment with low level of bureaucracy
Read More
Arrow Right

Senior ETL Abinitio Developer - Vice President

Senior ETL Abinitio Developer - Vice President is a senior level position respon...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 10-15 years of relevant experience in Apps Development or systems analysis role, primarily into ETL Abinitio Development
  • Extensive experience system analysis and in programming of software applications
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
  • Bachelor's degree/University degree or equivalent experience
  • Strong knowledge of Abinitio or Spark and in SQL, Unix/Linux, and modern data engineering practices
  • Experience with data orchestration, data quality frameworks, and metadata management
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets
  • Modernizing legacy data flows
  • Designing scalable, future-ready data solutions
  • Fulltime
Read More
Arrow Right