Senior Data Engineer
Toronto, ON (Remote) Full Time
Salary Range : $110,000 - $125,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 and performance tuning will be instrumental in ensuring the efficiency and reliability of our data systems.
Database Design and Development :
Design and implement robust, scalable, and performance-optimized database solutions using SQL Server.
Develop and maintain database schemas, tables, indexes, and views to support application requirements.
SQL Server 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.
ETL Processes :
Design, implement, and maintain ETL processes for efficient data extraction, transformation, and loading.
Collaborate with cross-functional teams to integrate data from various sources into the SQL Server database.
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.
Qualifications :
Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience as a Data Engineer with a focus on SQL Server.
In-depth knowledge of SQL Server 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 ETL tools and processes.
Experience with database security best practices.
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, Azure SQL Database).
Experience with other database technologies (e.g., MySQL, PostgreSQL).
Certification in SQL Server or related technologies.
Experience of Geo Spatial data and queries
Why People Love Working Here
We offer meaningful work and opportunities for career growth
Interesting product roadmap with room for innovation
Competitive Salary
Employee Assistance Program (EAP)
Live Meditation Sessions
Employee Recognition Platform
Virtual Wellness Program
Visionary Leadership Team
Senior Data Engineer
Senior Data Engineer sought to design, implement, and optimize data pipelines and data warehouses, leveraging cloud technologies and data engineering tools. The Senior Data Engineer will play a pivotal role in driving data-driven decision-making at TELUS International. The ideal candidate will be a ...
Software Engineer, User Data (Intermediate/Senior)
Working with large data sets and various databases including Aerospike, Elasticsearch, Redis, ScyllaDB, Redshift, TiDB, MariaDB. Our real-time advertising bidding system handles over 3,000,000 requests per second and stores several terabytes of data every day. Very strong problem solving skills in d...
Senior Data Engineer
As a Senior Data Engineer, you will play a crucial role in designing, implementing, and optimizing our data infrastructure. Zonda is looking for a passionate Senior Data Engineer to evolve and expand our team. Work closely with data engineering to design and implement data models that align with bus...
Senior Data Scientist / Machine Learning Engineer - Search, Personalization, Ads
Our experienced data scientists and machine learning engineers are developing solutions related to discovery, ranking, search, recommendations, ads, logistics, underwriting, and more - all with the goal of helping local retail thrive. Our team already includes experienced Data Scientists and Machine...
Senior Data Engineer
Be a champion of TextNow's data ecosystem by working with data science, engineering and infrastructure to implement data strategy for governance, security, privacy, quality,and retention that will satisfy business policies and requirements. Mentor junior data engineers and promote best practices in ...
Senior Big Data Hadoop ML Engineer (GCP) - Canada
We are seeking a highly skilled and experienced Senior Big Data Engineer to join our dynamic team. This role involves working in Java, and working on Machine Learning pipelines for data collection or batch inference. Leverage GCP for scalable big data processing and storage solutions. Proven experie...
Senior/Staff Data Engineer
We're looking to add Senior and Staff Data Engineers to our data science team! This team works on solving complex problems for StackAdapt's digital advertising platform. You'll be working directly with our data scientists, data engineers, Engineering team, and CTO on building pipelines and ad optimi...
Senior Consultant/ Manager - Microsoft Azure & Microsoft Fabric Data Engineer
Hands on experience with data processing and analytics using Azure Data Factory, Azure Synapse, Azure Data Lake or Azure Databricks is a plus. Contribute to the design and development of enterprise-level data solutions, including data warehouses, data lakes, and real-time analytics platforms, using ...
Senior Data Engineer - Data Insights (Remote) (Canada)
Proven experience as a big data engineer or a similar role, with a deep understanding of big data technologies, frameworks, and best practices. Building and maintaining data infrastructure, including data lakes, data warehouses, and real-time streaming platforms. Developing and optimizing data pipel...
Data & Analytics - Senior Analytics Engineer/Analytics Engineer
As the (Senior) Analytics Engineer, you will support and enable the business, apply data modeling expertise, and become the data domain go-to person. This is a unique opportunity to join the Analytics Engineering Department, where you will transform raw data in a modern platform and create models th...