Data Engineer I: AI-Ready Pipelines & Analytics

EKN Engineering; Irvine (CA); On-site; USD 110,000 - 165,000; Full time

Benefits offered by this job

100% Company-Paid Medical, Dental, Vis

401(k) with Company Match

Flexible Spending Account (FSA)

Exclusive Employee Discounts

Monthly Catered Lunches & Daily Office

Employee Engagement & Wellness

JOYA Health Membership

Wellness Perks & Support Programs

Job summary

EKN Engineering in Irvine, CA is seeking a Data Engineer to join our growing civil engineering and technology consulting team. You will design and own data models, build robust data pipelines, and support AI-ready data for ML and LLM tooling.

The role focuses on governance, scalability, and collaboration with analysts and engineers to drive data-backed insights for engineering projects. You will work with modern tools (dbt, SQLMesh) and BI platforms (Power BI, Tableau) while promoting CI/CD and

Qualifications

• Bachelor's degree or higher in a related field.
• Experience designing and optimizing data pipelines with modern tools.
• Strong Python coding skills and maintainable code.
• Proficiency in SQL with relational and NoSQL databases.
• Cloud experience with AWS or Azure and relevant services.
• Experience with BI tools and data visualization concepts.
• Excellent problem-solving and collaboration skills.

Responsibilities

• Design and own dimensional and domain data models for reporting and analytics.
• Define shared metrics and entities for dashboards and models.
• Partner with analysts and developers to translate processes into durable schemas.
• Build and maintain a tested transformation layer (dbt, SQLMesh).
• Introduce CI/CD, testing, and data contracts in analytics code.
• Support semantic layer feeding Power BI for trusted datasets.

Skills

Data Modeling

SQL

Python

ETL

Data Pipelines

Analytical thinking

Communication

BI concepts

Education

Bachelor's degree in CS/Engineering

Tools

Airflow

dbt

SQLMesh

Power BI

Tableau

PostgreSQL

Azure

Amazon S3

Redshift

Job description

EKN Engineering in Irvine, CA is seeking a Data Engineer to join our growing civil engineering and technology consulting team. You will design and own data models, build robust data pipelines, and support AI-ready data for ML and LLM tooling.

The role focuses on governance, scalability, and collaboration with analysts and engineers to drive data-backed insights for engineering projects. You will work with modern tools (dbt, SQLMesh) and BI platforms (Power BI, Tableau) while promoting CI/CD and