Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse Engineer

$90 - $125 per hour
Full-time

Mercor

About the job

Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey .

Position: Data Engineering Expert

Type: Contract

Compensation: $90–$125/hour

Location: Remote

Role Responsibilities

  • Build long-horizon pipeline tasks with deterministic rubrics to grade agent performance against verifiable ground truth.
  • Develop ETL/ELT pipelines and dbt models to produce specified output tables with incremental logic and defined watermark behavior.
  • Create Airflow/Dagster DAGs that pass test suites and data quality tests with known pass/fail cases.
  • Design warehouse schemas matching defined contracts and performance targets tied to measured query-time budgets.
  • Work independently in long focus sessions to create challenging scenarios for agent evaluation.
  • Ensure tasks have checkable answers without open-ended essays or subjective judgment calls.

Qualifications

Must-Have

  • BS or MS in CS or related field.
  • 3+ years in data engineering or analytics engineering.
  • Expertise in dbt model development , pipeline orchestration ( Airflow , Dagster , Prefect ), warehouse design ( Snowflake , BigQuery , Redshift , Databricks ), and data quality and testing.
  • Comfortable with data engineering artifacts: dbt models , DAGs , schema docs, data contracts, and test suites.
  • Clear written communication skills to articulate reasoning and encode it into deterministic rubrics.

Compensation & Legal

  • Hourly contractor
  • Strong contributors are promoted based on task quality and throughput.

Application Process (Takes 20–30 mins to complete)

  • Upload resume
  • AI interview based on your resume
  • Submit form

Resources & Support

