ETL Engineer - Electric Power Engineers

We are designing the grid of the future! 

Be a part of an innovative team shaping the grid of the future through advanced energy intelligence. For more than half a century, Electric Power Engineers, (EPE) has partnered with power and energy clients across the globe providing consulting expertise and energy intelligence software solutions for complex engineering and grid modeling challenges. As leaders in the renewables space, we are focused on building a modern, secure, and resilient gid. Join us in making an impact on the communities we serve and the environment in which we live. Together we can transform the future of energy.

Join us in leading the change!

EPE Software team is looking for ETL Engineer. The ideal candidate will have a strong background in Extract, Transform, Load (ETL) processes, with specific expertise in ESRI, Python, and Safe FME workflows. This role requires a blend of technical proficiency and problem-solving skills to support software team ESRI Utility Network conversion workflows and client engagements.

How you can make an impact:

• Utilize ESRI tools and technologies to manage and process spatial data to support ENER-i software client and R&D engagements.
• Develop scripts and automation solutions using Python to streamline ETL workflows.
• Implement and manage data transformation workflows around ESRI Utility Network Model using Safe FME.
• Collaborate with cross-functional teams to understand data requirements and ensure efficient data flow.
• Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
• Document ETL processes and workflows for maintenance and future reference.
• Support customer data integrations and data pipelines.

Bring your passion, here's what’s needed:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3-5 years of experience in ETL development and data integration.
• Experience in ESRI tools and technologies for spatial data management.
• Strong programming skills in Python, with experience in data processing and automation.
• Experience with Safe FME workflows for data transformation and integration.
• Strong knowledge of SQL database concepts and Postgres SQL.
• Experience with data modeling tools and diagrams (ERD, Shema designs etc..).
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration abilities.
•  

Preferred Education and Experience:

• Experience with cloud-based data integration solutions.
• Experience with Dagster, DBT, AirByte, Snowflake, Clickhouse tools is a strong plus.
• Experience with Electrical Utility Industry is a plus.
• Familiarity with other programming languages such as Java or R.
• Knowledge of GIS and geospatial data principles.
• Certifications in relevant technologies (e.g., ESRI, Python, FME). 

How we support you:

• Comprehensive health and wellness benefits including medical, dental, and vision with 100% premium coverage for you.
• Generous PTO and paid holidays
• Continuous Education Benefits
• Work with industry leaders
• 401K, up to a 4% match (100% vested from day 1)
• Flexible Work including hybrid and remote possibilities based on position.

Location: This position is open to remote applicants

Travel:  Occasional travel may be needed (10% or less)

EPE is an equal opportunity/AA/Disability/Veteran employer. The EEO is the Law poster, and its supplement are available using the following links: EEOC is the Law Poster

If you are interested in applying for employment with EPE and need special assistance to apply for a posted position, please send an email to: applicationassistance@epeconsulting.com

Third-Party Recruiting Notification

EPE does not accept unsolicited resumes from third-party recruiters. Any unsolicited third-party resumes forwarded by recruiters to EPE via our career page or to any of our managers or employees will be considered public information, may be treated as a direct application from the person identified in the resume, and will not be eligible for placement fee payment to the agency. EPE will not pay a fee to a third-party recruiter or agency without a previously signed third-party agreement and has not coordinated their recruiting activity with the appropriate member of the Talent Acquisition team.