The ideal candidate has experience in building and optimizing big data systems and will work closely with our data engineering team and data analysts to ensure consistency of data delivery and utilization across multiple projects. 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 and AWS services. 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. Qualifications: Undergraduate degree in Computer Science, Information Systems or equivalent quantitative field . 1 years experience in a similar Data Engineer . Knowledge of AWS services. 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 would be an asset. 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. Experience with AWS Athena would be an asset. Knowledge or previous experience working with Agile Scrum teams. Knowledge/Experience with the following tools and technologies preferable: Relational SQL and NoSQL databases. Data pipeline/workflow management tools. AWS cloud services such as EC2, Lakeformation, Glue, RDS and Redshift. Object-oriented/object function scripting languages such as Python. This role is now vacant WE ARE PROUD TO BE: Montreal's Top Employers 2025 by Canada’s Top 100 Employers! Learn more: https://www.fairstone.ca/en/about/canadian-lender Follow us on LinkedIn: https://www.linkedin.com/company/fairstone/mycompany/ If you have a preferred language for communication, please kindly inform us whether you prefer French or English on your application. Fairstone is an equal opportunity employer. Accordingly, we will make reasonable accommodations to respond to the needs of people with disabilities. Individuals who view themselves as Aboriginals, members of visible minorities, and disabled are encouraged to apply in confidence. Time Type: Full time Job Type: Permanent RECOGNIZED AS ONE OF MONTREAL'S TOP EMPLOYERS (2025) Fairstone Bank of Canada and its subsidiaries, including Fairstone Financial Inc. and Home Trust Company, deliver innovative, accessible and reliable financial solutions that enable Canadians to reach their financial goals. Collectively, we offer residential and commercial mortgages, consumer deposits and GICs, retail and automobile financing, credit cards and digital lending, in addition to unsecured and secured personal loans online and at more than 255 branches coast to coast. With a long-established history, we are proud to be Canada's leading alternative lending bank. More at FairstoneBank.ca
