• Business Systems Analyst I - Data Warehouse

    Job Locations US-TX-Arlington
    Requisition ID
    2018-31522
    Employee Type
    Full Time-Regular
    Category
    Information Technology
  • Overview

    ​The GMF Data Warehouse Business Systems Analysis (BSA) team serves as the primary point of contact and support for users interacting with the Data Warehouse. The BSA team works with end users to define and document business requirements, reporting metrics and data usage patterns for the Design and Development teams. The BSA team assists users with query development and with general Data Warehouse guidance. The BSA team prioritizes requests for new data and for Data Warehouse modifications with the Data Warehouse Steering committee. The BSA team manages Data Warehouse projects such as new data requests and projects that are internal to the Data Warehouse team. 

    Responsibilities

    JOB DUTIES

    • Gather requirements and create high quality business requirements docmentation for data warehouse initiatives
    • Communicate consistently and effectively with Data Warehouse users during development and while fulfilling maintenance requests
    • Provide project management for Data Warehouse maintenance requests from inception through delivery
    • Provide query assistance to Data Warehouse users, including ad hoc queries as needed
    • Research and troubleshoot Data Warehouse support tickets, including querying the Data Warehouse tables, confirming data values in various source systems, and tracing data lineage from source to target
    • Report timely and accurate metrics regarding Data Warehouse projects and support ticket counts week to week
    • Create and maintain SharePoint sites for the Data Warehouse user community, containing models, mapping documents, and training aids

    Qualifications

     

    Knowledge

    • Ability to gather and document business requirements
    • Ability to write intermediate SQL queries and to understand technical specifications to ensure proposed solutions meet business requirements
    • Ability to prioritize multiple tasks and a moderate workload
    • Working knowledge of Data Warehousing principles, including Dimensional Models, ETL, Oracle Databases and Development Principles
    • Excellent knowledge of the design and functions of effective Data Warehouse solutions
    • Excellent knowledge of standard project management methodologies
    • Ability to meet expected delivery dates and the tasks necessary to achieve objectives
    • Ability to interact with staff at all levels
    • Ability to work directly with senior level management
    • Knowledge of business processes for supported business groups

    Skills

    • Working knowledge of information systems and operational systems for supported business groups
    • Working knowledge of the consumer loan business
    • Knowledge of information technology systems, infrastructure and operations
    • Excellent verbal and written communication skills
    • Good experience in Microsoft Office software
    • Very deadline oriented
    • Strong ability to analyze data using Excel for reporting and data mining purposes
    • Strong people skills
    • Must be a self-started and able to manage the investigations function with minimal supervision

    Education

    • Bachelor’s Degree in MIS, Information Technology, or equivalent combination of education and work experience preferred

    Experience

    • 0-2 Years experience as a Data Warehouse BSA or an IT Project Manager in a Data Warehouse environment. Required

    Work Condition

    • Subject to stressful situations;Fast-paced office environment;Strong focus on providing quality service to internal and external customers;Must be able to deal with stressful office conditions while troubleshooting problems

    Options

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

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.