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

czJrT2E4VmF2T3ljMW1yOFlJRlZwc2lxY3c9PQ==
  • 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

Bright Flag Recruiting

Delivery Driver Job at Bright Flag Recruiting

 ...Job Description North Bay Services with FedEx Ground has IMMEDIATE OPENINGS for delivery...  ...motivated and dependable individuals to work as part of a team! If you are seeking an employer...  ...are now accepting applications for full-time and part-time delivery drivers! Pay: $1.... 

IQVIA

Consultant - Commercial Solutions & Insights Hub (CSIH) Analytics Job at IQVIA

 ...you must reside in the same country where the job is located. Consultant - Commercial Solutions & Insights Hub (CSIH), Analytics Pillar...  ...receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin... 

IntePros

Communications Coordinator Job at IntePros

 ...Job Description Job Title: Communications Coordinator Work Location: Trevose, PA Contract Type: Contract Position Overview...  ...to create, coordinate, and deliver impactful messaging for internal and external audiences. You will play a key part in drafting... 

ChristianaCare

Registered Nurse, Radiation Oncology, Newark, DE Job at ChristianaCare

 ...cover the high volume of patient visits at the main HFGCCRI location in Newark, three nurses covering the high acuity inpatients and HDR patients at the Hospital, and one-two nurse at the Concord Health location. Shift: Full-time - 40 hours/week Day shift hours... 

24 Seven Talent

Technical Designer - Swim Job at 24 Seven Talent

 ...and technical design experience with swim and/or activewear. Seeking someone who can lead fittings, create tech packs, work with overseas vendors Patternmaking experience is a plus. Apparel experience with items such as sweaters is a plus. Must be able to...