DiscoverOrg

  • Database Analyst

    Job Locations US-WA-Vancouver
    # of Openings
    1
    Category
    Research
  • Overview

    Here is what a typical day will look like as the Database Analyst:

    • Works as part of the BI & Analytics team to manage scheduled and ad hoc procedures from various sources, including MySQL, MSSQL, Snowflake and flat files.
    • Works with cross-functional teams to clean and load data into our production databases.
    • Responds to tickets to troubleshoot and resolve data quality and reporting issues.
    • Offers strategic input to improve or automate the treatment of information by multiple departments.
    • Meets with end users to discuss data needs and to gather technical and non-technical requirements.
    • Supports end users and teammates on SQL-related questions and issues.
    • Creates and maintains documentation for end users and other data analysts.
    • Finds opportunities to improve and optimize existing procedures and operational processes

    Responsibilities

    You're likely a great fit for this opportunity if you have the following:

    • Bachelor's Degree in Computer Science, Information Systems, or related field and 1+ years of experience writing complex database queries and reports, or an equivalent combination of education and experience.
    • Experience writing SQL for data analysis, including collecting, assembling, cleansing and formatting data.
    • Experience developing and maintaining stored procedures, functions, and events.
    • Ability to communicate effectively with, and provide excellent customer service to, stakeholders at all levels of the organization.
    • Available for on-call and/or after-hours support as needed
    • Self-motivated; able to work independently to complete tasks and collaborate with others to identify and implement solutions.

    Qualifications

    Technologies/skills:

    • SQL, specifically MySQL, Postgres.
    • AWS familiarity, especially Aurora, and S3.
    • Advanced Excel, PowerQuery
    • One or more programming languages, such as Python a plus.
    • Experience with Git/GitHub or other version control systems
    • Familiarity with Spark/Spark SQL, Snowflake or DataBricks a plus.

    Benefits

    We offer an attractive benefits plan with health benefits that include three medical coverage options, vision and dental coverage – HSA, FSA, 401(k) with employer match, paid parental leave, paid time off, paid sick leave, short-term and long-term disability, life insurance, and AD&D insurance.

     

     

     

    Why You Should Join DiscoverOrg:

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed