Data Integration Specialist

Ball State University

Muncie, IN

Job posting number: #7122278 (Ref:BSU35549)

Posted: January 27, 2023

Application Deadline: Open Until Filled

Job Description

Coordinate the movement, manipulation, integration, quality and availability of data throughout the enterprise. Provide Extract, Transform and Load (ETL), data integration expertise and support for the university's databases and systems. Implement data management solutions within a variety of systems/applications. Working collaboratively with the end-users of systems to define system and process requirements, analyze business requirements and source systems to design and develop ETL solutions using a variety of toolsets. Responsible for the design and development for extraction and transformation mappings from source to target data stores. Provide technical support as needed for assigned systems/applications. 100% remote work may be awarded based upon experience and expertise of the selected candidate.

Ball State University is seeking a developer to build the next generations of data integrations. As a Data Integration Specialist you’ll take a hands on role in creating processes to transfer data between our Banner ERP system and a variety of other systems for campus. Some of the integrations you will be involved with and learn on the job include Oracle PL/SQL, Microsoft SQL Server, REST Api, .Net, Python, Perl, and others. You will also play a key role in ensuring the long term success of key systems across the enterprise. Your role will also work collaboratively with the campus community to design and build process improvements across all business units. If you are ready start a rewarding career in programming and system development, we’d like to talk with you.

Job Function:

Coordinate the movement, manipulation, integration, quality and availability of data throughout the enterprise. Provide Extract, Transform and Load (ETL), data integration expertise and support for the university's databases and systems. Implement data management solutions within a variety of systems/applications. Working collaboratively with the end-users of systems to define system and process requirements, analyze business requirements and source systems to design and develop ETL solutions using a variety of toolsets. Responsible for the design and development for extraction and transformation mappings from source to target data stores. Provide technical support as needed for assigned systems/applications. 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.

Minimum Experience:

One year of IT Experience with integrating systems or providing IT support. Relevant technology experience in a classroom setting may be considered as appropriate.

Preferred Experience:

Three years of integrations experience with Oracle, Microsoft SQL Server, Web Services or .Net. Experience as a primary point of support on enterprise system in a university setting.

Duties and Responsibilities:

  • Ensure accuracy and integrity of data and applications through analysis, coding, documentation and problem resolution.
  • Create and maintain the scripts and processes required to extract, transform, review and move data and metadata to the appropriate data store. Review business problems and design appropriate solutions using various ETL toolsets.
  • Meet with functional units to define projects; discuss work progress and problem resolution; ensure the strategic goal of implementing comprehensive and integrated information systems are met..
  • Develop solutions using the software development tools and database management systems that are deemed acceptable by the institution, including reviewing emerging database technologies and providing recommendations? maintain a current working knowledge of these tools and technologies.
  • Develop gap analysis between current state and desired state from a data perspective. Assist with the creation of a set of data standards to guide developers.
  • Analyze and translate requirements and change requests into technical specifications.
  • Perform unit testing, tuning and optimization of ETL processes.
  • Provide technical support as needed for assigned systems/applications.
  • Provide ITS staff and functional unit technical staff technical support and training in the tools and technologies in the ETL processes and data stores as appropriate.
  • Provide business and production support on a 24/7 basis as needed.
  • Support the ITS staff in the development of long-range planning strategies that will continue to allow the IT staff to provide optimum service to clients.
  • 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 DiversityWork.com

More Info

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