Jobs
>
Toronto

    Senior Data Engineer - Toronto, Canada - Zonda

    Zonda
    Default job background
    Description
    Senior Data EngineerToronto, ON | 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 datasetsExperience 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 growthInteresting product roadmap with room for innovationCompetitive SalaryEmployee Assistance Program (EAP)Live Meditation SessionsEmployee Recognition PlatformVirtual Wellness ProgramVisionary Leadership Team


    Inclusion & Equal Opportunity EmploymentZonda (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.

  • Société Financière Manuvie

    Data Engineer

    1 week ago


    Société Financière Manuvie Toronto, ON, Canada $92,190 - $171,210

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Société Financière Manuvie

    Data engineer

    3 weeks ago


    Société Financière Manuvie Toronto, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • CIBC

    Data Engineer

    3 weeks ago


    CIBC Toronto, Canada Temps plein

    Nous bâtissons une banque axée sur les relations pour un monde moderne. Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu'il faut pour nos clients. · À la Banque CIBC, nous misons sur vos forces et vos ambitions pour vous donner le pouvoir ...

  • Société Financière Manuvie

    Senior data engineer

    3 weeks ago


    Société Financière Manuvie Toronto, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...


  • Manulife Insurance Malaysia Toronto, ON, Canada $92,190 - $171,210

    time type Temps plein · posted on Publié il y a 6 jour(s) · job requisition id JR · Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiativ ...


  • Société Financière Manuvie Toronto, ON, Canada $92,190 - $171,210

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...


  • Atlantis IT group Toronto, Canada

    **AWS Cloud Data Engineer** · **Toronto, ON** · 1. Must have working knowledge in designing and implementing data pipelines on any of the cloud providers · AWS is preferred · ). Must be able to work with large volumes of data coming from various sources. Perform data cleansing, d ...


  • CIBC Toronto, Canada Temps plein

    Nous bâtissons une banque axée sur les relations pour un monde moderne. Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu'il faut pour nos clients. · À la Banque CIBC, nous misons sur vos forces et vos ambitions pour vous donner le pouvoir ...

  • CIBC

    Junior Data Engineer

    2 weeks ago


    CIBC Toronto, Canada Temps plein

    Nous bâtissons une banque axée sur les relations pour un monde moderne. Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu'il faut pour nos clients. · À la Banque CIBC, nous misons sur vos forces et vos ambitions pour vous donner le pouvoir ...


  • CIBC Toronto, Canada Temps plein

    Nous bâtissons une banque axée sur les relations pour un monde moderne. Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu'il faut pour nos clients. · À la Banque CIBC, nous misons sur vos forces et vos ambitions pour vous donner le pouvoir ...


  • Société Financière Manuvie Old Toronto, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Organigram Inc

    Data Engineer

    4 days ago


    Organigram Inc Toronto, Canada

    Description: · We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will have expertise in SQL Server, Azure Data Factory, and data ingestion architecture within the Azure Cloud environment. Additionally, familiarity with Dynamics 365 and e ...

  • Raise

    Data Engineer

    2 days ago


    Raise Toronto, Canada

    Data Engineer · Location Address: Hybrid - Toronto – 1-2 days / week (Wednesdays and Thursdays) – need candidates in GTA · Contract Duration: ASAP to Oct 31, 2024 – approx. 4 months · Possibility of extension · Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week · Reaso ...

  • Q1 Technologies, Inc.

    Data Engineer

    18 hours ago


    Q1 Technologies, Inc. Toronto, Canada

    Title: Data Engineer · Location: Toronto, ON · Type: Full-time · Job Description · 1. Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred). Must be able to work with large volumes of data coming from various so ...

  • Finance Professionals Inc.

    Data Engineer

    2 days ago


    Finance Professionals Inc. Toronto, Canada

    Typical Day in Role: · • Collaborate with business lines and other stakeholders and identify opportunities to drive business value by leveraging data engineer. · • Efficiently handle large volumes of structured and unstructured data through ingestion, modeling, transformation, an ...

  • HCLTech

    Data Engineer

    3 weeks ago


    HCLTech Toronto, Canada

    Position: Data Engineer (Data Bricks) · Location: Toronto, Ontario / Remote · Skills Requirements: JD · Data Bricks: · • Strong hands on in Pyspark and Apache Spark · • Strong hands on in Medallion architecture · • Experience in Native Spark Migration to Databricks. · • Exper ...

  • Amgine

    Data Engineer

    3 weeks ago


    Amgine Toronto, Canada

    We're a well-funded Startup that is using Ai and Automation to streamline and automate booking processes for travelers and corporate agencies. AMGiNE has disrupted the space by developing proprietary Ai capabilities to radically improve corporate agent's efficiency and greatly en ...

  • Apptoza Inc.

    Data Engineer

    3 weeks ago


    Apptoza Inc. Ontario, Canada

    Hi, · Hope you are doing well · We have a job opening for an AWS Data Engineer. · Role: AWS Data Engineer · Hybrid position · Location: Toronto, ON · Job Description: · 1. Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS ...

  • hireVouch

    Data Engineer

    5 days ago


    hireVouch Toronto, ON, Canada

    Our client is a Canadian-based international real estate investor, developer, and property manager. They are growing their team and looking for a passionate Data Engineer to join. · The Data Engineer will be responsible for building, processing, reviewing, and managing data along ...

  • Bitstrapped

    Data Engineer

    5 days ago


    Bitstrapped Toronto, Canada

    We are looking for a hands-on Senior Data Engineer in a full-time salaried position. The Data Engineer will work with our Data Services Practice and work alongside our talented cloud architects to play a key role in our delivery teams. · The Data Engineer will be involved in the ...