Data Lake Data Engineer at E Source

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 [Upgrade to PRO to see link] 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 of ours 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. In this role, you will: - 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 You’re likely a great fit if you: - Are comfortable navigating ambiguity and making thoughtful architectural tradeoffs - Can translate business problems into scalable technical solutions - Communicate clearly with both technical and non-technical audiences - Care about data quality, reliability, and long-term maintainability - Enjoy working hands-on across the full data lifecycle, from ingestion to delivery And even better if you: - 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 [Upgrade to PRO to see link] Please do not provide personal information to anyone over email and be wary of other accounts impersonating businesses. #LI-Remote