Connexion Inscription gratuite
Postuler

Première détection par notre source: il y a 29 jours

RQ10949 - Sr. Software Developer - ETL

@ Source Code

Toutes ses offres

Toronto, Ontario

70,90–106,36 $/h5+ ans d’expérience
Postuler
SIGNAUX

En bref

Source Code is hiring a Senior Software Developer for a 10-month contract with the Office of the Public Guardian and Trustee (Ontario) to migrate digital files to an OpenText document management solution, migrate legacy data to a lakehouse, build data assets, and create Power BI reports. The role is onsite five days a week at 21 College Street, with a CRJMC security check and a credit check. Rates are $88.63 to $106.36/hr incorporated or $70.90 to $85.09/hr T4.

Salaire :

70,90 $–106,36 $ de l’heure

Responsabilités :

  • Migrate digital files to OpenText document management
  • Migrate legacy data to data warehouse or lakehouse
  • Build and automate ETL processes in Azure
  • Create Power BI reports and dashboards
  • Design logical and physical data models

Résumé des exigences :

  • 5+ years proven ETL experience
  • Azure Synapse pipelines and data flows
  • Dynamics 365 CE and F&O data integration
  • SQL Server, Oracle and Azure SQL databases
  • Python proficiency
  • CRJMC security check and credit check

Outils et compétences

Azure SynapsePower BIOpenTextDynamics 365DataverseSQL ServerOracleAzure SQL DatabasePython
Source et dates

Type de source non vérifié · manatal

Date publiée par l’employeur
Non fourni
Première détection par notre source
2026-10-12
Mise à jour du dossier source
2026-10-15

Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.

Détails du poste

NiveauSenior
DomaineGénie
Expérience5 an(s) et plus
Heures par semaine36.25
Horairejour
Déplacementsavion : aucun · route : aucun
Milieu de travailBureau
PositionSurtout assis
Exigences physiquesphysique faible · ordinateur élevé
LanguesEnglish
Vérificationscrédit
Cote de sécuritéAutre cote

Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.

Postuler

Source Code

Toutes ses offres
ChampValeur
Offres sur Jobsy656
Description

RQ10949 - Sr. Software Developer - ETL

10-month contract (206 business days) - 2 possible extensions

ONSITE 5 days - 21 College Street

Security Level: CRJMC + Credit Check

Must-haves:

  • 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
  • Proficiency in Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
  • Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
  • Proven experience working with data from Dynamics 365 CE and Dynamics 365 F&O as an ETL developer
  • Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
  • Python

Scope:

The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer to migrate digital files to an OpenText based document management solution, migrate historical data from legacy systems to a data warehouse/lakehouse, to build data assets in the lakehouse, and to create PowerBI reports.

Assignment Deliverables

As a member of the data team, you will be responsible for the migration of digital files to an enterprise OpenText based document management solution, the migration of historical data from legacy systems to a data warehouse/lakehouse, building data assets in the lakehouse, and creating PowerBI reports. A high-level list of deliverables for the data migration team follows:

  • Data Warehouse Design: analyze business requirements and the data warehouse/lakehouse/golden layer on Microsoft Azure
  • Data extraction: Identify/define data to be extracted and migrated to the data warehouse/lakehouse or document storage solution
  • Data Integration and ETL: help develop and automate ETL processes to load data from external solutions into the data warehouse/lakehouse (bronze/silver/golden layers) and integrate data into the data warehouse.
  • Digital file migration: Identify/define data/files to be extracted and migrated to the OPGT's OpenText based document management solution
  • Data Integration and ETL: help develop and automate ETL processes to load digital files from external storage solutions into the enterprise OpenText based document storage solution
  • Data Modeling: create logical and physical data models that align with the project's reporting and analytical needs.
  • Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse and reports.
  • Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.
  • Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
  • Other duties as assigned.

You will also be required to:

  • Complete work and achieve milestones within the assigned deadlines.
  • Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
  • Submit Deliverables for the Cluster/Ministry approval as they are completed.
  • Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
  • Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
  • Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
  • Provide knowledge and skill transfer to a designated Cluster/Ministry staff
  • Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

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.63/hr - $106.36/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $70.90/hr - $85.09/hr T4

