Seattle, United States | Posted on 09/05/2024
the role involves performing SQL related Impact Analysis, GAP Analysis and staging activities.
Key responsibilities- 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.
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
