Data Engineer, Finance

About Us:
Propel (TSX: PRL) is the fintech company building a new world of financial opportunity by facilitating access to credit for consumers underserved by traditional financial institutions. Through its AI-driven platform, Propel evaluates customers in a more comprehensive way than traditional credit scores can. Our revolutionary fintech platform has already helped consumers access over one million loans and lines of credit and over one billion dollars in credit.
To build a new world of opportunity we bring together the brightest talent to help us build opportunities. We are entrepreneurs and believe in measuring success through results and growing within; talent and hard work never goes unnoticed. At Propel, we are here to change the way employees, customers and shareholders succeed together.

We are a team of passionate entrepreneurs, who foster curiosity and growth in our employees. Our culture is why we’ve been so successful and why our employees choose Propel to build their careers. It’s also why we’re one of North America’s fastest growing companies and a Best Place to Work.
Join us as we change the way employees, customers and shareholders succeed together.

About You:
As a fast-growing fintech, we stay true to our startup roots. You picture yourself within a vibrant and entrepreneurial organization where your ideas will be heard, and you have an opportunity to showcase your talent. You are motivated by goals, a self-starter and like to wear multiple hats.

You are a talented professional looking for a career, not a job. Reporting to the Director, Financial Data Systems, you will be responsible for defining and maintaining Finance data architecture and data governance to support Finance’s operational processes and reporting and expand the use of data as a strategic enabler to drive business forward. This individual will build, test, and maintain tables and processes for the Finance Data team. You will participate in issue resolution for Finance processes through Database development, maintenance, continuous enhancements.

Responsibilities

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Strong analytic skills related to working with unstructured datasets
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Create and maintain optimal data pipeline (aka ETL) architecture, create reusable framework for timely data delivery
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Support analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
• Create data tools and platform for analytics team members that assist them in building and optimizing our product into an innovative industry leader
• Work with data and analytics experts to strive for greater functionality in our data systems
• A successful history of manipulating, processing and extracting value from large, disconnected datasets
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores
• Experience supporting and working with cross-functional teams in a dynamic environment

Requirements

• Must have least 5+ years of experience with relational SQL and NoSQL databases, including MS SQL, MySQL, etc.
• 2+ years of experience:
• with Snowflakes as a data engineer
• in finance domain as a data engineer
• with data pipeline and workflow management tools: Airflow, etc.
• with object-oriented/object function scripting languages: Python
• building and optimizing data/ ‘big data’ data pipelines, architectures and data sets
• performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement

Benefits to Joining Propel

• Growth and opportunity – we pride ourselves on promoting from within
• Incredible company culture
• Competitive salary and health benefits
• Comprehensive vacation package
• Group health and dental benefits
• Group RRSP program
• Support for new parents
• Diverse and inclusive workplace

Should you require accommodation throughout any stage of the recruitment and selection process, please specify your requirements when submitting your application and we will work with you to accommodate your needs.

We welcome and encourage applications from individuals from all groups, including aboriginal, women, visible minorities, and persons with disabilities, regardless of race, ethnicity, family status, national origin, age, people from gender and sexually diverse communities, and/or people with intersectional identities.
We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted. No agencies or phone calls.