The Water Division of AECOM is seeking a creative, motivated, and highly talented Data Scientist II with a focus on Geographic Information Systems (GIS) for employment in our Baltimore, Maryland office. The ideal candidate will have experience in GIS and data science, demonstrating strong technical expertise and problem-solving skills. This role involves supporting engineering, modeling, and inspection teams by automating ETL processes using Python, R, and SQL programming languages. 
The responsibilities of this position include, but are not limited to:Ensure the seamless adoption of new tools and processes with minimal oversight.Create and maintain optimal data pipeline architecture; assemble large, complex data sets to meet business requirements.Identify, design, and implement process improvements, such as automating manual workflows, optimizing data delivery, and redesigning infrastructure for scalability.Maintain infrastructure for optimal extraction, transformation, and loading (ETL) of data from diverse sources using SQL and Azure ‘Big Data’ technologies for GIS consumption.Build analytics tools to provide actionable insights, improve operational efficiency, and track key business performance metrics.Develop custom tools and widgets for ArcGIS Pro and ArcGIS Enterprise.Collaborate with stakeholders to address data-related technical issues and support data infrastructure needs.