PS: Our team reviews applications daily. Please complete your AI interview and application steps to be considered for this opportunity.

Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Data Warehouse Engineer in Toronto, ON vacancy
  •  ...in Markham, Ontario in a 33,000 square foot facility, with offices across Canada. Job Description ~ In-depth understanding with Data Warehousing/ Business Intelligence concepts from QA perspective Create and maintain complex SQL queries such as type 2 triggers, all... 
    Suggested
    Full time

    Qa Consultants

    Toronto, ON
    9 hours ago
  • $85k - $135k per year

     ..., an integration platform that connects data, systems, and workflows across complex enterprise...  ...? We are seeking a highly skilled Data Engineer II to design, build, and scale robust...  ...and implement optimized data models, warehouse schemas, and tables for analytics and reporting... 
    Suggested
    Full time

    Zafin

    Toronto, ON
    9 hours ago
  • $75k - $95k per year

     ...stakeholders across a wide range of functions to implement and solve data engineering challenges? Are you equally skilled at delivering simple...  ...work closely with business stakeholders to ensure our data warehouse is accurate, well-documented, and scalable as the business grows... 
    Suggested
    Full time
    Internship
    Work at office
    Flexible hours

    Financeit

    Toronto, ON
    9 hours ago
  •  ...intelligence. Leading infrastructure vendors, engineering firms, and construction companies use the...  ...seamlessly with CRMs, ERPs, and data lakes, embedding actionable insights directly...  ...with orchestration, data modeling, and data warehouses. You'll be responsible for designing,... 
    Suggested
    Full time
    Work at office
    Immediate start
    3 days per week

    Citylitics Inc.

    Toronto, ON
    9 hours ago
  • $100k - $125k per year

     ...and move faster. Prophix is building a data platform on Snowflake that drives revenue...  ...just tasks, and you build for the next engineer as much as yourself. You work directly with...  ...platform with real depth: multi-cluster warehouse configuration, resource monitors, query profiling... 
    Suggested
    Full time
    Internship

    Prophix

    Toronto, ON
    9 hours ago
  • $140k - $180k per year

     ...where our people are proud to Build. Better. As a Principal Data Engineering leader at RAVL, you will design, define, and elevate...  ...and governance. Integrate with cloud-native storage, data warehouses, APIs, ML platforms, vector databases, and enterprise systems... 
    Full time
    Remote work

    RAVL

    Toronto, ON
    9 hours ago
  • $145k - $185k per year

     ...Opportunity We're expanding rapidly and looking for a Senior Data Engineer to define and build the data foundation that powers Cybrid's...  ...engineer, you'll own the data platform end-to-end: pipelines, warehouse, governance, and the AI-augmented workflows it empowers. You'... 
    Long term contract
    Full time
    Flexible hours

    Cybrid Llc

    Toronto, ON
    9 hours ago
  • $100k - $130k per year

     ...career, not a job. Reporting to the Director, Data Platform, you will be responsible for...  ..., scalable Snowflake databases, schemas, warehouses, and data-sharing solutions for analytics...  ...access Partner with Finance, Data Engineering, Analytics, and application teams to resolve... 
    Full time
    Internship

    Propel Holdings Career

    Toronto, ON
    9 hours ago
  • $86k - $125k per year

     ...focused problem solvers who thrive on complex data challenges. Guided by our values of Care,...  ...for a passionate and curious Data Engineer with strong Python skills and solid experience...  ....   ~ Work with cloud-based data warehouses (e.g., Snowflake, Azure Synapse, Redshift... 
    Full time
    Work at office

    Project X

    Toronto, ON
    9 hours ago
  •  ...Description Senior AI Data Engineer – Enterprise Data Build It. Scale It. Own It. Sangoma is a global leader in business communications...  ..., transformation, and orchestration tools Modern data warehouses such as Snowflake, Redshift, or equivalent platforms Git-... 
    Long term contract
    Full time
    Work from home
    Worldwide
    Flexible hours

    Sangoma

    Toronto, ON
    9 hours ago
  • $180.2k - $233.2k per year

     ...you, join us. Imagine what we’ll build together. About the Data Engineering Team Thumbtack’s Data Engineering org is split into 3 groups...  ...build on its prior successes in building a more cohesive data warehouse while starting to work more deeply upstream to build data best... 
    Full time
    Seasonal work
    Local area

    Thumbtack

    Toronto, ON
    9 hours ago
  • $110k - $140k per year

     ...insights, treatment workflows, and longitudinal data accessible and actionable across the platform.   As the Senior Data Engineer, you’ll be part of a small team that turns...  ...performance and scalability in cloud data warehouses such as Snowflake or comparable technologies... 
    Full time
    Remote work
    Flexible hours

    Fullscript

    Toronto, ON
    9 hours ago
  •  ...the place to build your career. About the Role The Data Engineer reports to the VP of Engineering and owns the data infrastructure...  ..., build-out, and ongoing maintenance of FacilityOS's data warehouse and data lake Design and evolve schemas that support both AI... 
    Full time
    Work at office

    FacilityOS

    Toronto, ON
    9 hours ago
  •  ...is supporting this client in their search for a talented Sr. Data Engineer to help evolve their core data platform and drive impactful business...  ...- Experience building and maintaining data pipelines, warehouses, and infrastructure - Strong communication skills to convey... 
    Full time

    Rockstar

    Toronto, ON
    9 hours ago
  •  ...Staff Engineer, Data Platform About NationGraph NationGraph is building the data and intelligence layer for the public sector....  ...a traditional data engineering role focused on maintaining a warehouse or internal analytics. You’ll own the technical ecosystem that... 
    Long term contract
    Full time
    Local area

    Nationgraph

    Toronto, ON
    1 hour ago
  •  ...As Data Engineer, you will provide hands-on expertise as it relates to data management, analytics, and business intelligence. This opportunity will allow you to utilize your unique blend of technical, software and cloud engineering experience. Electric Mind, formerly Intelliware... 
    Full time

    Electric Mind

    Toronto, ON
    9 hours ago
  • $80 per hour

     ...Angelo , Larry Summers , and Jack Dorsey . Position: Data Engineer (Coding Agent Experience) Type: Contract...  ...model-generated implementations involving ETL pipelines , data warehouses , analytics platforms , and distributed data systems .... 
    Full time
    Contract work
    Summer work
    Remote work

    Mercor

    Toronto, ON
    9 hours ago
  •  ...our Universal API to access GPS data, speeding data and vehicle...  ...role We're looking for an engineer who thrives on building scalable...  ...experience (Kafka, Flink, Spark, warehouses, lakehouses), though it isn't...  ...Orchestration and workflow engines (Temporal, Step Functions).... 
    Full time
    Work at office
    Flexible hours

    Terminal

    Toronto, ON
    9 hours ago
  • $86k - $150k per year

     ...focused problem solvers who thrive on complex data challenges. Guided by our values of Care,...  ...Role Summary As a Senior Data Engineer at Project X Ltd., you will be providing...  ...performance issues in Snowflake, manage virtual warehouses, implement clustering keys, and apply... 
    Full time

    Project X

    Toronto, ON
    9 hours ago
  • $100k - $140k per year

     ...About ShyftLabs At ShyftLabs, we live and breathe data. Since 2020, we’ve been helping Fortune 500 companies unlock growth with cutting...  .... The Opportunity ShyftLabs is seeking a skilled Data Engineer to support in designing, developing, and optimizing big data solutions... 
    Full time
    Work at office
    3 days per week

    Shyftlabs

    Toronto, ON
    9 hours ago
  •  ...Company Description Are you a Data Engineer with experience building cloud-based data solutions and transforming healthcare data into actionable insights? At Spectrum Health Care (Spectrum), we're building a centralized Cloud Data Lakehouse to support clinical analytics... 
    Full time

    Spectrum Healthcare

    Toronto, ON
    9 hours ago
  •  ...Required Skills. • Strong hands-on experience with Data-bricks and Apache Spark (PySpark/Scala). • Experience in SQL and data transformation techniques. • Knowledge of ETL tools and data pipeline development. • Experience working with cloud platforms (Azure/... 
    Full time
    Manual labor

    Kumaran Systems

    Toronto, ON
    9 hours ago
  •  ...analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics...  ...consulting team in the world. We are seeking an experienced Data Engineer to join our team, specifically focused on building scalable... 
    Full time

    Tiger Analytics

    Toronto, ON
    9 hours ago
  • $100k - $150k per year

     ...re here to leave our clients better than we found them, and to create a place where our people are proud to Build. Better. As a Data Engineer at RAVL, you’ll design, build, and operate the data pipelines and platforms that power decision-making for modern organizations.... 
    Full time
    Flexible hours

    RAVL

    Toronto, ON
    9 hours ago
  • $163k - $185k per year

     ...rapid growth in the affordable eyewear space, and data is at the core of our success. We are seeking a Manager, Data Engineering with a strong technical background and deep...  ...ETL/ELT pipelines for centralized data warehouses. ~ Advanced fluency in SQL and Python, with... 
    Full time
    Manual labor
    Remote work
    Work from home
    Flexible hours

    Zenni Optical

    Toronto, ON
    1 hour ago
  •  ...service digital partner that combines Strategy, Experience & Design, Engineering and Managed Services. We build digital solutions that deliver...  ...successful digital experiences and client partnerships. As a Data Architect / Engineer, you will join a highly motivated and... 
    Long term contract
    Full time
    Immediate start

    Appnovation Technologies

    Toronto, ON
    1 hour ago
  •  .... Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%. Job Description The  Senior Data Engineer is responsible for designing, developing, and supporting databases that power a large-scale IVR and contact center platform. The role... 
    Long term contract
    Full time
    Internship
    Remote work
    Relocation

    Miratech

    Toronto, ON
    9 hours ago
  •  ...analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics...  ...best analytics global consulting team in the world. The Data Engineer will be responsible for architecting, designing, and implementing... 
    Full time
    Local area

    Tiger Analytics

    Toronto, ON
    9 hours ago
  • $110k - $125k per year

     ...the work to do what’s right, to act like an owner. We are growing a lasting legacy, where people come first. As our new Senior Data Engineer , you’ll join a growing Data & AI practice at Mark Anthony Group, working on high-impact use cases across Sales, Finance, Supply... 
    Full time
    Work at office

    Mark Anthony Group

    Toronto, ON
    9 hours ago
  •  ...focus on the conversation. All hiring decisions are made by our hiring team. About the Role This is Float's first dedicated data engineering hire. You'll own the Snowflake architecture and ingestion layer end-to-end — the plumbing that carries data from banking partners... 
    Long term contract
    Full time
    Work at office
    Immediate start

    Float

    Toronto, ON
    9 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Engineer. Be the first to apply!