SQL Analyst

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.

Created: 2026-03-04