Data Lake Data Engineer

Overview At E Source, we help utilities make sense of complexity in a rapidly changing landscape, and we’re looking for a Data Lake Data Engineer to help shape how that impact shows up in the world.

E Source is a research, data/analytics, and technology focused professional services firm focused exclusively on the Utility industry in North America. We help utilities target and serve their customers more effectively, enhance and optimize their grid, and leverage operating best practices and technologies to manage their business more effectively. Headquartered in Texas, we have 450+ employees across the US and Canada. Learn more at www.esource.com.

As a Data Lake Data Engineer, you’ll play a key role in designing and building the cloud data pipelines and lakehouse infrastructure that power our utility clients’ data programs, including a current 9-month engagement supporting the data lake implementation for a client located on the west coast. You’ll work closely with data scientists, analysts, BI developers, and client technical teams to deliver clean, well-structured data that fuels analytics, machine learning, and operational decisions, helping ensure our work is not only smart, but clear, relevant, and actionable. This role is ideal for someone who enjoys working at the intersection of cloud data engineering, modern lakehouse architecture, and the utility industry, brings strong judgment to complex problems, and wants to contribute to work that shapes real-world decisions in the energy industry.

Responsibilities

Design, build, and optimize ETL/ELT workflows in Databricks to ingest data from multiple sources

Implement data cleansing, enrichment, and standardization processes across batch and streaming pipelines

Build solutions for real-time analytics and ensure pipelines are scalable, performant, and fault tolerant

Optimize SQL queries, data models, and cloud resource usage across compute, storage, and networking

Design and implement data architecture across data lakes, data warehouses, and lakehouses, including partitioning, indexing, and schema design

Integrate data from diverse sources, including databases, APIs, IoT systems, and third-party platforms

Collaborate with data scientists, analysts, and BI developers to deliver clean, well-structured data, and document data assets and processes to support discoverability

Train and support core client staff who will maintain the data lake infrastructure and pipelines long-term

Qualifications

3–7+ years of experience in data engineering, cloud data platforms, or a similar role

Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field, or equivalent professional experience

Hands-on experience building data pipelines in Databricks on AWS, or a comparable cloud lakehouse platform

Strong SQL skills and proficiency in Python and/or Scala for data transformation work

Experience designing data architecture across data lakes, warehouses, or lakehouses, including partitioning, indexing, and schema design

Working knowledge of streaming frameworks such as Spark Structured Streaming or Kafka

Comfort working directly with client stakeholders and training client staff to maintain infrastructure long-term

Nice to have

Have experience working with or around utilities, energy, consulting, research, or adjacent fields

Have worked with utility industry data (meter, customer, grid, or outage data) or have familiarity with IEC CIM standards

Bring DevOps experience, including CI/CD pipelines, infrastructure-as-code (Terraform), and automated deployments

Have helped build a data platform from the ground up, not just operated an existing one

Experience and Skills to Qualify Include

3–7+ years of experience in data engineering, cloud data platforms, or a similar role

Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field, or equivalent professional experience

Hands-on experience building data pipelines in Databricks on AWS, or a comparable cloud lakehouse platform

Strong SQL skills and proficiency in Python and/or Scala for data transformation work

Experience designing data architecture across data lakes, warehouses, or lakehouses, including partitioning, indexing, and schema design

Working knowledge of streaming frameworks such as Spark Structured Streaming or Kafka

Comfort working directly with client stakeholders and training client staff to maintain infrastructure long-term

At E Source, you’ll work alongside people who are thoughtful, curious, and deeply knowledgeable about utility and energy systems. We value clarity over jargon, substance over flash, and collaboration over ego. You’ll have the opportunity to grow your skills, contribute to meaningful work, and help shape a company that plays a real role in how the energy future unfolds.

What you can expect

Excellent insurance options, including medical, dental, and vision plans; company-paid life insurance; company-paid long- and short-term disability insurance; medical and dependent-care flexible spending plans, and paid parental leave.

A flexible time off (FTO) policy that provides paid time away from work, approved by your manager, while ensuring business needs, workload commitments, and appropriate coverage are maintained.

A 401(k) plan with a 3% employer match.

The budgeted salary for this position is $115,000–$145,000 USD + annual bonus. Actual pay will be adjusted based on experience.

This role will be remote, with minimal travel expected.

Applicants must be authorized to work for any employer in the US. We’re unable to sponsor or take over sponsorship of employment visas at this time.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Employees of E Source are encouraged to apply. To foster a positive work environment and company culture, we support our employees in their career growth at E Source. If you are interested in similar job opportunities in the future, visit the E Source careers page for a listing of all open positions and contact Human Resources.

We contact applicants directly via email using only our designated company email addresses with the domain of esource.com. Please do not provide personal information to anyone over email and be wary of other accounts impersonating businesses.

#LI-Remote

#J-18808-Ljbffr