SQL Analyst
Apply NowCompany: RMSI
Location: Seattle, WA 98115
Description:
Job Description
The role involves performing SQL related Impact Analysis, GAP Analysis and staging activities.
Key responsibilities include:
- Impact Analysis - Describe the predictable impact on the Apple Maps Product of issues encountered by Editors.
- 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.
Qualifications:
- 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
- 4-5 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.
The role involves performing SQL related Impact Analysis, GAP Analysis and staging activities.
Key responsibilities include:
- Impact Analysis - Describe the predictable impact on the Apple Maps Product of issues encountered by Editors.
- 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.
Qualifications:
- 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
- 4-5 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.