Jobs search

Data Engineer

Smart Energy Water • Full-time • Irvine, CA, US • 3d ago

Data Engineer

Irvine, CA

www.sew.ai

Full time permanent

Company Overview

SEW, with its innovative and industry-leading cloud platforms, delivers the best Digital Customer Experiences (CX) and Workforce Experiences (WX), powered by AI, ML, and IoT Analytics to global energy, water, and gas providers. At SEW, the vision is to Engage, Empower, and Educate billions of people to save energy and water. We partner with businesses to deliver platforms that are easy-to-use, integrate seamlessly, and help build a strong technological foundation that allows them to become future ready.

Searching for your dream job? We are a true global company that values building meaningful relationships and maintaining a passionate work environment while fostering innovation and creativity. At SEW, we firmly believe that everyone contributes to our success, and in return, we provide opportunities for them to learn new skills and build a rewarding professional career.

Who we are looking

We are seeking a highly skilled Data Engineer – Technical Lead to join our product engineering team in the Utility domain. The role involves leading the data engineering efforts for our enterprise-grade software product, which integrates with multiple external systems (CIS, Billing, Outage Management, Notification vendors, etc.). The candidate will play a key role in data integration, ingestion, mapping, database optimization, and ETL process management across a multi-database environment.

Responsibilities:

Lead the design, development, and optimization of data integration workflows between the core product and external enterprise systems.
Manage and enhance ETL processes built on Python and Talend, ensuring scalability and efficiency for high-volume data operations.
Oversee data modeling, data mapping, and ingestion from heterogeneous sources including PostgreSQL, SQL Server, and MongoDB.
Architect, develop, validate and communicate Business Intelligence (BI) solutions like dashboards, reports, KPIs, instrumentation, and alert tools.
Define data architecture requirements for cross-product integration within and across cloud-based platforms.
Analyze, architect, develop, validate and support integrating data into the SEW platform from external data source; Files (XML, CSV, XLS, etc.), APIs (REST, SOAP), RDBMS.
Effectively translate data modeling and BI requirements into the design process.
Drive data quality, consistency, and governance standards within the product ecosystem.
Collaborate with product managers, architects, and implementation teams to ensure smooth product deployments for global clients.
Provide technical leadership and mentoring to junior data engineers.
Troubleshoot and resolve complex data pipeline and system integration issues.
Support process automation and monitoring for ETL and data flows to achieve operational efficiency.

Required Skills:

6–10 years of experience in data engineering, ETL, and database development.
Strong expertise in PostgreSQL, SQL Server, and MongoDB (query optimization, indexing, partitioning, schema design).
Onsite interviews are required for this role
Proven experience with ETL frameworks, specifically Talend and Python-based pipelines.
Hands-on experience in data integration across enterprise systems.
Strong understanding of data ingestion, data mapping, and data transformation workflows.
Expertise in high-volume data operations (batch & real-time).
Solid knowledge of data modeling, data governance, and performance tuning.
Familiarity with APIs, messaging systems, and integration patterns.
Strong problem-solving skills and ability to work in a fast-paced product environment.
Excellent communication, stakeholder management, and leadership skills.

*SEW is proud to be an equal opportunity employer. We celebrate diversity and we are committed to creating an inclusive environment for all employees.