Demo

Data Warehouse Analyst I

Bancorp Bank, The
Sioux Falls, SD Full Time
POSTED ON 5/11/2023 CLOSED ON 9/11/2023

What are the responsibilities and job description for the Data Warehouse Analyst I position at Bancorp Bank, The?

Overview

Design, develop, test, and maintain processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.

Responsibilities

Essential Functions

  • Develop ETL processes for parsing, extracting, and loading data in Base SAS and SnowSQL.
  • Document, test and debug data programs prior to implementation in the live production environment using standard testing and validation protocols.
  • Group and summarize data to optimize performance for scheduled processes and end user reporting.
  • Develop data feeds and reports for external and internal clients as requested. Question users to determine fields and array of data needed to fulfill requests. Create and document reports available in the report library.  Build dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
  • Develop data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
  • Develop close working relationships with project management and end users to understand issues arising with reporting and data systems and deliver accurate and time-saving solutions through the data warehouse.
  • Monitor, troubleshoot, and resolve issues with daily production processes and assist with maintenance of reporting portal and data warehouse.
  • Perform other related duties as assigned.
  • Qualifications

    Education/Experience Requirements

    • An undergraduate degree in a related field or an equivalent combination of training and experience.
    • A minimum of 1 year work or coursework experience with data warehouse design, SAS programming or SQL query writing
    • Previous financial services industry experience a plus

    Preferred Requirements

    • Working knowledge of SAS technologies including Base SAS, SAS Data Management, DataFlux, Integration Technologies, Enterprise Guide, or Metadata Server.
    • Basic industry knowledge of MS SQL Server, HTML, and Scheduling systems a plus
    • Excellent verbal, written, and interpersonal communication skills
    • Self-motivated with the ability to effectively work independently and as a team member in a multi-tasking environment.

    Background & EEO Statement

    Working at The Bancorp Bank, N.A. and Benefits Information: click here

    Diversity & Background Screening

    Diversity & Inclusion at The Bancorp Bank: click here

     

    The Bancorp Bank, N.A. is an EQUAL OPPORTUNITY EMPLOYER and will not discriminate on the basis of race, color, religion, gender, gender identity, sexual orientation, pregnancy, citizenship, national origin, age, disability, genetic information, veteran status or other protected category with respect to recruitment, hiring, training, promotion, and other terms and conditions of employment.

     

    Employment with The Bancorp Bank, N.A. includes successfully passing a background check including credit, criminal, education, employment, OFAC, and social media background history.

    Data Analyst
    Avera -
    Sioux Falls, SD
    Data Analyst
    Noblesoft Technologies -
    Minneota, MN
    Data Warehouse Engineer III
    First Interstate -
    Sioux Falls, SD

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    Sign up to receive alerts about other jobs with skills like those required for the Data Warehouse Analyst I.

    Click the checkbox next to the jobs that you are interested in.

    • SAP Asap Methodology Skill

      • Income Estimation: $152,066 - $200,383
    • Business Analytics Skill

      • Income Estimation: $113,567 - $162,206
      • Income Estimation: $116,096 - $159,317
    This job has expired.
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Bancorp Bank, The

    Bancorp Bank, The
    Hired Organization Address Sioux Falls, SD Full Time
    Overview Work Arrangement: ***After the initial training period, this is a hybrid role, working onsite in our Sioux Fall...
    Bancorp Bank, The
    Hired Organization Address Sioux Falls, SD Full Time
    Overview Work Arrangement: ***After the initial training period, this is a hybrid role, working onsite in our Sioux Fall...
    Bancorp Bank, The
    Hired Organization Address New York, NY Part Time
    Overview This Associate position plays a central role in the origination and underwriting of bridge loans. Responsibilit...
    Bancorp Bank, The
    Hired Organization Address Sioux Falls, SD Full Time
    Overview Work Arrangement: ***After the initial training period, this is a hybrid role, working onsite in our Sioux Fall...

    Not the job you're looking for? Here are some other Data Warehouse Analyst I jobs in the Sioux Falls, SD area that may be a better fit.

    Data Warehouse Analyst I (Hybrid)

    Bancorp Bank, The, Sioux Falls, SD

    Data Analyst

    Gary Wenzel Electrical and Fire Alarm Solutions, Madison, SD

    AI Assistant is available now!

    Feel free to start your new journey!