← Back to jobsJob ID col-cmv8aokib00juoz01qg365qyl

John Burns Research and ConsultingPosted 30+ days ago

Data Engineer

Full-time
Remote
3+ years
Competitive
Posted 30+ days ago

John Burns Research and Consulting (JBREC) is hiring a Data Engineer to build its governed analytics layer and implement reliable, consistent metrics for client-facing data products. The role focuses on migrating legacy SQL logic into tested and documented dbt models, maintaining semantic-layer metrics, and supporting modern data pipelines.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Build and maintain dbt models across staging, intermediate, and mart layers, following team conventions for naming, grain, and documentation
  • Migrate legacy SQL Server and T-SQL logic into dbt. Reconcile new outputs against existing ones before cutover so client-facing numbers don't move unexpectedly
  • Write tests and data contracts that catch problems before clients or analysts do
  • Document every model so its meaning, source, and owner are clear to anyone who reads it
  • Partner with research and data science to turn agreed business definitions into precise, testable implementations with explicit grain, dimensions, and calculation logic
  • Recommend how metrics should be structured and implemented, and flag inconsistencies or ambiguities in existing definitions
  • Maintain metrics in our semantic layer as the single source for client data feeds, dashboards, PDF reports, and natural-language analytics tools
  • Help retire legacy reporting by moving its metrics onto the governed layer one at a time
  • Build and maintain ingestion pipelines on our modern stack for third-party vendor data and public data such as Census releases
  • Own day-to-day reliability for those pipelines: monitoring, alerting, triage, and runbooks that let anyone on the team resolve issues
  • Work in Git with code review and CI. Review teammates' code and expect yours to be reviewed
  • Use AI coding tools effectively within our review and governance standards

Qualifications

  • This role is not eligible for visa sponsorship
  • Candidates must be authorized to work in the U.S. now and in the future without sponsorship
  • 3+ years in data engineering or analytics engineering, including at least 2 years building production dbt projects
  • Strong SQL and dimensional modeling
  • You can explain why a model has the grain it has and what breaks if it changes
  • Hands-on experience with dbt testing, documentation, and project structure at scale (dozens to hundreds of models)
  • Experience migrating legacy SQL (stored procedures, views, T-SQL) into a modern transformation layer, including validating that outputs match
  • Working Python for ingestion, automation, and tooling
  • Comfort with Git-based workflows: branches, pull requests, code review, CI
  • You document your work so others can use it without asking you

Preferred

  • Experience with a semantic layer or metric framework (dbt Semantic Layer/MetricFlow, Cube, LookML, or similar)
  • Experience supporting natural-language or AI-assisted analytics, where metric definitions must be unambiguous
  • Familiarity with Azure data services and SQL Server
  • Experience with housing, real estate, economic, or Census data (ACS, PUMS, building permits)
  • Semantic Layer Experience

Required skills

dbtSQLDimensional Modelingdbt TestingT-SQLSQL ServerPythonGitContinuous Integration (CI)AI-Assisted AnalyticsCensus Data

Full job description

John Burns Research and Consulting (JBREC) is hiring a Data Engineer to build its governed analytics layer and implement reliable, consistent metrics for client-facing data products. The role focuses on migrating legacy SQL logic into tested and documented dbt models, maintaining semantic-layer metrics, and supporting modern data pipelines.

Responsibilities

  • Build and maintain dbt models across staging, intermediate, and mart layers, following team conventions for naming, grain, and documentation
  • Migrate legacy SQL Server and T-SQL logic into dbt. Reconcile new outputs against existing ones before cutover so client-facing numbers don't move unexpectedly
  • Write tests and data contracts that catch problems before clients or analysts do
  • Document every model so its meaning, source, and owner are clear to anyone who reads it
  • Partner with research and data science to turn agreed business definitions into precise, testable implementations with explicit grain, dimensions, and calculation logic
  • Recommend how metrics should be structured and implemented, and flag inconsistencies or ambiguities in existing definitions
  • Maintain metrics in our semantic layer as the single source for client data feeds, dashboards, PDF reports, and natural-language analytics tools
  • Help retire legacy reporting by moving its metrics onto the governed layer one at a time
  • Build and maintain ingestion pipelines on our modern stack for third-party vendor data and public data such as Census releases
  • Own day-to-day reliability for those pipelines: monitoring, alerting, triage, and runbooks that let anyone on the team resolve issues
  • Work in Git with code review and CI. Review teammates' code and expect yours to be reviewed
  • Use AI coding tools effectively within our review and governance standards

