Senior ETL - Software Developer
Information Systems
Software Engineer
Your Role
Position: Senior ETL - Software Developer
Duration: 9 Months assignment (contract)
Client Location: Toronto (Onsite: 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday)
Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)
Note on Assignment Type
This position is provisionally Onsite, requiring 7.25 hours per calendar day between 8:00 AM and 5:00 PM, Monday to Friday (excluding breaks). Conditions may change based on organizational requirements and at the discretion of the Hiring Manager.
About the Engagement
Akkodis is seeking an experienced Senior ETL - Software Developer to design, develop, implement, and maintain database backend and ETL applications supporting enterprise Data Warehouse and Business Intelligence solutions.
The successful consultant will develop and continuously enhance data pipelines by performing data extraction, transformation, and loading activities across a variety of structured and semi-structured data repositories. The role requires strong hands-on expertise with Microsoft Azure data technologies, AWS data services, Databricks, ETL development, data modelling, SQL, database technologies, and Business Intelligence solutions.
Scope
Design, develop, implement, and maintain ETL applications, data pipelines, database backends, Data Warehouse, and Business Intelligence solutions.
Develop extraction, transformation, and loading processes for both daily and initial data loads.
Design and maintain schedule and dependency logic for ETL processes and scripts.
Perform data integration, cleansing, transformation, validation, and analytics.
Assignment Deliverables
Design, implement, and continuously enhance enterprise ETL data pipelines.
Develop extraction, transformation, and load functionality across structured, semi-structured, relational, and multidimensional data repositories.
Develop and maintain database backend solutions supporting Data Warehouse and Business Intelligence applications.
Create and maintain ETL source-to-target mappings, data models, architecture artifacts, and detailed technical-design documentation.
Expertise Required
Must Have:
Strong experience with the Microsoft Azure data technology stack, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
Hands-on experience with the Databricks Platform.
Experience with Amazon Web Services (AWS) data technologies, including Amazon Aurora, Amazon RDS, AWS Glue, and OpenSearch.
Strong experience developing data extraction, transformation, and load (ETL) processes, including daily and initial loads, across structured and semi-structured files and relational/multidimensional data stores.
Experience developing, implementing, and maintaining scheduling and dependency logic for ETL scripts and data pipelines.
Experience with data modelling and design principles for data marts and enterprise data warehouses.
Nice to Have:
Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs) and developing scheduled and ad-hoc reports.
Experience with programming languages such as C#, including development of application components such as APIs and Functions.
Security Clearance
Required.
Important
This is a business-to-business engagement. Candidates must represent an incorporated entity, hold a valid business number, maintain appropriate insurance, and invoice for services rendered.
How to Apply
Submit your resume in confidence via the Akkodis Canada website.
We thank all applicants for their interest in this opportunity. Only candidates meeting the above qualifications will be contacted for further discussions.
Accessibility:
At Akkodis, part of The Adecco Group, our purpose is simple: to make the future work for everyone. We live our values, Passion, Collaboration, Inclusion, Courage, and Customers at Heart, by fostering a workplace where diversity is celebrated and every voice matter. We encourage applications from individuals of all backgrounds and identities. Together, we’re making the future work for everyone.
Ref: 1649221