Data Engineer I

EKN Engineering is hiring a Data Engineer to build and govern data models, analytics transformation layers, and trusted datasets. The role also prepares data for AI and supports ML and LLM pipelines and validation.

Responsibilities

Design and own dimensional and domain-oriented data models that serve as the governed source for reporting, analytics and data science

Define and document shared business metrics and entities so every dashboard and model operates and is communicated with fidelity

Partner with analysts, software developers and domain experts to translate business processes into durable schemas that can evolve and scale while maintaining downstream users

Build and maintain a tested, version-controlled transformation layer (dbt, SQLMesh or equivalent), including tests, documentation and lineage

Apply software engineering practices to analytics code: code reviews, CI/CD, environments and data contracts as both data producer and consumer

Support semantic layer feeding Power BI, moving analysts to trusted datasets instead of one-off extracts/exports

Prepare AI-ready data: clean, well-documented, well-governed datasets and metadata that ML models and LLM tools can use reliably

Build and support pipelines for ML features, retrieval, and unstructured sources like documents and field reports

Audit AI-generated code, data transformations and technical logic to ensure adherence to compliance standards, performance standards and business requirements

Design and execute programmatic validation frameworks to test, audit and benchmark LLM outputs

Preferred

Experience with data visualization tools (e.g., Power BI, Tableau) and BI concepts

exposure to ML or LLM data workflows, and utility, energy or engineering-sector data

Data Visualization

Power BI

Tableau

Business Intelligence Concepts

Machine Learning Data Workflows

LLM Data Workflows

Utility-Sector Data

Energy-Sector Data

Engineering-Sector Data

Benefits

100% Company-Paid Medical, Dental, Vision, and Life Insurance – Comprehensive coverage to support your health and well-being.

401(k) with Company Match – We invest in your future with a dollar-for-dollar match on contributions.

Flexible Spending Account (FSA) – Set aside pre-tax dollars for qualified healthcare and dependent care expenses.

Exclusive Employee Discounts – Access our BenefitsHub for savings on travel, rental cars, hotels, theme parks, and more.

Monthly Catered Lunches & Daily Office Snacks – Enjoy a well-stocked kitchen and regular team meals to keep you fueled throughout the day.

Employee Engagement & Wellness – A variety of events and activities throughout the year, including hiking outings, summer BBQs, sports games, holiday celebrations, and dedicated team-building days.

JOYA Health Membership – Access to over $1,000 in annual skin health and wellness benefits, including complimentary facials or peels, aesthetic service credits, priority skin cancer screenings, teledermatology services, and discounts on skincare products.

Wellness Perks & Support Programs – Access discounted gym memberships through One Pass, mental health and self-care tools via AbleTo and Calm, and monthly rewards for healthy activities through Rally.

Company

Engineering and workflow software for utility operations

Irvine, California, USA

https://www.eknengineering.com/

Founded in 1990

51-200 employees

Qualifications

Bachelor's degree or higher in Computer Science, Engineering, or a related field

Proven experience in designing, building, and optimizing data pipelines and ETL processes using modern tools and frameworks (e.g. Airflow, dbt, SQLMesh)

Strong programming skills in Python, with experience in developing efficient, maintainable code

Proficiency in SQL and experience working with relational and NoSQL databases (e.g., PostgreSQL, Azure)

Familiarity with cloud platforms such as AWS or Azure, and hands-on experience with relevant services (e.g., S3, EC2, Redshift)

Excellent problem-solving skills, analytical thinking, and attention to detail

Strong communication skills and the ability to collaborate effectively in a team environment

Experience with data visualization tools (e.g., Power BI, Tableau) and BI concepts

Exposure to ML or LLM data workflows, and utility, energy or engineering-sector data

Required skills

Data Pipelines and ETL, Python, SQL, Apache Airflow, dbt, SQLMesh, PostgreSQL, AWS, Microsoft Azure, Amazon S3, Amazon Redshift, Power BI

Experience

Mid level