Your impact
Here's what you will be doing
- Design, implement, and maintain SQL databases for CMMS and asset management applications.
- Conduct regular database maintenance, including backups, updates, and performance tuning.
- Troubleshoot and resolve database issues to ensure optimal performance and reliability.
- Assist in database schema design and data modeling.
- Administer GIS systems and ensure data accuracy and integrity.
- Configure and maintain GIS software and databases, integrating them with CMMS and asset management systems.
- Perform spatial data analysis, create geospatial data visualizations, and support GIS data management.
- Conduct geospatial analysis to support asset management and maintenance decision-making.
- Utilize GIS tools to analyze spatial relationships and generate actionable insights.
- Develop and maintain geospatial data layers and maps for project and operational needs.
- Develop and maintain Python scripts for automating data processing and integration tasks.
- Write scripts to enhance the functionality of CMMS and GIS systems.
- Assist in the development of custom tools and automation solutions.
- Implement, configure, and maintain Cartegraph software for asset management.
- Provide technical support and troubleshooting for Cartegraph-related issues.
- Assist with data migration, integration, and configuration tasks involving Cartegraph.
- Document and maintain Cartegraph system configurations and customizations.
- Collaborate with project teams to ensure successful project delivery and support.
- Contribute to project documentation, including technical specifications and reports.
- Provide training and support to users as needed.
Here's what you'll need
- Bachelor’s degree in Computer Science, Geospatial Science, Information Technology, or a related field.
- Minimum of 3 years of experience in backend database management, GIS administration, geospatial analysis, Python scripting, and working with asset management software, particularly Cartegraph.
- Proficiency in SQL database design, management, and optimization.
- Experience with GIS administration and geospatial analysis using tools such as ArcGIS or QGIS.
- Strong knowledge of Python for scripting and automation.
- Hands-on experience with Cartegraph asset management software.
- Ability to work collaboratively in a team environment and support project objectives.
- Strong problem-solving skills and attention to detail.
- Excellent verbal and written communication skills.
- Ability to translate technical concepts for non-technical stakeholders.
Ideally, you will have
- Familiarity with cloud-based database and GIS solutions.
- Experience with other asset management software or GIS platforms.
- Certification in GIS, SQL, or related technologies.