Analytics Engineer: Transform Data with dbt & Databricks

Jobtailor; California (MO); On-site; USD 120,000 - 170,000; Full time

Job summary

Jobtailor is hiring a senior analytics engineer to design and optimize data models and ELT pipelines using dbt on Databricks Lakehouse. You will define standards, mentor engineers, and partner with stakeholders to deliver scalable, observable data solutions.

The role emphasizes strong SQL, data governance, and the ability to translate complex concepts into actionable designs, with onsite work and occasional travel.

Qualifications

• Bachelor’s degree in a related technical field.
• 5+ years of analytics engineering or data engineering experience.
• Hands-on dbt in a modern ELT environment.
• Experience with Databricks, Spark, and Delta Lake.
• Strong SQL optimization for large-scale transformations.
• Understanding of testing, CI/CD, observability, governance.
• Ability to translate complex concepts to stakeholders.
• Willingness to travel and work onsite as needed.
• Authorized to work in the United States.

Responsibilities

• Design, develop, test, deploy, monitor, and improve data models and transformations using dbt within Databricks Lakehouse.
• Build scalable, maintainable data models, macros, testing frameworks, and automation logic.
• Translate AR workflows into technical designs and incremental deliverables with stakeholders.
• Establish analytics engineering standards, conventions, naming patterns, and testing practices.
• Participate in design sessions, spike investigations, and data architecture reviews.
• Conduct code reviews and mentor engineers through feedback.
• Troubleshoot complex data issues across ingestion, transformation, and semantic layers.
• Promote automation, observability, data quality testing, governance, and continuous improvement.
• Design and optimize Delta Lake tables and Spark workloads for performance and cost efficiency.
• Evaluate emerging tools and vendor solutions in the modern data ecosystem.
• Support AR Follow-Up transformation through datasets enabling prioritization, analysis, routing, and automation.

Skills

Dbt Expertise

Databricks Experience

Advanced SQL Skills

Data Architecture Knowledge

Analytics Engineering Standards

Education

Bachelor's degree in CS/Engineering/Math/Stats

Tools

Databricks Lakehouse

Dbt

Spark

Delta Lake

Job description

Jobtailor is hiring a senior analytics engineer to design and optimize data models and ELT pipelines using dbt on Databricks Lakehouse. You will define standards, mentor engineers, and partner with stakeholders to deliver scalable, observable data solutions.

The role emphasizes strong SQL, data governance, and the ability to translate complex concepts into actionable designs, with onsite work and occasional travel.