Data Engineer – Python, SQL

An Initial AI Screening will be conducted for this role. Please  to complete your AI screening while submitting your application.

Location: Hybrid | Downtown, Toronto

Duration: 6 Months

Our client, a leading financial institution in Downtown Toronto, is looking for a Data Engineer - Python, SQL to design, build, and optimize ETL pipelines, data structures, and data transformation frameworks. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

• Design, build, and optimize ETL pipelines, data structures, and data transformation frameworks.
• Write high quality Python code using industry best practices.
• Perform advanced SQL development for data ingestion, wrangling, and validation.
• Develop scalable, reusable data frameworks to support modeling and analytics workloads.
• Participate in code reviews and architecture discussions.
• Produce documentation, data flow diagrams, and technical architecture artifacts.
• Data side – heavy SQL;
  Software side is Python/script based

• 5+ years as a Developer / Data Engineer/ Software Engineer with end-to-end application development experience.
• 3+ years recent hands-on Python programming experience.
• Intermediate to advanced SQL, data transformation, and data manipulation skills.

• Experience with:
  Retail credit risk;
  Banking products (e.g. mortgages, credit cards) and associated data modeling experience for banking products and credit lifecycle.
• Exposure to various architecture patterns and design such as message based ETL SQL batch, real time programming, schedule-based batch.
• Proficiency with Pandas Dataframe and Numpy.
• Experience with cloud-native technologies (GCP, Google Cloud Functions, Big Query, Data Flow, Spark, Data Proc, Pub/Sub, CLI, shell scripting).
• Familiarity with Kubernetes, Docker, Terraform.
• Experience with scheduling tools like Airflow, Tidal.
• Experience with Object Oriented Design, parametrization (Jinja2).
• Experience with Python best practices and Git/Bitbucket best practices.
• Bilingual in Spanish.

• Excellent communication skills (9/10 or higher).
• Strong analytical ability; able to approach problems from multiple angles.
• Highly collaborative team player.
• Detail oriented with strong documentation discipline.
• Persistence, grit, and ability to handle challenging, fast paced work.

• Bachelor’s in Computer Science, Computer Engineering, MIS, or related field.

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 $60/hr - $78/hr 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.