Emplois semblables

  • Senior Full Stack Software Engineer

    Toronto, ON
    HybrideTemps plein

    CanadaVisa: Cohen Immigration Law is a long-standing full-service Canadian immigration and citizenship law firm, specializing in all aspects of Canadian…

    Compensation: $150k - $165k + 10% target annual performance bonus, depending on experience; CanadaVisa brings together nearly 50 years of legal experience through Cohen Immigration Law and thousands of client matters…

    Consumer law, Immigration law, Node.js, TypeScript, React, Next.js

  • Grants Manager / Gestionnaire de subventions

    Toronto, ON
    85k–95k $/anHybrideTemps plein, Contrat

    The Law Foundation of Ontario

    Connaissance du secteur de la justice et de l’accès à la justice; Expérience dans les secteurs à but non lucratif ou philanthropique; Expérience en élaboration et gestion de programmes de subvention

    Legal research, Reporting, Communication skills, Time management, Problem solving, Bar admission

  • Platform Backend Engineer (Go, Distributed Systems & Event Streaming)

    Toronto, ON

    Kaseya Careers: Kaseya is the leading global provider of AI-powered IT management and cybersecurity software.

    Candidates at Kaseya Careers need experience building production backend services in Go and designing event-driven or streaming systems. They also need experience running containerized services on Kubernetes and troubleshooting distributed systems.

    Go, Kubernetes, Kafka, Numaflow, Flink, Temporal

  • Solution Engineer Manager

    Toronto, ON
    128k–222k $/anSur placeTemps plein

    Microsoft: Every company has a mission.

    6+ ans3+ gestionCandidates need a bachelor's or master's degree in a technical or business field plus years of technical pre-sales or consulting experience, with 3+ years of people management preferred. Microsoft wants strong cloud architecture, migration and Azure knowledge, plus the ability to coach teams and win technical decisions.

    Microsoft Azure, Microsoft Copilot, CRM

  • Clinical Educator (Japanese)

    Toronto, ON
    TélétravailTemps partiel

    Vira Health

    3+ ansCandidates need an active healthcare license, at least 3 years of women's health clinical experience in Japan, and professional Japanese. Telehealth experience and clear communication of complex medical information are also required.

    Video conferencing tools, Virtual health platforms

  • Client Services Specialist

    Toronto, ON
    Temps plein

    Solactive AG

    3+ ansCandidates need 3-5 years of experience in client services, sales or business operations, with CRM experience (ideally Salesforce) and strong Microsoft Excel skills. Strong communication, organisation and stakeholder management abilities are also required, and candidates must be legally authorized to work in Canada.

    Salesforce, Microsoft Excel

  • Senior Content Writer

    Toronto, ON
    Temps plein

    Publicis Groupe Holdings B.V

    5+ ansCandidates need 5+ years in a creative role, a portfolio of brand content, strong and clear writing, and deep knowledge of major social platforms. They should be comfortable presenting ideas to senior agency and client stakeholders.

    Community engagement, Presentation skills, Decision making

  • Proposal Specialist

    Toronto, ON +8
    Temps plein

    Dillon Consulting Limited: Dillon is a proudly Canadian, employee-owned, professional consulting firm with over 1,100 employees specializing in planning, engineering,…

    Candidates need proposal preparation and submission experience and post-secondary education in Business, Marketing, Communications or a related field. Skill with AI-enabled tools and proposal management platforms, strong organization under deadlines, and professional services experience are assets.

    AI-enabled tools, proposal management platforms

Lieux et modes de travail

Lieux

Tout le CanadaTélétravail · Hybride · Sur place · Sur le terrain

Astuce : ajoutez le télétravail pour élargir la recherche.

Exclure des lieux

Mode de travail

Offres de cette entreprise dans les résultats

Voici les offres de cette entreprise chargées dans votre recherche. Elle peut avoir d’autres postes ouverts.