Data Engineer

Requisition ID:

108607

Share Our Purpose. Be Yourself. Feel Valued.

People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages focus on key areas such as health & wellness, emotional & well-being, and savings for current & future goals.

We are

Beautifully Different

. We strongly believe having diversity across our company makes us more successful and helps us provide essential services to our customers. We are stronger because we embrace different ideas, viewpoints, experiences, and backgrounds. American Water is the best choice for your next role! Click here for more information on our inclusion, diversity, and equity journey.

About American Water

American Water (NYSE: AWK) is the largest regulated water and wastewater utility company in the United States. With a history dating back to 1886, We Keep Life Flowing® by providing safe, clean, reliable and affordable drinking water and wastewater services to more than 14 million people across 14 regulated jurisdictions and 18 military installations. American Water’s 6,500 talented professionals leverage their significant expertise and the company’s national size and scale to achieve excellent outcomes for the benefit of customers, employees, investors and other stakeholders.

As one of the fastest growing utilities in the U.S., American Water expects to invest $40 to $42 billion in infrastructure repairs and replacement, system resiliency and regulated acquisitions over the next 10 years. The company has a long-standing history of executing its core operations, aligned with sustainable best practices, through its commitments to safety, affordability, customer service, protecting the environment, an inclusive workforce and strengthening communities.

American Water has been recognized on the 2023 Bloomberg Gender-Equality Index for the fifth consecutive year, ranked 18th on Barron’s 100 Most Sustainable U.S. Companies 2023 List, earned the U.S. Department of Homeland Security SAFETY Act designation and U.S. Environmental Protection Agency’s WaterSense® Excellence Award, among additional state, local and national recognitions.

For more information, visit amwater.com and join American Water on LinkedIn , Facebook , Twitter and Instagram .

Job Information

Salary Range: $68,640 - $90,060

The base salary range represents a good faith salary range for this position. This position is eligible for annual incentive pay and has the opportunity for continued salary growth. If you are hired at American Water your base salary compensation will be determined based on factors such as market, geography, skills, education and/or experience. At American Water, we are committed to pay equity. In addition to compensation, you will be offered a comprehensive benefits package including 401(k),Defined Contribution Plan, Employee Stock Purchase Plan, medical, prescription, dental and vision coverage, plus disability, paid time off, life insurance, voluntary benefits, health and wellness programs and much more!

Primary Role

The GIS Software/Data Engineer is responsible for the development and technical support of Geographic Information Systems at American Water. They support the entire GIS technology stack including databases, backend processes, API servers, integrations, web hosting, frontend UIs, and more. They work directly with business stakeholders to implement new products. They develop scripts and applications to maintain existing systems and products. They have a strong understanding of IT methodologies and can provide technology guidance for how GIS software is implemented across the business. They take a holistic approach to software development and are directly involved with application design, software architecture, user adoption, and more. They have a strong background in data engineering and are familiar with the implementation and optimization of summarizations, filters, joins, and more complex analytics.

Key Accountabilities

- Build extract, transform, and load (ETL) pipelines for batch processing, integrations, and complex analytical modeling.

- Develop backend processes to support REST APIs used in web mapping applications

- Write and maintain Python libraries that support the overall GIS IT infrastructure such as database maintenance, code deployment, software management, etc.

- Design and implement large-scale spatial analysis models for optimizing utility operations, assessing metrics for data quality, building datasets for regulatory reporting, etc.

- Write scripts that automate the administration of ArcGIS Enterprise software including Enterprise Geodatabases, ArcGIS Server, ArcGIS Online, etc.

- Collaborate with other domains in IT to implement other technologies that interact with GIS.

- Engage closely with product owners to design and deploy GIS applications.

- Develop the ability to serve as a technology expert to provide guidance on GIS software architecture design and roadmaps for future implementations.

- Prepare technical documentation and diagrams for application and technology pipelines.

- Travel up to 10% for company and industry conferences.

Knowledge/Skills

- Strong programming skills with Python.

- Strong understanding of data engineering principles.

- Experience with object-oriented programming.

- Experience with relational databases such as Microsoft SQL Server.

- Experience with Amazon Web Services or similar cloud platforms.

- Experience with software development methodologies and version control tools like Git.

- Familiarity with ESRI libraries such as ArcPy and Arcade.

- Familiarity with ArcGIS Enterprise tools such as ArcGIS Server, ArcGIS Online, etc.

- Knowledge of water and wastewater utility operations preferred.

- Strong verbal and written communication skills and ability to engage with stakeholders in a professional manner.

- Strong problem solving and analytical skills.

Experience/Education

- 1 to 3 years of professional programming experience (including internships), preferably in data engineering

- BS/MS in Computer Science, Information Technology, Computer Engineering, Geographic Information Systems, Geography or related field of Engineering preferred, or equivalent experience

Competencies

Champions safety

Customer obsessed

Cultivates innovation

Nimble learning

Drives Results

Collaborates

Join American Water... We Keep Life Flowing

™

American Water is firmly committed to Equal Employment Opportunity (EEO) and prohibits employment discrimination for employees and applicants based on his or her age, race, color, pregnancy, gender, gender identity, sexual orientation, national origin, religion, marital status, citizenship, or because they are an individual with a disability, protected veteran or other status protected by federal, state, and local laws.