Data Engineer

Fairstone Bank • Toronto, ON

6d • CA$80,000 - CA$92,000 • Hybrid

About The Position

Fairstone Bank and its family of brands are united in delivering innovative, accessible and reliable financial solutions that enable Canadians to reach their goals. Over the years, our brand family has grown. In 2024, Home Trust Company, Home Bank and Oaken Financial became part of the Fairstone Bank family of brands, alongside Fairstone, EdenPark and Fig. Together, we are the leading alternative lending bank in Canada. We have the collective experience and expertise to better serve our customers and foster our partners’ growth. With a diverse suite of products—residential and commercial mortgages, consumer deposits and GICs, credit cards, retail and automobile financing, personal loans and digital lending—we offer financial solutions tailored to all Canadians, including newcomers, small-business owners, smart investors and savvy consumers. Backed by nearly a century of lending experience through its legacy companies, Fairstone Bank and its brand family are proud to be Canada’s leading alternative lending bank. Join Fairstone as a Data Engineer, reporting to the Senior Manager, Reporting and Analytics, and be part of our talented and growing team! The ideal candidate has experience in building and optimizing big data systems. He will work closely with our data scientists and analysts to help direct the flow of data within the pipeline and ensure consistency of data delivery and utilization across multiple projects. Work closely with other data and analytics team members to optimize the company’s data systems and pipeline architecture Design and build the infrastructure for data extraction, preparation, and loading of data from a variety of sources using technology such as SQL ,AWS, Azure, SAP, MS Dynamics, Files, Relational Database, Semi and Unstructured Data Files Build data and analytics tools that will offer deeper insight into the pipeline, allowing for critical discoveries surrounding key performance indicators and customer activity Always angle for greater efficiency across all of our company data systems.

Requirements

• Graduate degree in Computer Science, Information Systems or equivalent quantitative field and 5+ years of experience in a similar Data Engineer role.
• Experience building and optimizing ‘big data’ pipelines, architectures and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Experience working with and extracting value from large, disconnected and/or unstructured datasets
• Demonstrated ability to build processes that support data transformation, data structures, metadata, dependency and workload management
• Strong interpersonal skills and ability to project manage and work with cross-functional teams
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Strong working knowledge of Python, PySpark
• Experience with the following tools and technologies: Databricks, Azure Data Factory, DBT Cloud, Cloud Technologies and Services (Azure, AWS), PowerBI
• Relational SQL and NoSQL databases
• Data pipeline/workflow management tools

Responsibilities

• Work closely with other data and analytics team members to optimize the company’s data systems and pipeline architecture
• Design and build the infrastructure for data extraction, preparation, and loading of data from a variety of sources using technology such as SQL ,AWS, Azure, SAP, MS Dynamics, Files, Relational Database, Semi and Unstructured Data Files
• Build data and analytics tools that will offer deeper insight into the pipeline, allowing for critical discoveries surrounding key performance indicators and customer activity
• Always angle for greater efficiency across all of our company data systems.

Benefits

• Competitive base salary plus an annual incentive bonus tied to performance.
• Robust health and dental coverage through Manulife, as well as virtual healthcare through Dialogue.
• Group Retirement Savings Plan with up to 7% employer match.
• Discounts from top retailers via WorkPerks, plus location-based perks like gym memberships and Toronto Bike Share.
• Gym access at our London and Montreal offices.
• Education Assistance Program and Fairstone Academy for training and skill development.
• Parental leave top-up program to help you during life’s big moments.
• One paid volunteer day to give back to causes that matter to you.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior