View Job

This job posting is no longer active on Diverse Jobs and therefore cannot accept online applications.


    

This posting cannot receive an online application from your Diverse Jobs account. To apply, follow the employer's instructions within their job description.

Kennesaw State University

Location: KennesawGA 30144 Document ID: AD145-0FLR Posted on: 2019-04-1204/12/2019 Job Type: Regular

Job Schedule:Full-time
2019-05-12
 

Data Warehouse Analyst

Title:
Data Warehouse Analyst

Location:
Kennesaw Campus

Job Category:
Staff

Regular/Temporary:
Regular

Open Date:
02/19/2019

Hours per week:
40

MVR Report:
This position WILL NOT require a satisfactory MVR (Motor Vehicle Report) as a condition of employment

P-Card:
This position WILL NOT require a satisfactory Consumer Credit check as a condition of employment

Knowledge, Skills, & Abilities:
  • Experience working with data from Ellucian Banner information system data, ETL
  • Ability to develop system modifications in a variety of products such as SAS, and SQL to support the application
  • Ability to develop and enhance existing Extract, Transform, and Load (ETL) process as the source for data warehouse tables
  • Ability to work in a changing environment as new tools become available and underlying technologies evolve and change
  • Demonstrate a strong understanding of data sources, database, design, and development logic and constructs, especially as related to data warehouse technology
  • Advanced knowledge of database management systems
  • Advanced skill in the use of Structured Query Language (SQL) for data retrieval, data manipulation, and the creation and modification of database objects
  • Experience with data modeling and architecture

MINIMUM EDUCATION REQUIRED:
Bachelor's degree in a technical discipline such as computer science, computer engineering, management information systems, information technology, or a related field.

MINIMUM EXPERIENCE REQUIRED:
  • Five (5) years of experience in data integration, SQL programming, database management or development; or equivalent combination of education and experience with Three (3) years of work experience in database systems (Oracle or MS SQL Server)
  • Demonstrate a strong background in data warehouse design and implementation
  • Agile experience
  • Exposure and deep understanding of conceptual, Logical and Physical model is a Must
  • Experience in querying and analyzing data using SQL
  • Experience with data modeling and architecture


Preferred Qualifications:
Master's degree in a technical discipline such as computer science, computer engineering, information technology, or management information systems
Five (5) years of work experience in an institutional research, or enrollment management office

Job Purpose:
The Data Warehouse Analyst is responsible for translating business requirements into the appropriate data models that integrate with the overall logical data warehouse. This individual will work closely with senior members of the IR team to define, document, and apply business rules to enterprise data, and will participate in the design and development of ETL standards, policies, procedures, and metadata to ensure accuracy, quality, integrity, and optimization of this information.

Key Responsibilities:
  • Document functional requirements, system design specifications, use cases, workflow diagrams, and interface designs
  • Design conceptual, logical and physical data models
  • Work with IT teams, business analysts and data analytics teams to understand data consumers' needs and develop solutions
  • Develops dimensional models, OLAP structures, ETL, and reports
  • Provides support for data analysis and presentation tools
  • Perform root cause analysis on all processes, resolve all production issues, validate all data, perform routine tests on databases, and provide support to all ETL applications


  •