BI Data Engineer

2 days ago

Greater Toronto Area, Canada Paymentus Full time

Summary/Objective

Are you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700 clients.


Essential Functions/ Responsibilities

As a BI Data Engineer, you will play a pivotal role in empowering cross-functional teams to make informed, data-driven decisions. Collaborating closely with Finance, Account Management, and Sales, you'll enable these teams to access high-quality insights and generate accurate reports. Your responsibilities will include:


  • Driving Impact: Using your strong communication skills to convey analytical results in a way that inspires action and drives meaningful business change.
  • Championing Data Excellence: Advocating for data as a first-class citizen by ensuring data quality, reliability, and usability across the organization.
  • Collaboration and Peer Review: Providing constructive peer reviews and fostering a culture of continuous improvement in data deliverables.
  • Educating Stakeholders: Helping teams understand and leverage data effectively through hands-on training sessions and creating thorough, user-friendly documentation.
  • Proactive Problem-Solving: Independently identifying and proposing impactful data projects instead of solely responding to stakeholder requests.
  • Staying Ahead of the Curve: Keeping abreast of advancements in the data and analytics community, evaluating new tools and methodologies, and integrating them into your workflow when appropriate.


Education and Experience

  • BS/MS in Computer Science, or equivalent.
  • Experience with cloud-based data warehousing, transformation, and ETL tools, such as Snowflake and DBT:


  • Snowflake:
  • Develop, manage, and optimize Snowflake data pipelines to ensure reliable data ingestion and transformation processes.
  • Design and maintain Snowflake schemas, tables, and views with a focus on performance optimization and storage efficiency.
  • Implement Snowflake features such as data sharing, secure views, and time travel to support business requirements.
  • Monitor and troubleshoot performance issues within Snowflake, leveraging techniques like clustering, query tuning, and workload management.


  • DBT:
  • Build and maintain modular, well-structured dbt models that align with industry best practices and internal standards.
  • Develop robust testing frameworks using dbt to ensure the accuracy and reliability of data transformations.
  • Create reusable macros and custom packages to improve efficiency and standardization across dbt projects.
  • Maintain version control for dbt projects, managing changes systematically with tools like Git.


  • Understanding of time series and relational databases (Oracle, Snowflake, InfluxDB).
  • Oracle, MongoDB (or NoSQL generally): Be able to read and understand Oracle PL/SQL procedures and functions. Analyze unstructured and semi-structured data from NoSQL databases.
  • Tableau Dashboards: Design and deliver user-friendly dashboards and visualizations in Tableau, ensuring they align with stakeholder needs and provide actionable insights.
  • Data Governance: Implement and uphold best practices in data quality, security, and governance across all platforms.


Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, photocopiers and smartphones.


Physical Demands

This role requires sitting or standing at a computer workstation.


Position Type/Expected Hours of Work

This is a full-time position. Days and hours of work are Monday through Friday, 40 hours a week. Occasional evening and weekend work may be required as job duties demand.


Travel

No travel required for this role.


Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.


EEO Statement

Paymentus is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, sexual orientation, national origin, ancestry, citizenship status, religion, marital status, disability, military service or veteran status, genetic information, medical condition including medical characteristics, or any other classification protected by applicable federal, state, and local laws and ordinances. Our management is dedicated to ensuring the fulfillment of this policy with respect to hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment advertising, pay, and other forms of compensation, training, and general treatment during employment.


Reasonable Accommodation

Paymentus recognizes and supports its obligation to endeavor to accommodate job applicants and employees with known physical or mental disabilities who are able to perform the essential functions of the position, with or without reasonable accommodation. Paymentus will endeavor to provide reasonable accommodations to otherwise qualified job applicants and employees with known physical or mental disabilities, unless doing so would impose an undue hardship on the Company or pose a direct threat of substantial harm to the employee or others.


An applicant or employee who believes he or she needs a reasonable accommodation of a disability should discuss the need for possible accommodation with the Human Resources Department, or his or her direct supervisor.

---

***This is an existing vacancy.

  • BI Data Engineer

    2 days ago

    Greater Toronto Area, Canada Paymentus Full time

    Summary/Objective Are you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700...

  • BI Data Engineer

    2 days ago

    Greater Toronto Area, Canada Paymentus Full time

    Summary/ObjectiveAre you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700...

  • BI Data Engineer

    2 days ago

    Greater Toronto Area, Canada Paymentus Full time

    Summary/ObjectiveAre you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700...

  • BI Data Engineer

    2 days ago

    Greater Toronto Area, Canada Paymentus Full time

    Summary/Objective Are you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700 clients....

  • Sr. Software Engineer in Test

    1 week ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • BI Data Engineer

    2 days ago

    Greater Toronto Area, Canada, Ontario Paymentus Full time

    Summary/ObjectiveAre you looking to work at a high growth, innovative, and purpose driven FinTech company? If so, you’ll love Paymentus. Recognized by Deloitte as one of the fastest growing companies in North America, Paymentus is the premier provider of innovative, reliable, and secure electronic bill payment and presentment for more than 1700...

  • Sr. Software Engineer in Test

    1 week ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Sr. Software Engineer in Test

    7 days ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Sr. Software Engineer in Test

    5 days ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Sr. Software Engineer in Test

    15 hours ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Urgent: Sr. Software Engineer in Test

    19 hours ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer, and lender services. The company is comprised of AutoTrader.ca, AutoSync, and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Data Engineering Specialist for Power BI Solutions

    7 days ago

    Toronto, Ontario, Canada CAAT Pension Plan Full time

    About CAAT Pension PlanCAAT Pension Plan is a collaborative and inclusive environment that fosters open communication and creativity. We value the broadest range of experiences, geographies, gender, ethnicities, backgrounds, and perspectives as key elements of our culture.We are committed to providing a secure, valuable, and sustainable workplace retirement...

  • Sr. Data Engineer

    1 week ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Data Analytics/BI Developer

    6 days ago

    Toronto, ON, Canada Wirehead Full time

    Government Type: Contract Role: BI Report Developer Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder. Perform...

  • Data Analytics/BI Developer

    1 day ago

    Toronto, ON, Canada Wirehead Full time

    Government Type: Contract Role: BI Report Developer Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder. Perform...

  • Data Engineer

    1 day ago

    Toronto, Canada National Consultants Professionals Full time

    The Data Engineer will be responsible to build and deliver the components of an effective Data Warehouse, leveraging Azure Data Lake, Azure Synapse, Snowflake for data storage, utilising Azure Data Factory and Synapse Pipelines for data integration, Databricks for data transformation and PowerBI for end-user data analytics and reporting. This role will play...

  • Development Lead

    5 days ago

    Greater Toronto Area, Canada Innovapost Full time

    **Requisition Number**:2240 **Location**:GTA/OTT **Province**: Ontario (CA-ON) **Country**:Canada (CA) **Employment Type**: Regular **Who is Innovapost?** Great question! We are the technology arm of the Canada Post Group of Companies. This includes Canada Post, Purolator, and SCI. By joining us you will be able to make a positive impact on how every...

  • Sr. Data Engineer

    1 week ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Sr. Data Engineer

    7 days ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...

  • Sr. Data Engineer

    4 days ago

    Greater Toronto Area, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...