Senior Software Developer - ETL Job at Teckhorizon Inc, Ontario, CA

NXlETFd5MG1rNEJrNXNaSjE2VUJ2d2ZwclE9PQ==
  • Teckhorizon Inc
  • Ontario, CA

Job Description

RQ09427 Senior Software Developer ETL

Client: Ministry of Treasury Board Secretariat Central Agencies Cluster
Location: 222 Jarvis Street, Toronto, ON
Work Type: Hybrid (3 days onsite, 2 days remote)

Role Summary

The Senior ETL Developer will design, develop, and maintain backend database and ETL applications for enterprise Data Warehouse and Business Intelligence solutions. The role involves translating system specifications into functional, well-documented ETL code and collaborating with cross-functional teams to ensure scalable and reliable data flows.

Responsibilities

  • Design and implement robust ETL pipelines using Microsoft technologies (Azure, SQL, Power BI).
  • Translate technical specs into fully tested, functional code.
  • Develop and maintain ETL scripts with schedule/dependency logic.
  • Investigate and resolve issues in data flows; provide post-implementation support.
  • Collaborate on solution design, documentation, and walkthrough sessions.
  • Ensure applications meet performance, scalability, and compliance standards.

Mandatory Skills and Experience

  • Proven experience with:
    • Azure Data Factory , Azure SQL Database , Azure Data Lake , Power BI
    • Oracle DB and structured/semi-structured data sources
    • Developing daily and initial load ETL programs
    • Constructing complex SQL queries and performance tuning
    • Data integration, cleansing, analytics, and modeling for data marts/warehouses
    • Source control tools (e.g., Git ) and documentation (ETL mappings, data models, etc.)
  • Strong understanding of:
    • ETL architecture and schedule/dependency logic
    • Full SDLC (Development Testing QA Delivery)
    • Business requirement gathering and validation
  • Excellent communication and collaboration skills

Desirable Skills

  • Knowledge of:
    • Designing dashboards/KPIs and generating reports
    • C#, APIs, Functions, scripting languages (e.g., PowerShell )
    • SaaS implementations and RAD methodologies
    • Middleware, gateways, and software installation scripts

Job Tags

Remote job,

Similar Jobs

Synechron

Java Developer with Github Co-Pilot / AI Code Generator Blockchain Job at Synechron

 ...Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been... 

Lensa

Project Coordinator-remote Job at Lensa

 ...which include employers, recruitment agencies, and marketing partners. Job Title: Project Coordinator Type: Contract Compensation: $63 - $80 hourly Contractor Work Model: Remote System One is seeking a Project Coordinator to support the management of... 

Hirebridge

Utility Arborist/ Planner Job at Hirebridge

Work Planner / Utility ArboristWho are we?Were dedicated to the growth of our employees. We truly believe in your development. For those who show initiative, we will do what it takes to get you where you want to go.Were growing but still maintain an entrepreneurial... 

DC SECURITY INC

Armed Security Guard Job at DC SECURITY INC

 ...Job Description Job Description About DC Security Inc.: At DC Security Inc., we are committed to providing professional...  ...assets with vigilance and respect. We are currently seeking Armed Security Guards to join our growing team and uphold the safety standards... 

Improveit Home Remodeling

Project Coordinator - Remote Job at Improveit Home Remodeling

 ...This is a remote position Position Overview The Project Coordinator is responsible for driving customer satisfaction through coordination of projects from sale to completion in a timely and efficient manner. This position is responsible for the control and management...