Data Engineer

Data Engineer (Analytics Engineering)EKN Engineering is a fast-growing civil engineering and technology consulting company located in Irvine, CA. We are searching for a Data Engineer to join our rapidly growing organization. The ideal candidate will play a pivotal role in leveraging data to drive insights, improve decision-making processes, and enhance the performance of our engineering projects.Responsibilities:Data Modeling 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.Analytics Engineering 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.AI 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.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).Experience with data visualization tools (e.g., Power BI, Tableau) and BI concepts is a plus.Excellent problem-solving skills, analytical thinking, and attention to detail.Strong communication skills and the ability to collaborate effectively in a team environment.Nice to have: exposure to ML or LLM data workflows, and utility, energy or engineering-sector data.Why Join Us:At EKN Engineering, you'll be part of a company that values innovation and accountability and supports our employees' professional growth and personal development. Here, you'll work with teams that push the boundaries of engineering to create solutions that enhance our communities and the environment by making utilities safer.Benefits & Perks: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 – We value connection and balance. Our team enjoys 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 a variety of wellness resources including discounted gym memberships through One Pass, mental health and self-care tools via AbleTo and Calm, and monthly rewards for healthy activities through Rally.Public Warning: Recruitment Phishing Scam Impersonating EKN EngineeringEKN Engineering has become aware of a phishing scheme targeting individuals with fraudulent interview requests and job offers. EKN's secure IT systems and private applicant information have not been compromised; scammers are impersonating EKN employees, using the company name and branding to mislead and engage potential job seekers in fake recruitment processes. Scammers might reference real job openings or describe fake opportunities that generally match individuals' professional backgrounds, with the goal of establishing communication and eventually obtaining private financial information to defraud people. The Federal Bureau of Investigation and Federal Trade Commission warn that employment scams such as this are a growing cyber threat. EKN urges anyone who is contacted about employment opportunities to exercise caution and know that: All communication from EKN Engineering will be from an EKN employee using the @ eknengineering.com email domain. We do not use third-party recruiters. EKN Engineering recruiters will only schedule interviews for candidates who have applied for a position through our secure portal. No corporate or IT systems at EKN are affected by this scam. The scammers are using EKN's logo and employee names to impersonate the company. You can directly contact us at View email address on click.appcast.io with any questions or concerns. EKN is committed to ensuring the safety and security of our community. We caution individuals to be vigilant in protecting personal data and vetting communication with new contacts from any company. Do not respond or provide any personal information if contacted by someone claiming to represent a company to which you did not submit a job application or profile. This scam can be perpetrated against any business and individuals who recognize and trust its name. For information on EKN recruitment practices and policies, please visit our career page or email View email address on click.appcast.io . To report a scam, visit: