Talent.com
SQL Analyst
SQL AnalystRMSI • Seattle, WA, United States
SQL Analyst

SQL Analyst

RMSI • Seattle, WA, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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.
    • [job_alerts.create_a_job]

    Analyst • Seattle, WA, United States

    [internal_linking.similar_jobs]
    SQL Database Administrator

    SQL Database Administrator

    VirtualVocations • Renton, Washington, United States
    [job_card.full_time]
    A company is looking for a SQL Database Administrator to manage and optimize enterprise-scale SQL Server environments.Key Responsibilities Manage large-scale SQL Server databases across on-premis...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Business Systems Analyst (LT)

    Senior Business Systems Analyst (LT)

    City of Renton Washington • Renton, WA, United States
    [job_card.full_time]
    This is a term-limited position for an initial one-year period with a potential extension of up to one additional year contingent upon organizational needs and funding. Join the City of Renton's IT ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Analyst III - Epic Cadence

    Application Analyst III - Epic Cadence

    Fred Hutchinson Cancer Center (Fred Hutch) • Seattle, WA, United States
    [job_card.full_time]
    Application Analyst III - Epic Cadence.Fred Hutchinson Cancer Center is an independent, nonprofit organization providing adult cancer treatment and groundbreaking research focused on cancer and inf...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Analyst III - Epic Cadence

    Application Analyst III - Epic Cadence

    Unavailable • Seattle, WA, United States
    [job_card.full_time]
    Fred Hutchinson Cancer Center is an independent, nonprofit organization providing adult cancer treatment and groundbreaking research focused on cancer and infectious diseases.Based in Seattle, Fred...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Technical Business Analyst

    Technical Business Analyst

    Relativity • Seattle, WA, United States
    [job_card.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.last_updated_variable_days] • [promoted]
    senior analyst, Tax Data Enablement

    senior analyst, Tax Data Enablement

    Starbucks • Seattle, WA, United States
    [job_card.full_time]
    Now Brewing - senior analyst, Tax Data Enablement! #tobeapartner.From the beginning, Starbucks set out to be a different kind of company. One that not only celebrated coffee and the rich tradition, ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Analyst

    Data Analyst

    Zone IT Solutions • Seattle, WA, US
    [job_card.full_time]
    Zone IT Solutions is seeking an experienced Data Analyst with a strong background in Python and SQL.In this role, you will be responsible for gathering, processing, and analyzing large datasets, en...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Architect - AWS ETL & Data Lakes

    Senior Data Architect - AWS ETL & Data Lakes

    Ascendion • Seattle, WA, United States
    [job_card.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.last_updated_variable_days] • [promoted]
    Data Analyst - Class Action Defense

    Data Analyst - Class Action Defense

    Davis Wright Tremaine • Seattle, WA, United States
    [job_card.full_time]
    This is an exciting opportunity to work for one of the top law firms in the U.Davis Wright Tremaine LLP is looking for a. Data Analyst (Class Action Defense).Seattle, Portland, Los Angeles, San Fran...[show_more]
    [last_updated.last_updated_30] • [promoted]
    System Analyst

    System Analyst

    OCBC • Seattle, WA, United States
    [job_card.full_time]
    Banking Systems Integration Specialist.As Singapore's longest established bank, we have been dedicated to enabling individuals and businesses to achieve their aspirations since 1932.How? By taking ...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Principal Structural Analyst - New Shepard

    Principal Structural Analyst - New Shepard

    Blue Origin • Seattle, WA, United States
    [job_card.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.last_updated_30] • [promoted]
    Data Architect

    Data Architect

    ANICCA DATA SCIENCE SOLUTIONS LLC • Bellevue, WA, US
    [job_card.full_time]
    Shall at a minimum have a Bachelors degree in Computer Science, Computer Engineering, Data Science, Information Technology Management or Engineering, or other comparable Certifications or experienc...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Exclusive opening - SQL Server Database Architect

    Exclusive opening - SQL Server Database Architect

    Resource Informatics Group Inc • Seattle, WA, US
    [job_card.full_time]
    SQL Server Database Architect and Administrator.We"re looking to hire a highly technical, passionate individual responsible for support, architecture, administration and development of our SQL...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Solution Architect

    Senior Data Solution Architect

    Boeing • Everett, WA, United States
    [job_card.permanent]
    Senior Data Solution Architect.Boeing's Airplane Systems Integration team is hiring for a Senior Data Solution Architect to work at our Everett, WA location. Designs, develops, and maintains ETL rou...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Analyst II - Epic Cadence

    Application Analyst II - Epic Cadence

    Fred Hutchinson Cancer Center • Seattle, WA, United States
    [job_card.full_time]
    Fred Hutchinson Cancer Center is an independent, nonprofit organization providing adult cancer treatment and groundbreaking research focused on cancer and infectious diseases.Based in Seattle, Fred...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business Data Analyst : 24-02579

    Business Data Analyst : 24-02579

    Akraya Inc • Seattle, Washington, United States
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Database Administrator (Azure)

    Database Administrator (Azure)

    Indigenous Pact PBC, Inc. • Seattle, WA, US
    [job_card.full_time]
    About Indigenous Pact PBC, Inc : .Established in 2017 Indigenous Pact PBC, Inc.B-Corporation, set out on a mission to create health equity for American Indians and Alaskan Natives.As part of a global...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Managing Data Architect - Databricks Architect

    Managing Data Architect - Databricks Architect

    Capgemini • Seattle, WA, United States
    [job_card.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.last_updated_variable_days] • [promoted]