Data Modeler/ETL Developer - 12976BR

Data Modeler/ETL Developer

Department: 
Business Intelligence Center
Location/Division: 
University of Kansas - Lawrence
Reg/Temp: 
Regular
Employee Class: 
U-Unclassified Professional Staff

Position Overview

The Business Intelligence Center (BIC) at the University of Kansas brings analytical and technical staff together to rapidly make progress in data warehousing and business intelligence. The BIC is charged with modeling university’s data and supporting BI toolsets that empower campus users to make data-driven decisions in a self-service fashion. Finally, the BIC also has a leadership role in university data governance.
Extract, Transform, & Load (ETL) Developers work closely with BI Analysts and the Data Architect to extract data from source systems, transform data as necessary, and ultimately load data into the university’s Data Warehouse. These extracts must be modeled into dimension and fact tables (i.e. STAR Schema) that ultimately support end user requirements. The developer will also monitor daily jobs to ensure they were successful and troubleshoot any issues that arise from jobs failing, loading data incorrectly, etc.

Job Description

Development (60%)
  • Develop and maintain ETL processes and/or SQL queries from various source systems.
  • Assist the Data Architect with developing a Dimensional Fact Model (i.e. STAR Schema) for the various modules and subject areas of the university’s data.
  • Work on the design and implementation of data integrations.
  • Develop and maintain the automation of data flowing into and out of the source systems.
  • Work on web services to extract data from various source systems.
  • Work with BI analysts, functional users, and data scientists to develop and further enhance data models.
  • Participate in an Agile environment and complete assigned sprint tasks.
  • Adhere to basic development principles (e.g. change control, separation of duties, etc.)
  • Provide feedback from a technical perspective on requirements documents. Additionally, create technical design document with data flows, process models, etc. to help document the technical approach to meeting end user needs.

Application/Integration Support (20%)
  • Support a complex Data Integration environment.
  • Assist with ETL Application Tool/Server system and database upgrades/maintenance.
  • Work with the Network Operations Center (NOC) to ensure extract jobs are monitored.
  • Troubleshoot issues as they arise (e.g. failed jobs, data errors, etc.).
  • Assist with Modeling and BI Tool/Server upgrades.

Testing and Validation (15%)
  • Determining data sourcing strategies and data validation approaches.
  • Defining test conditions and test scripts to ensure system stability and validity.
  • Develop and maintain audit and validation processes and work with other team members to resolve data integrity issues.

Other projects as assigned (5%)

Required Qualifications

  1. Bachelor’s degree in Information Systems, Computer Science/Engineering, Information Technology, Business Analytics, or Business with a focus in Business Analytics.
  2. 3 years of relevant professional experience.
  3. At least two years of experience with an enterprise ETL tool (e.g. Informatica, Oracle Data Integrator, etc.)
  4. Advanced SQL skills.
  5. Knowledge of data modeling.
  6. Demonstrated experience in testing and debugging techniques.

Preferred Qualifications

  1. Exceptional time management skills, including the ability to adapt quickly to shifting priorities.
  2. University experience.
  3. Experience with and passion for working in an agile team environment.
  4. Experience with developing Essbase applications.
  5. Experience with implementing web services.
  6. Experience working with databases.
  7. BI and/or data warehousing experience.

Additional Candidate Instructions

A complete application consists of a cover letter, resume, and three professional references. Please use your cover letter to address how you meet the required and preferred qualifications. Incomplete applications will not be considered. An online University of Kansas application must be completed to be considered for this position.

The review of applications will begin on October 15, 2018. This position will remain open until filled.

Contact Information to Applicants

Prasanna Tadimeti , prasanna @ku.edu

Advertised Salary Range

Starting at $67,500 and commensurate with experience

Application Review Begins

15-Oct-2018

Anticipated Start Date

05-Nov-2018

Search Jobs
Posting Information
Posting ID:
12976BR
Department:
Business Intelligence Center
Location/Division:
University of Kansas - Lawrence
Reg/Temp:
Regular
Employee Class:
U-Unclassified Professional Staff
Application Review Begins:
15-Oct-2018
One of 34 U.S. public institutions in the prestigious Association of American Universities
44 nationally ranked graduate programs.
—U.S. News & World Report
Top 50 nationwide for size of library collection.
—ALA
23rd nationwide for service to veterans —"Best for Vets," Military Times
KU Today