Senior Data Engineer

Senior Data Engineer  

Remote Canada | Full Time 

Salary Range: $120,000 - $150,000 CAD annually  

Zonda is redefining the future of housing. We are perfectly placed in the heart of the fast-growing real estate industry. We are making big bets on the future of real-estate, trailblazing a 2030 vision for the industry. Here at Zonda, you’ll be able to use your passion and curiosity to drive the next generation of real estate analysts, advisors, and technologists.   

Zonda is looking for a passionate Senior Data Engineer to evolve and expand our team. Zonda looks for people who can grow, think, dream, and create. When you join our team, you’ll be in a unique position to make a positive impact with every project. You’ll use your full range of skills to build great experiences and learn about the real estate industry, economics, and data. You’ll be supported with the necessary tools, and you'll be working with an awesome and like-minded team. Our teams are innovative, diverse, multidisciplinary, and collaborative - all working to build the future of housing. 

As a Senior Data Engineer, you will play a crucial role in designing, implementing, and optimizing our data infrastructure. You will be embedded in an application scrum team working on a large-scale application. Your expertise in SQL Server query optimization, Snowflake, and performance tuning will be instrumental in ensuring the efficiency and reliability of our data systems. 

What You’ll Do 

Data Pipeline Processes:  

• Design, implement, and maintain data pipeline processes for efficient data extraction, transformation, and loading. 
• Collaborate with cross-functional teams to integrate data from various sources into target databases.

Database Design and Development:  

• Design and implement robust, scalable, and performance-optimized database solutions using SQL Server and Snowflake. 
• Develop and maintain database procedures, schemas, tables, indexes, and views to support application requirements. 

Query Optimization:  

• Analyze and optimize SQL queries for maximum efficiency and performance. 
• Identify and resolve performance bottlenecks in database systems through the use of query plans.
• Collaborate with application developers to enhance query performance and database responsiveness. 

Data Modeling:  

• Work closely with data engineering to design and implement data models that align with business requirements. 
• Ensure data integrity and consistency across the database environment. 

Monitoring and Maintenance:  

• Implement effective monitoring solutions to proactively identify and address potential issues. 
• Perform routine maintenance tasks such as backups, restores, data purges, and index de-fragmentation. 
• Experience with Unix and Powershell scripting technologies

Collaboration and Documentation:  

• Collaborate with cross-functional teams, including data scientists, product analysts, and application developers, to understand data requirements. 
• Participate in architectural discussions and technical decision-making processes. 
• Effectively communicate technical concepts to non-technical stakeholders. 
• Document database design, configurations, and procedures. 

Who You Are 

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Data Engineer with a focus on building efficient data pipelines and Data Warehouses using Snowflake. 
• Experience with ETL tools and processes (eg. Airflow, AWS Glue/Spark, EMR, SSIS, DBT).
• Experience with cloud technologies (S3, EC2, Linux)
• In-depth knowledge of database design, query optimization, and performance tuning. 
• Proficiency in writing complex SQL queries and stored procedures. 
• Experience with database scalability and writing deep queries accessing large datasets 

• Experience with GitHub and CICD systems
• Experience with database security best practices. 
• Experience with modern big data frameworks.
• Experience with Python.
• Excellent problem-solving and analytical skills. 
• Effective and proactive communication skills and ability to work collaboratively in a team environment. 

Preferred Skills:  

• Knowledge of cloud-based database solutions (e.g., Amazon RDS (SQL Server), Azure SQL Database).
• Experience with Apache Airflow or Astronomer
• Experience with other database technologies (PostgreSQL, CitusData).
• Experience building data pipelines that utilize Kinesis and Lambda functions
• Certification in Data Engineering or related technologies. 
• Experience with Geo Spatial data and queries is a plus

Why People Love Working Here   

• We offer meaningful work and opportunities for career growth 
• Competitive Salary  
• 100% paid by Zonda health benefit package
• 100% Company paid Life Insurance coverage 
• Paid vacation and general holidays  
• Employee Assistance Program (EAP) 
• Live Meditation Sessions 
• Employee Recognition Platform  
• Virtual Wellness Program    
• 100% Hybrid – and always will be!  
• Visionary Leadership Team 

Inclusion & Equal Opportunity Employment  

Zonda (formerly Hanley Wood | Meyers Research) is proud to be an Equal Opportunity Employer committed to diversity, inclusion & belonging. Here at Zonda, we are interested in every qualified candidate who is eligible to work in Canada.