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]
    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]
    Principal IS Applications Analyst •Hybrid •

    Principal IS Applications Analyst •Hybrid •

    Providence Health & Service • Seattle, WA, United States
    [job_card.full_time]
    Providence caregivers are not simply valued.Join our team at Enterprise Information Services and thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and ...[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]
    Data Architect

    Data Architect

    Anicca Data Science Solutions • Bellevue, WA, United States
    [job_card.full_time]
    Shall at a minimum have a Bachelor’s degree in Computer Science, Computer Engineering, Data Science, Information Technology Management or Engineering, or other comparable Certifications or experien...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SQL Server Assessment Specialist

    SQL Server Assessment Specialist

    VirtualVocations • Puyallup, Washington, United States
    [job_card.full_time]
    A company is looking for a SQL Server Assessment Specialist.Key Responsibilities Conduct comprehensive health and maturity assessments of SQL Server instances Analyze performance bottlenecks and...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business Analyst

    Business Analyst

    Boeing • Everett, Washington, US
    [job_card.permanent]
    Job Description At Boeing, we innovate and collaborate to make the world a better place.We’re committed to fostering an environment for every teammate that’s welcoming, respectful and inclusive, wi...[show_more]
    [last_updated.last_updated_variable_days] • [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_variable_hours] • [promoted] • [new]
    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]
    Senior Application Configuration Analyst - SAP Plant Maintenance

    Senior Application Configuration Analyst - SAP Plant Maintenance

    Puget Sound Energy • Bothell, WA, United States
    [job_card.full_time]
    Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award winning energy efficiency programs, our pathway to an exciting and innova...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Billing Analyst

    Billing Analyst

    Concord Technologies • Seattle, WA, United States
    [job_card.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.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]
    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]
    Smart Building Analyst : Data-Driven Building Performance

    Smart Building Analyst : Data-Driven Building Performance

    MacDonald-Miller • Seattle, WA, United States
    [job_card.full_time]
    A leading mechanical contracting firm is seeking a Smart Building Analyst to enhance building performance through data-driven analysis. The role involves analyzing HVAC system data, identifying perf...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]