Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 33 hours ago

RQ10949 - Sr. Software Developer - ETL

SourceCode857 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ10949 - Sr. Software Developer - ETLSourceCode · Toronto, ON, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on SourceCode's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.5% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.5%7 days
  4. 18.1%14 days
  5. 35.6%30 days
  6. 44.6%60 days
This job: first seen 33 hours ago

The posting

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
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against SourceCode's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on SourceCode's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    SourceCode's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.