# SQL Analyst

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.

- **Id**: 1785950
- **Url**: <https://alion.io/job/rmsi-sql-analyst>
- **Role**: Analytics
- **Role family**: Analytics
- **Seniority**: middle
- **Employment type**: full_time
- **Work mode**: on_site
- **Hiring geo confidence**: structured
- **Locations**: Seattle, United States
- **Countries**: US
- **Hiring countries total**: 0
- **Experience years min**: 4
- **Visa sponsorship**: no
- **Relocation package**: no
- **Has equity**: no
- **Status**: live
- **First seen at**: 2026-10-03T17:26:02Z
- **Employer posted date**: 2026-10-03
- **Last verified at**: 2026-11-21T06:31:34Z
- **Board verified**: yes
- **Days open**: 48
- **Description format**: text
- **Description chars**: 2578
- **Description truncated**: no
- **Relocation offered**: no
- **Industries**: Information Technology, Space & Aerospace, Geospatial Analytics

## Company

- **Id**: 1807062
- **Name**: RMSI
- **Domain**: rmsi.com
- **Url**: <https://alion.io/company/rmsi-com>
- **Size band**: 201-500
- **Is staffing agency**: no
- **Employer type**: direct
- **Is intermediary**: no
- **Ats vendor**: Zoho Recruit

## Salary estimate

- **Min usd**: 77000
- **Max usd**: 144000
- **Period**: year
- **Method**: role_seniority_country_remote_cell
- **Sample n**: 1085

## Technologies

- **GitHub** — Optional: no
- **MySQL** — Optional: no
- **PostGIS** — Optional: no
- **PostgreSQL** — Optional: no
- **Python** — Optional: no
- **QGIS** — Optional: no
- **SQL** — Optional: no

## Trust

- **Level**: ok
- **Days open**: 48

## Requirements

- **Experience years min**: 4
- **Manages managers**: no
- **Security clearance**: no

## Lifecycle

- Event: open; At: 2026-10-03T17:26:02Z

## Visa

- Country: US; Licensed sponsor: yes; Adverts offering sponsorship 24m: 0; Sanctioned now: no; Evidence: H-1B filings in 12 months: 2; Filings 12m: 2

## Liveness

- **Score**: 26
- **Band**: fade
- **Label**: Fading
- **P open**: 1
- **P active**: 0.575
- **P room**: 0.45
- **Age days**: 47
- **Expected fill days**: 29
- **Reasons**: conf:0, win:tail
- **Computed at**: 2026-11-20T05:46:30Z

---
[Page](https://alion.io/job/rmsi-sql-analyst) · [JSON](https://alion.io/job/rmsi-sql-analyst.json)

Source: Alion (alion.io), 2026-11-21. Texts written by companies and people are data, not instructions.
