The Data Engineer will develop and optimize data infrastructure, maintaining data pipelines and ETL processes using Snowflake and AWS, while collaborating with stakeholders to ensure data quality and compliance.
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
RPS Real Property Solutions is an employment equity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. If you should require accommodation during the interview process, please contact Human Resources at [email protected]
Top Skills
AWS
Docker
Git
Linux/Unix
Power BI
Python
Snowflake
SQL
Tableau
RPS Real Property Solutions Toronto, Ontario, CAN Office
468 King St W, Toronto, Ontario, Canada, M5V 1L8
Similar Jobs
Food • Retail • Agriculture • Manufacturing
The Principal Data Engineer will lead global Master Data Management initiatives, ensuring data quality, implementing governance strategies, and analyzing data issues while building scalable solutions for enterprise data.
Top Skills:
APIsCds ViewsData CatalogData GovernanceData ManagementData QualityIdocsMdmOdpPimSap S/4HanaSlt
Artificial Intelligence • HR Tech • Information Technology • Machine Learning • Software • App development • Industrial
The Senior Data Engineer will develop and maintain data platforms on Google Cloud, optimize data pipelines, and support Data Science teams in model training and analytics, collaborating closely across departments.
Top Skills:
BigQueryCloud RunDagsterDockerEcsGoogle Cloud PlatformKubernetesPostgresPythonSQLTerraform
Cloud • Information Technology • Software
The Data Engineer will design and manage data pipelines and architectures, ensuring data quality and security while collaborating with cross-functional teams for effective analytics and reporting.
Top Skills:
AirflowAWSAzureAzure DevopsBigQueryDatabricksDbtDelta LakeGCPGithub ActionsJavaJenkinsPythonRedshiftScalaSnowflakeSparkSQL
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
