Data Warehouse SQL Developer

Company: Boot Barn, Inc. ( Learn More )

General Information
US-CA-Irvine
N/A
Not Specified
Full-Time
Not Specified
Not Specified
False
False
Job Description

SUMMARY

Database Warehouse SQL Developer will focus on designing, implementing, data cleaning and standardization to continuously improve the company-wide data warehouse as well as analyze and report metrics, dimensions and fact tables.

The ideal candidate will be deeply involved in designing/implementing data processing pipelines, data cleansing, standardization, data profiling, and enrichment process with the goal of populating a company-wide data warehouse. Ideally, this candidate should have previous experience with Microsoft data warehousing practices, including SQL Server Analytics and Integration Services and have a firm understanding of data warehousing layout.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Creating and maintaining database schema /models (Azure SQL Server, SQL Server 2016, SQL Server 2008 R2)
  • Plan, create, and maintain existing and future data modeling and import through SSIS / SSAS / Data Lake / Data Factory
  • Establishing the needs of users and monitoring user access and security
  • Usage of PowerShell to manage and maintain back-end systems and data integration processes
  • Monitoring performance and managing parameters to provide fast responses to front-end users
  • Play intrigue role in data-warehousing design, development and implementation efforts;
  • Mapping out the conceptual design for a planned database
  • Develop and maintain ETLs, validating results with business representatives (Azure Data Lakes, Data Factory, Spark)
  • Considering both back-end organization of data and front-end accessibility for end-users;
  • Refining the logical design so that it can be translated into a specific data model
  • Supporting implemented BI solutions; monitoring, tuning queries and data loads
  • Creating, maintaining and planning reporting strategy and functionality through Power BI
  • Writing data warehouse documentation, including data standards, procedures and definitions for the data dictionary (metadata)
  • Maintaining data standards, including adherence to PCI and SOX Compliance;
  • Troubleshoot query efficiency for both back-end and front-end applications (T-SQL, Profiler, etc.)
  • Controlling access permissions and privileges
  • Developing, managing and testing back-up and recovery plans
  • Address user questions concerning data integrity, monitoring performance and communicating functional and technical issues
  • Working with business analysts and project managers to develop and refine reporting and analytics
  • Ensuring that storage and archiving procedures are functioning correctly; capacity planning
  • Commissioning and installing new applications and customizing existing applications in order to make them fit for purpose
  • Communicating regularly with technical, applications and operational staff to ensure data warehouse integrity and security
  • SUPERVISORY RESPONSIBILITIES

  • There are no supervisory duties associated with this role
  • ADDITIONAL RESPONSIBILITIES

  • Demonstrates high degree of professionalism in communication, attitude and teamwork with customers, peers and management
  • Demonstrates high level of quality work, attendance and appearance
  • Adheres to all Company Policies & Procedures and Safety Regulations
  • Adheres to local, state and federal laws
  • Performs any other duties that may be assigned by management
  • Understands and complies with all company rules and regulations
  • MINIMUM QUALIFICATIONS

  • Experience creating and using Azure Analysis Services and Data Factory platform is required
  • A firm understanding of current cloud environment business intelligence solutions / components
  • Professional experience with SSIS/SSAS implementations, configurations, deployment solutions
  • Working knowledge of Big Data BI Solutions using Azure SAS models
  • Strong knowledge of T-SQL and U-SQL programming languages
  • Thorough understanding of Azure Analysis Services
  • Azure Data Factory (involved in the data pipelines/cleansing/standardize data)
  • Experience with GIT repository
  • Participation in open source projects and forums such as stack overflow is a plus
  • Experience in an environment where everyone shares knowledge freely
  • PHYSICAL DEMANDS: In general, the following physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to allow differently-abled individuals to perform the essential functions of the job.

  • Standing, walking and squatting less than fifty percent of the work shift.
  • Required to lift, move and carry up to 40 pounds.
  • Ability to read, count and write to accurately complete all documentation and reports.
  • Must be able to see, hear and speak in order to communicate with employees and other customers.
  • Specific vision abilities include close vision, distance vision, peripheral vision, depth perception and ability to adjust focus.
  • Manual dexterity required using hands to finger; handle, feel and type; reach with hands and arms.
  • Moderate: Mostly standing, walking, bending, frequent lifting

    WORK ENVIRONMENT: In general, the following conditions of the work environment are representative of those that an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to allow differently-abled individuals to perform the essential functions of the job within the environment.

  • The work space is clean, orderly, properly lighted and ventilated with the proper safety compliance.
  • Noise levels are considered low.
  • Boot Barn, Inc. reserves the right to make exceptions to, modify or eliminate this document or its content. This document supersedes all previous policies, procedures or guidelines pertaining to this subject.

    Job Requirements