Senior GIS Data Analyst

Website Rizing Rizing

About the Company

  • Rizing is a privately held multi-million dollar international company fully committed to providing best in-class solutions to meet the global demand for SAP & Geospatial consulting, implementation services, and products by leveraging our industry expertise to help companies run better.

Description

  • The Senior GIS Data Analyst is an advanced practitioner in the geospatial industry specializing in the area of geospatial data modeling, analysis, migration, and transformation. This person must be able to interpret captured requirements into the necessary data solutions and lead in the creation of project deliverables, works with or leads a technical project team and clients to design, develop, test, and implement spatial and non-spatial enterprise database structures for productive and efficient systems. Additionally, this person develops technical design specifications and perform data migration tasks from legacy systems to newly implemented systems and oversees the day to day administration of enterprise geodatabases on project and internal work.

Essential Functions

  • Provide advanced database and data modeling expertise, including spatial data.
  • Stay current on GIS, data modeling and management software, and changes in the industry.
  • Communicate data related concepts clearly to teammates and clients in writing and diagrams.
  • Perform or lead teams in the creation of data related requirements and project deliverables:
    • Database design including development of Entity-Relationship Diagrams (ERD)
    • Data quality assessments
    • Data migration plans
    • Design documentation (data related portions)
    • Data acceptance testing
    • Database code solutions (PL/SQL, Transact-SQL, etc.)
  • Establish and maintain data environments for projects, custom software development, and product development efforts.
  • Leverage advanced SQL for data manipulation, query, analysis, and report.
  • Maintain professional client relationships.
  • Provide clear and frequent communication with the project managers on the status of project deliverables.
  • Work closely with other Data Analysts and Geospatial Analysts to share ideas, assist with other similar ongoing projects, and lead technical discussions and innovation.
  • Maintain expert knowledge of Rizing Geospatial’s professional services offerings and products.
  • Help identify opportunities for ongoing project opportunities during assigned project work.

 

Required Qualifications

  • Bachelor’s Degree in Computer Science, GIS, Information Systems, or a related discipline.
  • Six (6) years of data modeling, analysis, or management software experience (related graduate-level coursework can be substituted for up to one year of experience).
  • Three (3) years of experience in managing an RDBMS environment(s).
  • Expertise with SQL Server and/or Oracle.
  • Expertise with Esri ArcSDE/Geodatabase replication, versioning, synchronization.

 

Desired Qualifications

  • Understanding of Linear Referencing Systems (LRS).
  • Understanding of Geographic Information Systems (GIS).
  • Experience with and/or knowledge of SAP/HANA.

 

Knowledge, Skills, And Abilities (KSAs)

  • Technical expertise with enterprise database software (e.g., Oracle, SQL Server, SAP4/HANA).
  • Ability to design, develop and troubleshoot Extract, Transform, Load, (ETL) tools and processes.
  • Expertise utilizing database modeling software (e.g., Erwin, ER/Studio, Sparx Enterprise Architect).
  • Expert in developing Structured Query Language (SQL) queries, ETL processes, and Transact-SQL (T-SQL) stored procedures to support data validation, manipulation, and/or preparation of enterprise Geospatial databases.
  • Expert in how to design processes, create procedures and implement database indexing methods to optimize database performance.
  • Expertise in creating and administering multiple enterprise databases/geodatabases on multiple platforms. This includes overseeing the planning and licensing of various database instances for the geospatial team and their ongoing projects.
  • Expertise with database importing, exporting, snapshots, and backups.
    Expert in performing data mining on databases to discover geospatial, temporal, and other types of patterns or trends.
  • Knowledge of Linear Referencing Systems (LRS), dynamic segmentation, and other geospatial concepts.
  • Ability to attentively listen and effectively communicate ideas and processes, in oral and written format, with clients and other consultants.
  • Ability to assist clients with assessing existing systems and optimize their solutions using existing knowledge of system functionality and best practice recommendations.

To apply for this job email your details to john.hudler@rizing.com