Software Developer – ETL – Senior

Job title: Software Developer – ETL – Senior

Company: LanceSoft

Job description: Job Title: Senior ETL Software Developer
Duration: 12 Months
Location: Toronto (hybrid 3 days onsite)
Hours: 7.25 hoursResponsibilities:

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Must Haves

• Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
• Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) script.
• Experience with data integration, data cleansing, and data analytics.

Nice to have skills:

• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
• Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
• Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
• Experience writing scripts with PowerShell and other scripting languages.
• Experience in implementation of SaaS solution.

Expected salary:

Location: Toronto, ON

Job date: Fri, 11 Apr 2025 07:42:29 GMT

Apply for the job now!