Senior Database Java Developer

Alertdriving; Toronto; On-site; CAD 130,000 - 150,000; Full time

Job summary

PureFacts is hiring a Data Engineer to build and optimize our data pipelines and infrastructure. You will work with data scientists and engineers to ensure reliable data flow using Snowflake, Azure, and DBT. You will contribute to data modeling, governance, and documentation in a collaborative environment.

The role emphasizes hands-on data engineering, pipeline monitoring, and continuous improvement. Strong foundation in ETL/ELT, SQL, and cloud platforms is essential.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or related field.
• Experience with Python or Scala and data processing.
• Familiarity with ETL/ELT, data warehousing and data modeling.
• Basic SQL and relational databases knowledge.
• Exposure to Azure cloud platform preferred.
• Willingness to learn Snowflake, Azure, and DBT.
• Strong problem-solving and communication skills.

Responsibilities

• Design, develop, and maintain data pipelines using Snowflake and Azure services.
• Build and maintain data transformation logic with DBT.
• Ingest data from multiple sources into Snowflake data platform.
• Monitor data pipelines for accuracy and availability.
• Collaborate with engineers on governance, security, and performance.
• Document data models, pipelines, and processes.
• Participate in code reviews and continuous improvement.

Skills

Python/Scala

ETL/ELT concepts

SQL basics

Azure cloud

Problem solving

Collaboration

Education

Bachelor's degree in CS/Engineering/Data

Tools

Snowflake

Azure

DBT

Git

Power BI

Job description

About PureFacts

About PureFacts Financial Solutions.PureFacts is the leader in the Revenue Performance Management category for wealth and asset management firms.The PureRevenue™ Platform helps organizations maximi

PureFacts is the leader in the Revenue Performance Management category for wealth and asset management firms. The PureRevenue™ Platform helps organizations maximize revenue potential by connecting pricing, billing, compensation, advisor behavior, and AI-powered intelligence within a single Revenue Book of Record. By transforming fragmented revenue processes into a coordinated growth system, firms gain greater visibility, stronger pricing discipline, improved revenue capture, and more effective advisor alignment. The result is faster organic growth, improved profitability, and increased enterprise value. For more than 25 years, PureFacts has helped leading financial institutions turn revenue from an operational process into a strategic advantage.

At PureFacts, we are building an AI-native platform and company. We embed AI, intelligent automation, and agentic workflows across our products and operations to detect anomalies, surface insights, streamline repetitive work, and support faster, better decision-making. In a highly regulated industry, we believe AI must be practical, governed, and auditable- amplifying human expertise while helping our teams and clients focus on higher-value, strategic work.

About the role

We are looking for a Data Engineer who will play a key role in building, maintaining, and optimizing our data pipelines and infrastructure. You will work closely with data scientists, analysts, and other engineers to ensure the reliable and efficient flow of data across our systems. This role offers an opportunity to develop your skills in Snowflake, Azure, and DBT within a collaborative environment.

What you'll do

• Assist in the design, development, and maintenance of data pipelines using Snowflake and supporting Azure services (e.g., Azure Data Factory, Azure Data Lake Storage).
• Develop and maintain data transformation logic using DBT (data build tool) for data modeling and quality.
• Support the ingestion and integration of data from various sources into our Snowflake data platform.
• Monitor and troubleshoot data pipeline issues, ensuring data accuracy and availability.
• Leverage GenAI-assisted development tools to accelerate pipeline construction, code optimization, and documentation.
• Collaborate with senior engineers to implement best practices for data governance, security, and performance optimization.
• Contribute to the documentation of data models, pipelines, and processes.
• Participate in code reviews and contribute to a culture of continuous improvement.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or a related quantitative field.
• Experience with any programming language (e.g., Python, Scala).
• Familiarity with foundational data concepts (e.g., ETL/ELT, data warehousing, data modeling).
• Basic understanding of SQL and relational databases.
• Exposure to cloud platforms (preferably Azure).
• Eagerness to learn and develop skills in Snowflake, Azure, and DBT.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.

Bonus Points (Nice to Have)

• Prior experience or hands-on projects utilizing Snowflake (experience with alternative cloud data platforms is acceptable, but Snowflake is preferred).
• Hands-on experience with GenAI coding tools and agents (e.g., Cursor, Claude Code, Cortex Code) to streamline development workflows.
• Prior coursework or projects involving data engineering concepts.
• Familiarity with version control systems (e.g., Git).
• Understanding of data visualization tools (e.g., Power BI).
• Certifications related to Azure, Snowflake, or data engineering.

Use of AI in our Hiring Process

We are committed to a fair and transparent hiring process. As part of our recruitment practices, we may use artificial intelligence (AI)-based tools. Our tool is designed to assess role-related qualifications in a consistent way and is always used together with human review and decision-making. If you have any questions or concerns about the use of AI in our hiring process, or if you would prefer an alternative assessment method, please let us know and we will be happy to accommodate.

Pay Range

The pay range for this role is: 130,000 - 150,000 CAD per year (Toronto, Canada)