Job Description

Job Title

SQL Analyst

Location

Seattle

About RMSI

RMSI’s AI-powered spatial intelligence solutions in mapping, asset integrity, network optimization, and climate risk modeling help organization enable operational autonomy, and drive sustainable growth.

With a workforce of over 6000 employees, RMSI stands as one of the largest employers in the geospatial industry and is consistently recognized as a top employer. Our operations include three state-of-the-art development centers in India and six fully owned international subsidiaries in the US, Canada, Australia, the UK, the Middle East, and Bahrain.

For more information about RMSI, please visit .

Role

The role involves performing SQL related Impact Analysis, Gap Analysis, and staging activities.

Responsibilities

• Impact Analysis-Describe the predictable impact of issues encountered by Editors on a Maps Product.
• Gap Analysis- Describe the magnitude and severity of missing information relative to expectations in developing workflows and available sources.
• Source Staging- Design and monitor automated workflows, and apply manual interventions as necessary to ensure source data is properly staged and suitable for intended use.

Skill & Qualification

• Ability to ingest and transform common data formats for tabular and geospatial information.
• Working knowledge of software asset control in GitHub.
• Ability to execute and troubleshoot SQL queries in a PostGIS database.
• Experience with Postgres spatial functions, using pgAdmin, MySQL, or other sql databases.
• Experience with database manipulation using python (pandas), R, or other language.
• Experience working with datasets in JSON file format.
• Familiarity with regex and hive.
• Working knowledge of map usage and digital mapping concepts.
• Ability to recognize common planimetric features in natural color photography.
• Ability to learn editing workflows in map editing software.
• Familiarity with common GIS editing software, including QGIS.
• Working knowledge of computer terms and concepts, especially as they apply to data sources and products that describe geo-referenced business listings.
• Ability to manage and organize large volumes of data.
• Excellent organization skills—able to design and implement ad-hoc tracking systems as spreadsheets or other desktop computer tools.
• Demonstrated ability to perform open-source research with a variety of search tools and techniques.
• Ability to follow (or question) complex procedural instructions in English that may have gaps, ambiguities, contradictions or other imperfections typical of early-stage piloting.
• Ability to produce concise documentation of issues encountered during the execution of Assignments, in a format that may be dictated to support issue tracking systems and to support the analysis of issue uniqueness.

Requirements

• 1-3 years of experience working on Maps SQL.
• Familiarity in JSON file format
• Familiarity with regex and hive
• Experience with database manipulation using python (pandas), R, or other language
• Experience working on Maps related program for Large Map development companies is a must
• Has experience working on digital map production environment and responsible for Delivery and Quality functions.

Job Tags

Similar Jobs