Software Developer - ETL - Senior

Job Description

Software Developer - ETL - Senior:
On behalf of our Government Services client, Procom is searching for a Software Developer - ETL - Senior for an 8-month role. This position is an onsite position at our client’s Toronto, Ontario office.

Software Developer - ETL - Senior - Job Description:
The project involves designing and developing scalable data acquisition and storage solutions. The focus is on implementing data lakehouse architectures using Azure technologies, primarily for data ingestion, transformation, and curation.

Software Developer - ETL - Senior - Responsibilities:
• Design technical solutions for data acquisition and storage into a centralized data repository
• Develop ELT scripts and design data-driven logic
• Conduct unit testing and database modeling
• Produce design artifacts and documentation
• Investigate and resolve incidents related to data loading and quality
• Execute service requests for routine and ad-hoc data loads

Software Developer - ETL - Senior - Mandatory Skills:
• 10+ years of experience building data/ETL solutions
• Expertise with Azure and Databricks stack: ADF, Databricks (PySpark/SQL/Delta/Delta Live Tables), dbt
• Experience with Data lakehouse / Delta Lake and medallion architecture
• Strong SQL skills including optimization and indexing/partitioning
• CI/CD experience with Azure DevOps/GitHub Actions
• Understanding of security/governance concepts (RBAC, data governance)

Software Developer - ETL - Senior – Nice-to-Have Skills:
• Experience with large complex IT Health-related projects
• Public sector experience
• Strong communication skills
• Experience in teamwork and problem-solving
• Knowledge of Unity Catalog

Software Developer - ETL - Senior – Assignment Length:
This is an 8-month contract position.

Software Developer - ETL - Senior - Start Date:
ASAP

Software Developer - ETL - Senior - Assignment Location:
Toronto, Ontario, Canada, onsite.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.