About RPS Real Property Solutions

We are Canada’s leading provider of outsourced real estate solutions including property valuations, business intelligence and mortgage-related services. We partner with financial institutions, mortgage professionals, real estate professionals, government agencies and economic research firms, providing data-driven risk management tools, market trends and insights, and consulting services help them make informed decisions with confidence.

Our obsession with providing exceptional service to our clients allows us to build long-term, trusted relationships and to deliver the most innovative and effective residential real estate solutions in the market.

Our team is united by a shared set of values:
·       We’re Client Obsessed
·       We Love Innovation, But Worship Execution
·       We Believe Simplicity Is Genius
·       We Own What We Do
·       We’re Guided by True North
·       We Care Personally, Challenge Directly


Value & Overview of the Role:

We are seeking an experienced Data Engineer to join our team and drive the development and optimization of our data infrastructure. The ideal candidate will have a strong technical background in modern data platforms and programming, with experience or familiarity in the appraisal industry being a significant advantage.

Accountabilities:

Design, develop, and maintain scalable data pipelines and ETL/ELT processes using Snowflake and AWS services

Build and optimize data models, schemas, and warehouse architecture in Snowflake

Develop data integration solutions to consolidate data from multiple sources into our data lake and warehouse

Write efficient, maintainable Python scripts for data processing, transformation, and automation

Create complex SQL queries for data extraction, analysis, and reporting

Design and maintain data sources for Power BI and Tableau dashboards and reports

Collaborate with data analysts, business stakeholders, and BI teams to understand data requirements and optimize data delivery

Monitor and optimize data pipeline performance, troubleshoot issues, and ensure data quality.

Implement data governance and security best practices

Document data processes, workflows, and technical specifications

Required Qualifications:

3+ years of experience as a Data Engineer or similar role

Strong hands-on experience with Snowflake (data warehousing, SQL optimization, stored procedures)

Proficiency in AWS services (S3, Lambda, Glue, Redshift, EMR, or similar)

Advanced SQL skills with experience in query optimization and performance tuning

Strong Python programming skills for data engineering tasks (pandas, PySpark, or similar libraries)

Experience building and maintaining ETL/ELT pipelines

Familiarity with Power BI and Tableau, including creating data connections and optimizing data models for BI tools

Understanding of data modeling concepts (star schema, snowflake schema, dimensional modeling)

Knowledge of version control systems (Git)

Strong problem-solving abilities and attention to detail

Preferred Qualifications:

Experience or familiarity with the appraisal industry, real estate valuation, or property data

Experience building semantic models/datasets for Power BI or data sources for Tableau

Knowledge of data orchestration tools (Airflow, dbt, or similar)

Experience with CI/CD pipelines and infrastructure as code (Terraform, CloudFormation)

Understanding BI best practices and dashboard performance optimization

Understanding of data governance and compliance requirements

Bachelor’s degree in computer science, Information Systems, or related field

Technical Skills:

Cloud Platforms: AWS (S3, Lambda, Glue, EC2, RDS, etc.)

Data Warehousing: Snowflake

Programming: Python, SQL

BI Tools: Power BI, Tableau

Tools & Technologies: Git, Docker, Linux/Unix

Data Processing: ETL/ELT frameworks, batch and stream processing