Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Data Engineer developing data infrastructure for Canada's leading provider of outsourced real estate solutions. Focusing on data pipelines, ETL processes, and collaboration with BI teams.

Responsibilities

  • 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

Requirements

  • 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

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$65,700 - CA$98,500 per year

Degree requirement

Bachelor's Degree

Tech skills

Amazon RedshiftAWSETLPandasPySparkPythonSQLTableau

Location requirements

HybridTorontoCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.