Lead Data Engineer

  • Montreal, QC, Canada
  • Full-time

Company Description

About the company:

Thinking Capital is the leader in the Canadian Alternative Lending space, leveraging technology to be at the forefront of the FinTech industry. Since 2006, they have helped more than 10,000 small-to-medium sized Canadian businesses reach their full potential. By combining their people and technology, Thinking Capital is transforming the way business owners get the capital they need to grow. For more information, visit thinkingcapital.ca 

Job Description

Your role:

The Date Engineer is responsible for building and maintaining data pipelines across the organization and using various technologies to shape and deliver business data to the Thinking Capital users. As part of the BI team, the Data Engineer is responsible for (1) helping define the technology stack that delivers data to internal consumers building and updating the underlying data infrastructure and data transformation processes, while maintaining data accuracy and availability.


Your tasks:

  • Help develop and maintain data models, data architecture, data management standards and conventions, data element naming standards, and metadata standards for the business;
  • Development and maintenance of ETL process, code and packages to capture, load, and maintain databases on multiple environments;
  • Apply data modeling, data design and implementation to support business requirements and drive the organization forward;
  • Perform extensive analysis of database entities, relationships and attributes;
  • Creation and maintenance of technical documentation specifically, data dictionaries, ERDs, user-manuals;
  • Diagnose and resolve any data and performance issues, ensure all database systems meet business and performance requirements;
  • Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort for user stories, and participate in sprint reviews;
  • Work closely with front and backend developers to define database interface, model and engineer solutions that are performant and maintainable;
  • Diagnose and correct database process failure conditions, escalating problems as appropriate;
  • Work with other members of the Technology team to contribute to the implementation of new data systems;
  • Support the development life cycle from requirements to deployment.

Qualifications

Apply if you have the following skillset:

  • 5+ years of experience in database development and implementation, with significant experience in designing and developing a complex data pipelines for multiple use cases (analytical, operational, API ...);
  • Strong knowledge of Structured Query Language (SQL);
  • Strong experience in data pipeline solutions development and implementation;
  • Strong knowledge cloud technologies (AWS, Docker, ...);
  • Dev Ops experience an asset;
  • Good programming skills (e.g. Python, Javascript) an asset;
  • Good programming discipline (documentation, requirements/specs, testing...);
  • Ability to work autonomously; and comfortable working within a team environment;
  • Good verbal and communication skills, comfortable engaging business users;
  • Bilingual (spoken and written) in French and English;
  • ntellectual curiosity, passion for problem-solving, and comfort with ambiguity;
  • Comfortable working in an extremely fast paced environment.

Additional Information

 

Why work for Thinking Capital:

  • Great Team:
    Surround yourself with high-performing, energetic and passionate group of people dedicated to the Thinking Capital Mission;
  • FinTech Revolution:
    Be part of a team that is revolutionizing the financial system and redefining how Canadian small businesses access capital;
  • Our Stack:
    Our backend is a sophisticated service oriented architecture developed mostly in Java with a Spring framework. On the frontend side, our application is developed on an AngularJS framework. We use Git in coordination with the best DevOps practices for Continuous Integration and Deployment to our AWS cloud infrastructure.
  • Fast-Paced Environment:
    Take on complex projects in a start-up like collaborative environment;
  • Amazing Culture:
    Amazing work spaces, advanced technology tools, subsidized lunches, Foosball table, super fun work events (Amazing Race, Murder mystery wine and cheeses, Wacky Olympics, Casino nights and legendary holiday parties and more). Take a look!
  • Thinking Capital Academy:
    Get the opportunity to grow and advance in the company through continuous professional training;
  • Diverse Team:
    Join an “at-will” equal opportunity team that prides itself on it's diversity and harmony;