Data Engineer - Python, SQL

An Initial AI Screening will be conducted for this role.

Contract Duration: 6 months

Typical Day in the Role

• 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

Must-Have Skills

1. 5+ years as a Developer / Data Engineer/ Software Engineer with end-to-end application development experience.

2. 3+ years recent hands-on Python programming experience.

3. Intermediate to advanced SQL, data transformation, and data manipulation skills.

Nice-to-Have Skills

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

Soft Skills

• 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.

Education

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 C$60 – C$70/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.