SQL Developer for Data Warehouse Technology

Ball State University

Muncie, IN

Job posting number: #7089620 (Ref:BSU28355)

Posted: November 23, 2021

Application Deadline: Open Until Filled

Job Description

The position’s primary responsibilities include development and generation of complex data extracts from the Ball State ERP System (Oracle/Ellucian Banner) in order to populate and maintain the BSU data warehouse environment.

Responsible for providing database administrative support for Ball State’s enterprise database servers; provide database solutions and support to clients of Enterprise Information Systems (EIS); effectively utilize the resource areas available within and outside of EIS in order to implement appropriate solutions that address the needs of clients. Help to ensure the high reliability and availability of applications running on local or remotely hosted enterprise systems.  Additionally, this position will maintain the enterprise data warehouse and work with the ERP Administrators in Banner.  This position will also play a key role in creating Extract, Transform and Load (ETL) processes responsible for pulling data from Banner destined for the institutions data warehouse. 100% remote work may be awarded based upon experience and expertise of the selected candidate.

Ball State University is seeking an energetic person interested in working with the latest enterprise and warehouse database technologies. If you are excited about the challenge of deploying a new warehouse system at a large university, you may be the candidate we’re looking for. As a SQL Developer for Data Warehouse Technology, you’ll be working with a team to implement a new warehouse solution for the campus. Your role will also work collaboratively with Institutional Research and Decision Support and others in the campus community to enhance warehouse systems to fit the needs of the university and support their data needs.  This position has the potential to work remote. If you are ready for a new challenge, we’d like to talk with you.
 

Job Function:

The position’s primary responsibilities include development and generation of complex data extracts from the Ball State ERP System (Oracle/Ellucian Banner) in order to populate and maintain the BSU data warehouse environment.

Responsible for providing database administrative support for Ball State’s enterprise database servers; provide database solutions and support to clients of Enterprise Information Systems (EIS); effectively utilize the resource areas available within and outside of EIS in order to implement appropriate solutions that address the needs of clients. Help to ensure the high reliability and availability of applications running on local or remotely hosted enterprise systems.  Additionally, this position will maintain the enterprise data warehouse and work with the ERP Administrators in Banner.  This position will also play a key role in creating Extract, Transform and Load (ETL) processes responsible for pulling data from Banner destined for the institutions data warehouse. 100% remote work may be awarded based upon experience and expertise of the selected candidate.

Minimum Education:

1. Bachelor’s degree from an accredited college or university by date of appointment.
 Or, in lieu of Bachelor’s degree:
 2. Associate’s degree plus an additional combination of education or experience in IT equivalent to two years.
 Or
 3. High school diploma or GED plus an additional combination of education or experience in IT equivalent to four years.

Preferred Education:



Minimum Experience:

One year’s experience working in higher education, nonprofit, or public sector developing and maintaining data reporting systems and infrastructure. Strong technical expertise in data management, development of database applications and understanding of business intelligence and relational database concepts. Experience gained through professional employment or internship experience will count towards this requirement.    Competency and proficiency with ETL using a variety of data sources and destinations.

Preferred Experience:

Three or more years of database experience.

Duties and Responsibilities:

  • Develop and generate complex data extracts from the Ball State ERP System (Oracle/Ellucian Banner) in order to populate and maintain the BSU data warehouse environment. Performs coordination, analysis, and systems tasks including design, programming, testing, and documentation (Meta data) of new and existing data sources related to institutional data views for historical reporting responsibilities.

  • Work with Banner ERP System and Oracle database development tools such as SQL Developer in writing SQL code and periodically compiling and maintaining PL/SQL statements.  

  • Support the enterprise database server environment, providing analysis, design, development, implementation, documentation, backup, restore and additional routine types of database support.

  • Maintain database servers and software to ensure that it is up to date and configured with best practices as defined by the software vendor and university policies.

  • Evolve existing systems, processes and procedures with best practices in database analysis, design, and creation.   Assist with process improvement within and outside of IT.

  • Exercise considerable decision-making responsibility with determining the appropriate source and data definitions to address data infrastructure issues, reporting, and compliance mandates. Resolve data issues as directed by the supervisor and relevant university committees.

  • Provide rapid incident response and speedy resolution for database problems. Document resolutions to incidents and prepare operational plans to ensure that the incident is not repeated.

  • Establish and maintain working relationships with service providers, vendors, other IT departmental units and other areas of the university.

  • Support the use of appropriate information security controls to protect systems. Manage user access to all enterprise databases in accordance with the policies determined by the Director of Enterprise Information Systems.

  • Perform other related duties as assigned.



At Ball State University, we recognize inclusive excellence as an integral endeavor to fulfill our University’s mission and our strategic plan. We recruit, support, and retain a diverse population of students, faculty, and staff. We encourage and reward diversity of thought. We promote a work environment that encourages and rewards innovation and creativity. We pledge to keep Inclusive Excellence at the highest level of institutional importance and as a foundation in all that we strive to do. Our over-arching goal for Inclusive Excellence is to adopt a university-wide Inclusive Excellence approach to academic, administrative support, and service functions of the university. We believe Inclusive Excellence must be infused in every step we take.


Apply Now

Please mention to the employer that you saw this ad on Sciencejobs.org

More Info

Job posting number:#7089620 (Ref:BSU28355)
Application Deadline:Open Until Filled
Employer Location:Ball State University
Muncie,Indiana
United States
More jobs from this employer
Institution Website