Lead Data Engineer: Build Data Warehouse & AI Solutions

OCVIBE; Anaheim (CA); On-site; USD 140,000 - 180,000; Full time

Job summary

OC Sports & Entertainment, LLC in California invites a Lead Data Engineer to design and govern a unified data warehouse for ticketing, loyalty, and F&B data. You will own identity resolution and drive data products that inform business decisions.

You will mentor engineers, partner with analytics and operations, and shape a scalable Azure-based data platform with dbt, Airflow, and modern governance. This role is on-site in California and offers a competitive salary.

Qualifications

• 6–9 years of hands‑on data engineering experience designing and building production‑grade systems.
• Academic background in a quantitative or technical field such as physics, mathematics, computer science, engineering, or a related field.
• Production‑grade pipeline development experience in Python and advanced SQL, with strong attention to performance, observability, and maintainability.
• Production experience with dbt, including project structure, robust test coverage, and development of reliable transformation layers that support downstream reporting and analytics.
• Production experience with Airflow or equivalent tools, such as Dagster or Prefect, including DAG design, dependency management, and failure handling at scale.
• Deep cloud data warehouse experience; Azure preferred, with strong AWS or GCP experience transferable.
• Experience building or enforcing medallion architecture in a production environment
• Experience inheriting or auditing an externally managed platform, including reviewing unfamiliar codebases and independently evaluating architectural decisions
• Experience owning engineering standards, including code review, pipeline governance, and documentation practices
• AI‑native mindset, with experience using AI‑assisted tools as a productivity multiplier

Responsibilities

• Design and build a governed data warehouse architecture that unifies ticketing, loyalty, and F&B data into a single trusted source of truth
• Own identity resolution end-to-end, including defining the entity framework, setting coverage standards, and expanding capabilities as new source systems are onboarded
• Govern the Azure data environment, including monitoring, alerting, cost controls, and consolidation into a single reliable warehouse
• Serve as the internal technical counterpart to the implementation partner by auditing the existing platform, evaluating architectural decisions, and driving toward full internal ownership
• Translate complex data architecture decisions for non-technical business partners and collaborate with analytics and operations teams to deliver data products that drive business decisions
• Mentor engineers and help build a culture of technical rigor while remaining hands‑on as a builder

Skills

Data engineering

Python

SQL

Education

Bachelor's Degree

Tools

dbt

Airflow

Dagster

Prefect

Job description

OC Sports & Entertainment, LLC in California invites a Lead Data Engineer to design and govern a unified data warehouse for ticketing, loyalty, and F&B data. You will own identity resolution and drive data products that inform business decisions.

You will mentor engineers, partner with analytics and operations, and shape a scalable Azure-based data platform with dbt, Airflow, and modern governance. This role is on-site in California and offers a competitive salary.