Lead Software Engineer

Primary Skills

• Collaborate with ESRI Solution Architect for SDE Implementation: Work closely with the ESRI solution architect to define and deliver requirements related to the GIS Spatial Database Engine (SDE). This includes creating and configuring SDE geodatabases, ensuring data integrity, and planning the migration of data to the cloud.

• Lead Data Migration Strategy and Execution: Take ownership of migrating ArcSDE databases to cloud-based environments such as SQL Server and PostgreSQL. This involves upgrading databases, managing users and versions, and ensuring seamless transition with minimal data loss or downtime.

• SQL Development and Optimization: Develop and optimize SQL queries and scripts to support geospatial data operations, transformations, and validations as part of the migration and integration process.

• Risk Mitigation and Strategic Planning: Partner with the ESRI solution architect and client teams to identify technical risks and finalize a robust data migration strategy that aligns with business goals and technical constraints.

• ETL and Interoperability Expertise: Utilize FME as an ETL tool and apply ESRI Data Interoperability (DI) techniques to facilitate efficient and accurate data migration across platforms and formats.

• Agile Delivery and Change Management: Apply Agile, Scrum, and iterative development methodologies to manage project execution. Ensure adherence to change management processes for smooth implementation and stakeholder alignment.

Secondary Skills

• Analyze, interpret, and present geospatial data to meet client-specific requirements.
• Work with managed SQL databases, geodatabases, and related objects.
• Deliver technical requirements for ESRI GIS systems and geospatial data presentation.
• Collaborate with enterprise architects, business leaders, and technical teams to develop and deploy solutions.
• Maintain strong communication skills to articulate technical concepts and business outcomes.
• Experience with ESRI GIS system upgrades or migrations is a plus.
• Proficiency in SQL Server concepts and database management.
• Ensure compliance with best practices in data integrity and security.