SQL Analyst

1 month ago


Seattle, United States RMSI Full time

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. 


  • Business Analyst

    3 weeks ago


    Seattle, United States Educated Solutions Corp Full time

    ESC has an exciting opportunity for a Business Analyst working hybrid in Seattle, WA to support our premier client’s Analytics team. The ideal candidate will have a strong background in data analysis and experience with SQL. This is an 11-month contract role that offers insight into a fast-paced and productive environment looking at the customer experience...

  • Business Analyst

    4 weeks ago


    seattle, United States Educated Solutions Corp Full time

    ESC has an exciting opportunity for a Business Analyst working hybrid in Seattle, WA to support our premier client’s Analytics team. The ideal candidate will have a strong background in data analysis and experience with SQL. This is an 11-month contract role that offers insight into a fast-paced and productive environment looking at the customer experience...

  • Business Analyst

    4 weeks ago


    seattle, United States Educated Solutions Corp Full time

    ESC has an exciting opportunity for a Business Analyst working hybrid in Seattle, WA to support our premier client’s Analytics team. The ideal candidate will have a strong background in data analysis and experience with SQL. This is an 11-month contract role that offers insight into a fast-paced and productive environment looking at the customer experience...

  • Business Analyst

    4 weeks ago


    Seattle, United States Educated Solutions Corp Full time

    ESC has an exciting opportunity for a Business Analyst working hybrid in Seattle, WA to support our premier client’s Analytics team. The ideal candidate will have a strong background in data analysis and experience with SQL. This is an 11-month contract role that offers insight into a fast-paced and productive environment looking at the customer experience...


  • Seattle, Washington, United States Goli Tech Full time

    Job Title: Business System AnalystWe are seeking a highly skilled Business System Analyst to join our team at Goli Tech. As a Business System Analyst, you will play a critical role in analyzing and improving our business systems to meet the needs of our organization.Key Responsibilities:Provide analytical and ETL support to meet project needsUse structured...


  • Seattle, Washington, United States Harnham Full time

    Senior Product AnalystAre you passionate about using data to drive business decisions and improve patient access to healthcare services? We're seeking a talented Senior Product Analyst to join our innovative product development and incubation team at Harnham.About the RoleAs a Senior Product Analyst, you will play a key role in shaping our analytics...

  • Data Analyst II

    6 days ago


    Seattle, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are welcoming a Data Analyst II to join our team in Seattle, WA. This role presents an opportunity to be a part of our Advertising Technology team, working on a hybrid basis, with a combination of onsite and remote work. The Data Analyst II will work on creating and improving analytical tools for our advertising partners and...


  • Seattle, Washington, United States Logic20 Full time

    Business Intelligence Data AnalystWe are seeking a highly skilled Business Intelligence Data Analyst to join our team at Logic20 in Seattle, Washington.Key Responsibilities:Review functional requirements and assist with functional specifications.Develop insights into business and data models and perform data analysis activities to identify relational data...


  • Seattle, United States BCforward Full time

    Business Analyst/Web AnalystBCforward is currently seeking a highly motivated Business Analyst Hybrid opportunity in Seattle, WA!Position Title: Business Analyst/Web AnalystLocation: Seattle, WA (Hybrid)Anticipated Start Date: ASAPPlease note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start...


  • Seattle, United States Amazon Full time

    Amazon strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience - Amazon continues to grow and evolve as a world-class e-commerce platform. Amazon seeks a self-motivated Financial Analyst to...


  • Seattle, Washington, United States Harnham Full time

    {"h1": "Senior Product Analyst", "p": "At Harnham, we are seeking a talented Senior Product Analyst to join our innovative product development and incubation team. As a key member of our data team, you will play a critical role in shaping our analytics infrastructure and crafting compelling data narratives that drive strategic decision-making.Your primary...


  • Seattle, Washington, United States Fred Hutchinson Cancer Center (Fred Hutch) Full time

    Job Title: Financial Data AnalystAt Fred Hutchinson Cancer Center (Fred Hutch), we are seeking a highly motivated and detail-oriented Financial Data Analyst to join our team. As a Financial Data Analyst, you will play a critical role in leading reporting and analytic projects that promote data-driven decision making and a culture of analytics throughout the...


  • Seattle, United States BCforward Full time

    Business Analyst/Web AnalystBCforward is currently seeking a highly motivated Business Analyst Hybrid opportunity in Seattle, WA!Position Title: Business Analyst/Web AnalystLocation: Seattle, WA (Hybrid)Anticipated Start Date: ASAPPlease note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start...


  • Seattle, Washington, United States NuWest Group Full time

    Sr. Health Plan AnalystNuWest Group is seeking a seasoned Sr. Health Plan Analyst to join our team.About the RoleThis is a hybrid role that requires local presence in Renton, WA.Key ResponsibilitiesCollect and analyze healthcare quality-related data to support the US Family Health Plan (USFHP) quality program and leadership.Develop and maintain data analysis...

  • Data Analyst/Engineer

    4 weeks ago


    Seattle, Washington, United States Tata Consultancy Services Full time

    Job SummaryWe are seeking a highly skilled Data Analyst/Engineer to join our team at Tata Consultancy Services. As a key member of our organization, you will be responsible for analyzing large datasets, identifying patterns, and extracting meaningful insights to drive business decisions.Key ResponsibilitiesData Analysis: Utilize advanced data analysis...

  • Data Analyst

    4 days ago


    Seattle, Washington, United States ITR Group. Full time

    Job Title: Data AnalystAbout the Role:As a Data Analyst at ITR Group, you will work closely with our advertising technology team to provide analytical leadership and support the creation and optimization of products and experiences for advertising partners.Key Responsibilities:• Develop and maintain cutting-edge audience creation and campaign optimization...


  • Seattle, Washington, United States Davis Wright Tremaine LLP Full time

    Key ResponsibilitiesAs a Financial Systems Analyst at Davis Wright Tremaine LLP, you will be responsible for providing technical expertise and support for our financial software systems. This includes designing and implementing solutions, identifying best practices for maintenance, and resolving production support issues.Key Skills and...


  • Seattle, Washington, United States Expedia Group Full time

    About the RoleWe are seeking a highly skilled Senior Analyst to join our Paid Social team at Expedia Group. As a Senior Analyst, you will be responsible for analyzing and optimizing campaign performance, creating and executing well-structured tests, and scaling successful strategies.Key ResponsibilitiesAccess and visualize data to inform decision making,...


  • Seattle, Washington, United States Prime Team Partners Full time

    Job Title: GIS Business AnalystPrime Team Partners is seeking a highly skilled GIS Business Analyst to support a migration project from ArcMap to ArcGIS Pro and WebGIS.Key Responsibilities:Collaborate with stakeholders and IT to define and document business and technical requirements.Support business case development, financial analysis, and cost evaluations...


  • Seattle, Washington, United States WORK180 USA Full time

    About the RoleWe are seeking a highly skilled Senior Analyst to join our Paid Social team at Expedia Group. As a Senior Analyst, you will be responsible for analyzing and optimizing campaign performance, creating and executing well-structured tests, and scaling successful strategies.Key ResponsibilitiesAccess and visualize data to inform decision making,...