Ihre aktuelle Jobsuche

4 Suchergebnisse

Für Festanstellung in San Diego

    Referenz: 104_1607094352

    Database Architect

    USA, California, San Diego

    • 135000 to 140000 USD
    • Architect Stelle
    • Seniority: Mid-level

    Jobbeschreibung

    Job Description

    - The database architect would own the database architecture within Snowflake. This includes extracting, loading, and transforming data from different data sources into a centralized data warehouse in Snowflake. The architecture is critical to the business intelligence platform and will help the visualization layer developed using Tableau.

    Role & Responsibilities

    * Responsible for the database architecture within Snowflake
    * Own the extraction, load, and transform (ELT) process that is key to the data warehouse layer
    * Periodically review queries and optimize them for performance
    * Work closely with the data visualization team to create Tableau reports that perform optimally while serving the
    * business needs
    * Work with the business systems owners to understand the source data and develop a path to extract, load, and
    * transform that data in Snowflake
    * Be the subject matter expert on Snowflake and the ELT process
    * Train super users on running analytics on the Snowflake environment
    * Troubleshoot data issues in the ELT pipeline.

    Skills & Qualifications

    * 2-3 years of Snowflake experience
    * 5+ years of data warehouse experience including ETL and ELT processes
    * Experience in normalization/query optimization/data structures/database design
    * Experience with one or more programming languages (Python, R), Object-Oriented Concepts
    * Experience with shell scripting or comparable experience
    * Ability to communicate across multiple organisational levels
    * Ability to balance strategic and tactical needs while adjusting to changing priorities
    * Strong analytical and problem-solving skills
    * Bachelor's in Information Systems or related discipline.

    Benefits

    * medical
    * dental
    * vision
    * LTD
    * retirement plan

    If interested in this excited opportunity, with an amzing company please contact me l.kelly@jeffersonfrank.com or (347) 783-6637