New Mexico Tech - Socorro, NM
posted about 1 month ago
We are seeking a talented Data Engineer to join our Bureau of Geology team, specifically supporting our Hydrogeology/Aquifer Mapping Program. As a Data Engineer, you will play a crucial role in designing, developing, and maintaining robust data infrastructure and pipelines that support the acquisition, integration, and analysis of geospatial and hydrogeological data. This position is essential for ensuring that our data systems are efficient, reliable, and capable of handling the complexities of geospatial data management. In this role, you will be responsible for database management, which includes maintaining, supporting, and developing improvements for subsurface databases and aquifer mapping currently using MS SQL Server, MS Access, and geospatial databases. You will optimize database performance and query efficiency by tuning SQL queries, indexing strategies, and partitioning techniques. Additionally, you will engage in database development, providing business analysis, technical design, and implementation of data management systems to support current and future challenges. This includes designing and developing data pipelines to extract, transform, and load (ETL) geospatial and hydrogeological data from various sources into our data warehouse or data lake. Furthermore, you will support backend development by contributing to the development of interactive maps, visualizations, and analytical tools for hydrogeological studies and mapping projects through the development and deployment of web APIs. Your work will directly impact the effectiveness of our Hydrogeology/Aquifer Mapping Program, enabling better decision-making and resource management based on accurate and timely data.