Data Analytics Specialist (7+ years) to build and maintain scalable ETL/ELT pipelines using SQL, Python, Apache Airflow, and cloud platforms- 41544

Our financial services client is seeking a Data Analytics Specialist (7+ years) to build and maintain scalable ETL/ELT pipelines using SQL, Python, Apache Airflow, and cloud platforms- 41544

Contract Duration: 7 months (Possibility of extension beyond 12 months)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group: The Global Analytics Operations team is focused on maintaining, stabilizing, and improving cloud-based data platforms so the bank can make data-driven decisions.

Project/initiatives

Global Analytics Operations project: Requires engineering, analytics, and computer science to deliver scalable, reliable solutions. With a strong focus on operational excellence, it drives high pipeline reliability, proactive monitoring, and timely issue resolution while continuously enhancing processes, improving user experience, and introducing new analytical patterns through close collaboration with cross-functional partners.

Candidate Value Proposition:

This is an opportunity to join a high‑visibility enterprise transformation program at a leading financial institution, focused on modernizing Identity & Access Management (IAM) at scale. You will play a critical leadership role in delivering the rollout of Microsoft Entra ID and Multi-Factor Authentication (MFA) across a complex, global organization.

Typical Day in Role:

- Support operational excellence through monitoring, incident management, and continuous process improvement
- Own user requests and data inquiries while actively experimenting, learning, and driving continuous improvement in day-to-day operations .
- Proactively identify gaps and implement scalable improvements, including new analytical patterns and automation to optimize workflows
- Support analysts and data scientists with reliable, timely, and accessible data, while using AI/agent-based solutions to automate and optimize time-consuming processes
- Partner with business teams to understand data needs and deliver actionable insights to management and stakeholders
- Build and maintain scalable data models and ETL/ELT pipelines
- Maintain data quality through automated testing, monitoring, and proactive issue resolution
- Apply data governance, security, and documentation standards across pipelines and architecture

Candidate Requirements/Must Have Skills:





- 5-7 years of experience in SQL (advanced to expert level)
- 3-4 years of experience with workflow orchestration tools such as Apache Airflow
- 3-4 years of experience working with Python for pipeline development.
- 3-4 years of experience with cloud platforms (GCP, AWS, or Azure).
- Experience with modern data stack tools (including dbt)

Nice-To-Have Skills:

Solid understanding of data warehousing concepts and dimensional modeling

Knowledge of the banking/finance domain and data governance practices is an asset

Education:

Bachelor’s or Graduate degree in Computer Science, Engineering, or related field (or equivalent experience)

Best VS. Average Candidate:

The best candidate has hands-on experience with SQL and Python and has a proactive mindset.

1st – Hiring manager or technical lead– Online or in person – 60 mins - scenario-based questions on SQL and Python, DBT, Airflow, ETL and Data Modelling.

2nd – Director– Online or in person -60 mins – Cultural fit and experience check.

Our financial services client is seeking a Data Analytics Specialist (7+ years) to build and maintain scalable ETL/ELT pipelines using SQL, Python, Apache Airflow, and cloud platforms- 41544

Location Address: Toronto/Hybrid.– 2 days/week on site

Contract Duration: 7 months (Possibility of extension beyond 12 months)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group: The Global Analytics Operations team is focused on maintaining, stabilizing, and improving cloud-based data platforms so the bank can make data-driven decisions.

Project/initiatives

Global Analytics Operations project: Requires engineering, analytics, and computer science to deliver scalable, reliable solutions. With a strong focus on operational excellence, it drives high pipeline reliability, proactive monitoring, and timely issue resolution while continuously enhancing processes, improving user experience, and introducing new analytical patterns through close collaboration with cross-functional partners.

Candidate Value Proposition:





This is an opportunity to join a high‑visibility enterprise transformation program at a leading financial institution, focused on modernizing Identity & Access Management (IAM) at scale. You will play a critical leadership role in delivering the rollout of Microsoft Entra ID and Multi-Factor Authentication (MFA) across a complex, global organization.

Typical Day in Role:

- Support operational excellence through monitoring, incident management, and continuous process improvement
- Own user requests and data inquiries while actively experimenting, learning, and driving continuous improvement in day-to-day operations .
- Proactively identify gaps and implement scalable improvements, including current analytical patterns and automation to optimize workflows
- Support analysts and data scientists with reliable, timely, and accessible data, while using AI/agent-based solutions to automate and optimize time-consuming processes
- Partner with business teams to understand data needs and deliver actionable insights to management and stakeholders
- Build and maintain scalable data models and ETL/ELT pipelines
- Maintain data quality through automated testing, monitoring, and proactive issue resolution
- Apply data governance, security, and documentation standards across pipelines and architecture

Candidate Requirements/Must Have Skills:

- 5-7 years of experience in SQL (advanced to expert level)
- 3-4 years of experience with workflow orchestration tools such as Apache Airflow
- 3-4 years of experience working with Python for pipeline development.
- 3-4 years of experience with cloud platforms (GCP, AWS, or Azure).
- Experience with modern data stack tools (including dbt)

Nice-To-Have Skills:

Solid understanding of data warehousing concepts and dimensional modeling

Knowledge of the banking/finance domain and data governance practices is an asset

Education:

Bachelor’s or Graduate degree in Computer Science, Engineering, or related field (or equivalent experience)

Best VS. Average Candidate:

The best candidate has hands-on experience with SQL and Python and has a proactive mindset.

1st – Hiring manager or technical lead– Online or in person – 60 mins - scenario-based questions on SQL and Python, DBT, Airflow, ETL and Data Modelling.

2nd – Director– Online or in person -60 mins – Cultural fit and experience check.

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.

📌 Data Analytics Specialist (7+ years) to build and maintain scalable ETL/ELT pipelines using SQL, Python, Apache Airflow, and cloud platforms- 41544 (Toronto)
🏢 S.i. Systems
📍 Toronto