Senior Analytics Engineer: Data Modeling & Transformation

ZEBEDEE; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

ZEBEDEE is seeking a Senior Analytics Engineer to build the modeling layer that powers the business. You will own the transformation layer as we deploy dbt on a new data warehouse and design trustworthy models for finance, compliance, and product.

You will translate ambiguous questions into durable data architectures, collaborate with finance, compliance, and product, and monitor and refine models while supporting ingestion, orchestration, and warehouse configuration as needed.

Qualifications

• Ability to design dimensional models from fuzzy requirements
• Strong SQL with complex joins and window functions
• Experience with transformation frameworks (dbt preferred)
• Experience with cloud data warehouses (Redshift/Snowflake/BigQuery)
• Familiarity with orchestration engines (Airflow/Dagster/Prefect)
• Exposure to BI/visualization tools (Looker/Tableau/Metabase)
• Engineering hygiene: Git, CI/CD, tests, docs
• Platform-level infra patterns (Terraform, data lake)
• Experience with finance/payments or regulated data

Responsibilities

• Own the transformation layer with dimensional models, tests, and docs
• Turn business questions into durable models
• Partner with Finance, Compliance, and Product to define data definitions
• Monitor models and resolve issues before stakeholders notice
• Contribute to ingestion, orchestration, and warehouse configuration as needed

Skills

Modeling ownership

SQL proficiency

dbt experience

Cloud warehouse

Orchestration tools

BI visualization

Data testing

CI/CD basics

Cross-functional collab

Regulated data

Tools

N/A

Job description

ZEBEDEE is seeking a Senior Analytics Engineer to build the modeling layer that powers the business. You will own the transformation layer as we deploy dbt on a new data warehouse and design trustworthy models for finance, compliance, and product.

You will translate ambiguous questions into durable data architectures, collaborate with finance, compliance, and product, and monitor and refine models while supporting ingestion, orchestration, and warehouse configuration as needed.