Preferred

  • Experience with a semantic layer or metric framework (dbt Semantic Layer/MetricFlow, Cube, LookML, or similar)
  • Experience supporting natural-language or AI-assisted analytics, where metric definitions must be unambiguous
  • Familiarity with Azure data services and SQL Server
  • Experience with housing, real estate, economic, or Census data (ACS, PUMS, building permits)
  • Semantic Layer Experience
  • Metric Frameworks
  • dbt Semantic Layer
  • MetricFlow
  • Cube
  • LookML
  • Natural-Language Analytics
  • AI-Assisted Analytics
  • Metric Definition
  • Azure Data Services
  • SQL Server
  • Housing Data
  • Real Estate Data
  • Economic Data
  • Census Data
  • ACS Data
  • PUMS Data
  • Building Permit Data

Benefits

  • $12,500 towards comprehensive benefits, including medical, dental, vision, and prescription drug coverage, and flexible spending accounts including gym memberships and vacation assistance.
  • Company contributes 5% of salary and profit sharing to the employee’s 401(k), even if they do not contribute.
  • 30 days of Paid Time Off including 3 weeks of personal time off (PTO), 10 paid holidays, and 5 paid days for the company’s Winter Break.

Company

  • Independent research and consulting services for the US housing industry
  • Irvine, California, USA
  • https://www.realestateconsulting.com/
  • Founded in 2002
  • 51-200 employees

Qualifications

  • This role is not eligible for visa sponsorship
  • Candidates must be authorized to work in the U.S. now and in the future without sponsorship
  • 3+ years in data engineering or analytics engineering, including at least 2 years building production dbt projects
  • Strong SQL and dimensional modeling
  • You can explain why a model has the grain it has and what breaks if it changes
  • Hands-on experience with dbt testing, documentation, and project structure at scale (dozens to hundreds of models)
  • Experience migrating legacy SQL (stored procedures, views, T-SQL) into a modern transformation layer, including validating that outputs match
  • Working Python for ingestion, automation, and tooling
  • Comfort with Git-based workflows: branches, pull requests, code review, CI
  • Clear writing
  • You document your work so others can use it without asking you
  • Experience with a semantic layer or metric framework (dbt Semantic Layer/MetricFlow, Cube, LookML, or similar)
  • Experience supporting natural-language or AI-assisted analytics, where metric definitions must be unambiguous
  • Familiarity with Azure data services and SQL Server
  • Experience with housing, real estate, economic, or Census data (ACS, PUMS, building permits)
  • 3+ years in data engineering or analytics engineering, including at least 2 years building production dbt projects.

Required skills

  • dbt, SQL, Dimensional Modeling, dbt Testing, T-SQL, SQL Server, Python, Git, Continuous Integration (CI), Semantic Layer and Metric Frameworks, AI-Assisted Analytics, Census Data

Preferred skills

  • Familiarity with Azure data services and SQL Server

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 14, 2026

Work mode

Remote

Job source

Ethic Leaf recruiter

Company

John Burns Research and Consulting

Information Technology & AI

Independent research and consulting services for the US housing industry

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleGitRemote

RADAR

1d ago

New

Data Engineer

Full-timeOn-siteSunnyvale, CA$100K – $170K/yr

RADAR is hiring a Data Engineer to build and develop its analytics, machine learning, and AI capabilities.

Why similarSame roleGitPython

EXL

1d ago

New

Senior Data Engineer

Full-timeRemoteUnited StatesCompetitive

EXL is seeking a seasoned Data Engineer to join their Sports Analytics & Engineering Practice. This role is pivotal in shaping and implementing a cloud-native data ecosystem, where you will architect and build scalable data infrastructure that transforms raw…

Why similarSame roleDBTRemote

Get new Data Engineer jobs by email

Create job alert

Data Engineer

John Burns Research and Consulting · Competitive

Apply via Ethic Leaf