Senior Software Developer - ETL

We are seeking a highly accomplished Senior Software Developer - ETL to lead the technical design, data ingestion strategy, and performance optimization of enterprise-scale data storage repositories. In this role, you will take technical ownership of translating complex system specifications into secure, high-performance data engineering workflows. Operating at the core intersection of distributed cloud computing and business intelligence, you will build automated data pipelines, implement robust governance controls, and optimize multi-tiered data architectures to ensure seamless data delivery for mission-critical applications.

Location: North York, ON

Duration: 9-month contract.



Advantages
Cutting-Edge Data Stack: Drive high-value technical initiatives leveraging premium, distributed big data frameworks and modern transformation suites.

End-to-End Core Ownership: Command complete functional autonomy over the data lifecycle—from raw cloud ingestion to performance-optimized reporting layers.

Enterprise-Scale Pipeline Impact: Shape large-scale, high-velocity data lakehouse environments supporting mission-critical digital workflows.

Elite Telemetry & Governance Exposure: Expand your engineering profile by establishing state-of-the-art cataloging frameworks and data lineage models.



Responsibilities
Data Lakehouse Architecture: Design, implement, and maintain highly scalable Medallion Data Lakehouse architectures (Bronze, Silver, and Gold tiers) to capture, store, and process massive enterprise datasets.

Pipeline Engineering & Automation: 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.

Distributed Computing Optimization: Develop data-driven logic and streaming frameworks utilizing distributed clusters, optimizing query execution, data indexing, partitioning schemes, and storage file formats.

Database Modeling & Warehousing: Design logical and physical dimensional data models, integrating disparate data sources into optimized star and snowflake schemas ready for downstream analytics.

Incident Triage & Quality Assurance: Investigate and resolve data loading exceptions, performing deep root-cause analysis to distinguish between software failures and source-data quality anomalies.

Business Intelligence Integration: Build and connect high-performance data models with cloud data warehouses, implementing advanced calculations and performance tuning to support seamless user reporting.

Data Governance & Permissions Management: Operationalize advanced cataloging engines and data governance frameworks, managing fine-grained data permissions, data lineage tracking, and role-based access controls (RBAC).

CI/CD Lifecycle Operations: Implement automated deployment packages and release routines using continuous integration pipelines to manage the lifecycle of data platform infrastructure.

Technical Evaluation & Modeling: Conduct detailed technical design evaluations, option analyses, and gap assessments for complex integration components to resolve architectural blockers.

Documentation & Reference Design: Produce and maintain comprehensive technical specifications, logical system models, metadata dictionaries, and operational deployment guides to support long-term environment maintenance.



Qualifications
Core Data Engineering Seniority: 10+ years of progressive professional experience translating complex system specifications into tested, working applications for large-scale, mission-critical environments.

Cloud Lakehouse Expertise: 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.

Pipeline Orchestration Mastery: Demonstrated success constructing and automating enterprise ETL/ELT data pipelines using Azure Data Factory (ADF) and configuring job schedules.

Advanced Database Scripting & Modeling: Mastery of relational database management systems (SQL Server, Synapse, PostgreSQL) and dimensional modeling alongside advanced SQL query optimization and replication tuning.

Big Data Storage Mechanics: Practical development experience manipulating Apache Spark distributed environments and working with storage formats including Parquet, ORC, and JSON.

Cloud Infrastructure Depth: High proficiency navigating cloud ecosystems, specifically Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Event Hubs, and Azure Functions.

Governance & Security Acumen: Direct, practical experience implementing enterprise data access controls, cloud security models, data lineage tracking, and Unity Catalog data governance.

Business Intelligence Interoperability: Strong experience integrating front-end systems like Power BI (DAX, performance tuning) with cloud warehouses and data pipelines.

CI/CD Delivery Skills: Proven background applying continuous integration and automated deployment protocols via Azure DevOps or GitHub Actions.

Technical Evaluation & Assessment: 5+ years of explicit experience running gap analyses, assessing technical options for architecture issues, and delivering robust system integration designs.

Soft Skills: Outstanding leadership, negotiation, and verbal/written communication skills, with an established history of managing multi-stakeholder expectations and resolving data roadblocks with diplomacy.

Nice to Have:
Prior software engineering experience delivering large-scale data solutions within a public sector or healthcare information management infrastructure.

Familiarity with machine learning tracking applications (e.g., MLflow, AutoML) to embed predictive insights directly into streaming data pipelines.



Summary
If you're interested in the "Senior Software Developer - ETL" role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!



Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.