Data Engineer – Python, SQL, Airflow, dbt

An Initial AI Screening will be conducted for this role.

JOB DESCRIPTION

Location: Hybrid (Downtown, Toronto)

Duration: 7 months

Our client, a leading financial institution in Downtown Toronto, is looking for a Data Engineer - Python, SQL, Airflow, dbt to Support operational excellence through monitoring, incident management, and continuous process improvement. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in role:

• 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

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

Soft Skills Required:

• Strong analytical and decision-making abilities.
• Excellent communication and interpersonal skills
• A high-performing, detail-oriented, and proactive mindset with strong ownership in handling user requests and troubleshooting issues, and driving continuous improvement initiatives

Education:

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

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is C$40 - C$58. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.