Sql data analyst Jobs in Richmond Hill, ON

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 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.

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

PI7f6b4d5af7dc-30511-41623863