American Waterworks
Data Engineer
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
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