About this role
RQ11258 - Sr. Software Developer - ETL 9-month contract (188 business days) - possible extension ONSITE 5 days - 5700 Yonge Street Security Level: CRJMC Must-haves: 10+ years of experience in:
• Designing and developing scalable Medallion Data Lakehouse architectures. • Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks. • Building, automating, and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF), Databricks (PySpark, SQL, Delta Live Tables), and dbt. • Strong knowledge of relational (SQL Server, Synapse, PostgreSQL) and dimensional modeling. • CI/CD automation (Azure DevOps, GitHub Actions) for data pipelines. • Power BI Nice-to-have: • Public Sector Enterprise Architecture artifacts (or similar) Description: · Design technical solutions for data acquisition and storage into our centralized data repository. · Develop ELT scripts, design data-driven logic and conduct unit testing. · Conduct database modeling and design as to improve overall performance. · Produce design artifacts and documentation which will allow future support of the implemented solutions. · Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the data provider. · Execute service requests related to routine and ad-hoc data loads. · Provide the data quality check and report on the data quality issue. AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations. Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting. INCORPORATED RATE RANGE (7.25 billable hours per day) • $88.52/hr - $106.25/hr Inc. T4 RATE RANGE (7.25 billable hours per day) • $70.82/hr - $85.00/hr T4