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

Open nowFirst seen 43 hours ago

RQ08913 - Software Developer - ETL - Senior

Rubicon Path638 open roles

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

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

Your applicationOpen nowRQ08913 - Software Developer - ETL - SeniorRubicon Path · Toronto, Ontario, 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 Rubicon Path'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.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.4%3 days
  3. 11.8%7 days
  4. 18.6%14 days
  5. 35.6%30 days
  6. 45.1%60 days
This job: first seen 43 hours ago

The posting

Responsibilities:

  • Design technical solutions for data acquisition and storage into our centralized data repository.
  • Develop ELT scripts, design data-driven logic and conduct unit testing.
  • Conduct database modeling and design as to improve overall performance.
  • Produce design artifacts and documentation which will allow future support of the implemented solutions.
  • Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the data provider.
  • Execute service requests related to routine and ad-hoc data loads.
  • Provide the data quality check and report on the data quality issue.

SkillsExperience and Skill Set Requirements

Technical Skills

10+ years experience in:

· Designing and developing scalable Medallion Data Lakehouse architectures.

· Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.

· Experience integrating structured and unstructured data sources into star/snowflake schemas.

· Building, automating, and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF), Databricks (PySpark, SQL, Delta Live Tables), and dbt.

· Implementing orchestrated workflows and job scheduling in Azure environments.

· Strong knowledge of relational (SQL Server, Synapse, PostgreSQL) and dimensional modeling.

· Advanced SQL query optimization, indexing, partitioning, and data replication strategies.

· Experience with Apache Spark, Delta Lake, and distributed computing frameworks in Azure Databricks.

· Working with Parquet, ORC, and JSON formats for optimized storage and retrieval.

· Deep expertise in Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Azure SQL, Event Hubs, and Azure Functions.

· Strong understanding of cloud security, RBAC, and data governance.

· Proficiency in Python (PySpark), SQL, and PowerShell for data engineering workflows.

· Experience with CI/CD automation (Azure DevOps, GitHub Actions) for data pipelines.

· Implementing data lineage, cataloging, metadata management, and data quality frameworks.

· Experience with Unity Catalog for managing permissions in Databricks environments.

· Expertise in Power BI (DAX, data modeling, performance tuning).

· Experience in integrating Power BI with Azure Synapse and Databricks SQL Warehouses.

· Familiarity with MLflow, AutoML, and embedding AI-driven insights into data pipelines.

50 points

Core Skill and Experience

· 10+ years of experience with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications.

· 10+ years of experience in technical analysis, program code, detailed programming and reports specifications, program design, writing and /or generating code, and conducting unit tests.

· 10+ years of experience in software in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.

· 10+ years of experience in developing and maintaining system design models, technical documentation, and specifications.

· 5+ years of experience in conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements / specifications / documentation.

· SDLC end-to-end.

30 points

General Skills

· Demonstrated strong leadership and people management skills.

· Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions.

· Exceptional analytical, problem solving and decision-making skills.

· Demonstrated strong interpersonal, verbal and written communication, and presentation skills.

· Proven troubleshooting and critical thinking experience

· Demonstrated ability to apply strong listening skills to facilitate issue resolution.

· Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships.

· Strong interpersonal, facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome.

· Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively.

· A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

15 points

Public Sector/Healthcare Experience

· Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.

· Knowledge of Project Management Institute (PMI) and Public Sector I&IT project management methodologies.

· Knowledge and understanding of Ministry policy and IT project approval processes and requirements.

· Experience with large complex IT Health-related projects.

5 points

MUST HAVES:

10+ years experience in:

· Designing and developing scalable Medallion Data Lakehouse architectures.

· Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.

· Experience integrating structured and unstructured data sources into star/snowflake schemas.

· Building, automating, and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF), Databricks (PySpark, SQL, Delta Live Tables), and dbt.

· Implementing orchestrated workflows and job scheduling in Azure environments.

· Strong knowledge of relational (SQL Server, Synapse, PostgreSQL) and dimensional modeling.

· Advanced SQL query optimization, indexing, partitioning, and data replication strategies.

· Experience with Apache Spark, Delta Lake, and distributed computing frameworks in Azure Databricks.

· Working with Parquet, ORC, and JSON formats for optimized storage and retrieval.

· Deep expertise in Azure Data Lake Storage (ADLS), Azure Synapse Analytics, Azure SQL, Event Hubs, and Azure Functions.

· Strong understanding of cloud security, RBAC, and data governance.

· Proficiency in Python (PySpark), SQL, and PowerShell for data engineering workflows.

· Experience with CI/CD automation (Azure DevOps, GitHub Actions) for data pipelines.

· Implementing data lineage, cataloging, metadata management, and data quality frameworks.

· Experience with Unity Catalog for managing permissions in Databricks environments.

· Expertise in Power BI (DAX, data modeling, performance tuning).

· Experience in integrating Power BI with Azure Synapse and Databricks SQL Warehouses.

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 Rubicon Path'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 Rubicon Path'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

    Rubicon Path'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.