Talent.com
SQL Analyst
SQL AnalystRMSI • Seattle, WA, United States
No longer accepting applications
SQL Analyst

SQL Analyst

RMSI • Seattle, WA, United States
19 days ago
Job type
  • Full-time
Job 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.
  • Create a job alert for this search

    SQL Analyst • Seattle, WA, United States

    Similar jobs
    Databricks & Azure Cloud Architect Lead

    Databricks & Azure Cloud Architect Lead

    Capgemini • Seattle, WA, United States
    Full-time
    A prominent consulting firm is seeking a Managing Data Architect to lead cloud architecture initiatives, focusing on Azure and Databricks technologies. The role involves designing scalable cloud sol...Show more
    Last updated: 24 days ago • Promoted
    Professional Coding Analyst

    Professional Coding Analyst

    EvergreenHealth • Kirkland, WA, US
    Full-time
    Posted wage ranges represent the entire range from minimum to maximum.For jobs with more than one level, the posted range reflects the minimum of the lowest level and the maximum of the highest lev...Show more
    Last updated: 3 days ago • Promoted
    Technical Business Analyst

    Technical Business Analyst

    Relativity • Seattle, WA, United States
    Full-time
    Relativity's Problem Management is seeking a Technical Business Analyst who excels at using data analytics to uncover trends in quality, client workflows, product performance and efficiency.Your in...Show more
    Last updated: 30+ days ago • Promoted
    SQL DBA Architect

    SQL DBA Architect

    VDart Inc • Bellevue, WA, United States
    Full-time
    Quick Apply
    Role : SQL DBA Architect Location : Remote Contract Show more
    Last updated: 3 days ago
    Senior Configuration and Data Management Analyst

    Senior Configuration and Data Management Analyst

    Blue Origin • Seattle, WA, United States
    Permanent
    Salary range updated, see changes below.Applications will be accepted on an ongoing basis until the requisition is closed. At Blue Origin, we envision millions of people living and working in space ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Architect - AWS ETL & Data Lakes

    Senior Data Architect - AWS ETL & Data Lakes

    Ascendion • Seattle, WA, United States
    Full-time
    A technology solutions company in Seattle is seeking a Data Architect.In this role, you will develop and optimize ETL pipelines, work with AWS technologies, and collaborate with stakeholders to mee...Show more
    Last updated: 30+ days ago • Promoted
    Billing Analyst

    Billing Analyst

    Concord Technologies • Seattle, Washington, United States
    Full-time
    We are seeking an experienced Billing Analyst to join our team.The ideal candidate will have 4+ years of progressive Billing and customer account administration experience.In this role, you will be...Show more
    Last updated: 30+ days ago • Promoted
    Senior Structural Analyst - New Shepard

    Senior Structural Analyst - New Shepard

    Blue Origin • Seattle, WA, United States
    Permanent
    Salary range updated, see changes below.Applications will be accepted on an ongoing basis until the requisition is closed. At Blue Origin, we envision millions of people living and working in space ...Show more
    Last updated: 30+ days ago • Promoted
    Data & Analytics Architect — Remote Data Warehouse Lead

    Data & Analytics Architect — Remote Data Warehouse Lead

    State of Washington • Seattle, WA, United States
    Remote
    Full-time
    A state agency in Seattle seeks a Data and Analytics Architect to design and manage the agency’s data architecture.The role involves creating data warehouses, ensuring data quality, and improving d...Show more
    Last updated: 1 day ago • Promoted
    Configuration / Data Management Analyst III

    Configuration / Data Management Analyst III

    Blue Origin • Seattle, WA, United States
    Permanent
    Salary range updated, see changes below.Applications will be accepted on an ongoing basis until the requisition is closed. At Blue Origin, we envision millions of people living and working in space ...Show more
    Last updated: 30+ days ago • Promoted
    Business Data Analyst : 24-03287

    Business Data Analyst : 24-03287

    Akraya Inc • Seattle, Washington, United States
    Full-time
    Quick Apply
    Primary Skills : Analysis (Expert), Python (Advanced), Excel (Advanced), Tableau (Intermediate), SQL (Expert).We are seeking an experienced Business Analyst II to join our Product Quality Team in Se...Show more
    Last updated: 30+ days ago
    Business Data Analyst : 24-02579

    Business Data Analyst : 24-02579

    Akraya Inc • Seattle, Washington, United States
    Full-time
    Quick Apply
    SQL, Tableau, AWS, Excel, Dashboarding.A leading FAANG E-Commerce company is seeking a Business Data Analyst who can Reviews, analyzes, and evaluates business systems and user needs.Formulates syst...Show more
    Last updated: 30+ days ago
    Senior Financial Analyst, AWS Data Center FP&A

    Senior Financial Analyst, AWS Data Center FP&A

    Seattle Staffing • Seattle, WA, US
    Full-time
    Join Amazon Web Services Finance.Do you want to directly influence the future of some of the most successful products in cloud computing? Come join Amazon Web Services Finance! Amazon Web Services ...Show more
    Last updated: 1 day ago • Promoted
    Remote Senior Cloud Data Platform Architect

    Remote Senior Cloud Data Platform Architect

    TiDB • Seattle, WA, United States
    Remote
    Full-time
    A cloud-native database company is seeking an experienced Solution Architect to support business teams across multiple regions. The role involves advising on architectures and strategies for optimal...Show more
    Last updated: 30+ days ago • Promoted
    Senior Billing Analyst

    Senior Billing Analyst

    Coreweave • Bellevue, Washington, United States
    Full-time +1
    CoreWeave is The Essential Cloud for AI™.Built for pioneers by pioneers, CoreWeave delivers a platform of technology, tools, and teams that enables innovators to build and scale AI with confidence....Show more
    Last updated: 30+ days ago • Promoted
    Sr. Financial Analyst - AWS Data Center Infrastructure, Data Center Construction Finance

    Sr. Financial Analyst - AWS Data Center Infrastructure, Data Center Construction Finance

    Amazon • Seattle, WA, US
    Full-time
    Join the team building the infrastructure that powers the cloud! We support the ongoing infrastructure build-out of AWS, the worlds largest data center service provider and are looking for highly m...Show more
    Last updated: 17 days ago • Promoted
    Senior Data Analyst : 24-02915 (No C2C)

    Senior Data Analyst : 24-02915 (No C2C)

    Akraya Inc • Seattle, Washington, United States
    Full-time
    Quick Apply
    Only Local candite with 5+ Years of experice candidate will consider for the role.Data Mapping (Expert), Data Analysis (Advanced), SQL (Advanced), Excel (Expert), Communication (Proficient).Pay Ran...Show more
    Last updated: 30+ days ago
    Managing Data Architect - Databricks Architect

    Managing Data Architect - Databricks Architect

    Capgemini • Seattle, WA, United States
    Full-time +1
    Managing Data Architect - Databricks Architect.Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and insp...Show more
    Last updated: 24 days ago • Promoted