Data Integration Specialist
- Employer
- Ball State University
- Location
- Indiana, United States
- Salary
- Salary Not Specified
- Date posted
- Jan 25, 2023
View more
- Position Type
- Faculty Positions, Science, Technology & Mathematics, Computer Sciences & Technology, Administrative, Academic Affairs, Instructional Technology & Design (Campus), Business & Administrative Affairs, Computer Services & Information Technology, Technology Administration/Other, Chief Technology & Information Officers
- Employment Type
- Full Time
You need to sign in or create an account to save a job.
Job Details
Posting Details
Position Information
Position Title
Data Integration Specialist
About this Opportunity
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.
Inclusive Excellence Statement
At Ball State University, inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We encourage applicants to familiarize themselves with our Inclusive Excellence Plan to learn more about our commitment and to identify how you might contribute to these efforts.
Benefits and Community
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/benefits-and-community/professional-staff
Live Near Your Work - If you are considering living near the Ball State area, please visit the following link to learn more about relocation and living in east central Indiana:
https://www.bsu.edu/about/live-near-your-work
FLSA
Computer Professional Exemption
Hrs/Week
40
Length of Assignment
Full-Time At-Will
Position 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.
Minimum Other
Proven analytical skills to acquire an understanding of business process workflow; strong communication and organizational skills. Must be willing to own responsibility for critical information systems; must be willing to work evening and weekends as needed to support scheduled updates, and respond to unplanned outages on a 24 hour-a-day, 365 day-a-year basis.
Authorization to work in the US
Candidates for searches must have current authorization to be employed in the U.S. without employer sponsorship.
Preferred Education
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.
Preferred Other
Pre-Employment Screening
Requires successful completion of a background check.
Position Title(s) Supervised
None.
Required Certifications
EEO Statement
Ball State University is an Equal Opportunity/Affirmative Action employer that is strongly and actively committed to diversity within its community. Women, minorities, individuals with disabilities and protected veterans are strongly encouraged to apply. All qualified applicants will receive equal consideration for employment without regard to race, color, ethnicity, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, disability, protected veteran status or any other legally protected status.
About Ball State University
Ball State University is located in Muncie, Indiana, on an attractive campus 45 miles northeast of Indianapolis. Approximately 22,000 graduate and undergraduate students enroll in one of eight academic colleges that offer 120 undergraduate programs. We offer more than 140 master’s, doctoral, certificate, and specialist degrees, with many of them ranking among the best in the nation. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world.
There's more to discover IN Indiana! Visit the following link to learn more:
IN Indiana
Department
Information Technology Services:120040
Department Information
The minimum salary for this position is $65,000.00.
Department Email or Phone Number
285-6767
Duties & Responsibilities
Ranking
1
Job Duty
Ensure accuracy and integrity of data and applications through analysis, coding, documentation and problem resolution.
Ranking
2
Job Duty
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.
Ranking
3
Job Duty
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..
Ranking
4
Job Duty
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.
Ranking
5
Job Duty
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.
Ranking
6
Job Duty
Analyze and translate requirements and change requests into technical specifications.
Ranking
7
Job Duty
Perform unit testing, tuning and optimization of ETL processes.
Ranking
8
Job Duty
Provide technical support as needed for assigned systems/applications.
Ranking
9
Job Duty
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.
Ranking
10
Job Duty
Provide business and production support on a 24/7 basis as needed.
Ranking
11
Job Duty
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.
Ranking
12
Job Duty
Perform other related duties as assigned.
Posting Detail Information
Posting Number
202301211P
Number of Vacancies
1
Desired Start Date
03/13/2023
Position End Date (if temporary)
Open Date
01/25/2023
Applications Accepted Through Date
02/07/2023
Open Until Filled
No
Information regarding transcripts
The option to upload transcripts is available. Original, official transcripts showing the highest related degree earned is required at the time of hire (even if obtained at BSU). Degree verification will be conducted.
Special Instructions Summary
Supplemental Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
Position Information
Position Title
Data Integration Specialist
About this Opportunity
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.
Inclusive Excellence Statement
At Ball State University, inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We encourage applicants to familiarize themselves with our Inclusive Excellence Plan to learn more about our commitment and to identify how you might contribute to these efforts.
Benefits and Community
https://www.bsu.edu/about/administrativeoffices/humanresources/jobs/benefits-and-community/professional-staff
Live Near Your Work - If you are considering living near the Ball State area, please visit the following link to learn more about relocation and living in east central Indiana:
https://www.bsu.edu/about/live-near-your-work
FLSA
Computer Professional Exemption
Hrs/Week
40
Length of Assignment
Full-Time At-Will
Position 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.
Minimum Other
Proven analytical skills to acquire an understanding of business process workflow; strong communication and organizational skills. Must be willing to own responsibility for critical information systems; must be willing to work evening and weekends as needed to support scheduled updates, and respond to unplanned outages on a 24 hour-a-day, 365 day-a-year basis.
Authorization to work in the US
Candidates for searches must have current authorization to be employed in the U.S. without employer sponsorship.
Preferred Education
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.
Preferred Other
Pre-Employment Screening
Requires successful completion of a background check.
Position Title(s) Supervised
None.
Required Certifications
EEO Statement
Ball State University is an Equal Opportunity/Affirmative Action employer that is strongly and actively committed to diversity within its community. Women, minorities, individuals with disabilities and protected veterans are strongly encouraged to apply. All qualified applicants will receive equal consideration for employment without regard to race, color, ethnicity, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, disability, protected veteran status or any other legally protected status.
About Ball State University
Ball State University is located in Muncie, Indiana, on an attractive campus 45 miles northeast of Indianapolis. Approximately 22,000 graduate and undergraduate students enroll in one of eight academic colleges that offer 120 undergraduate programs. We offer more than 140 master’s, doctoral, certificate, and specialist degrees, with many of them ranking among the best in the nation. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world.
There's more to discover IN Indiana! Visit the following link to learn more:
IN Indiana
Department
Information Technology Services:120040
Department Information
The minimum salary for this position is $65,000.00.
Department Email or Phone Number
285-6767
Duties & Responsibilities
Ranking
1
Job Duty
Ensure accuracy and integrity of data and applications through analysis, coding, documentation and problem resolution.
Ranking
2
Job Duty
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.
Ranking
3
Job Duty
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..
Ranking
4
Job Duty
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.
Ranking
5
Job Duty
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.
Ranking
6
Job Duty
Analyze and translate requirements and change requests into technical specifications.
Ranking
7
Job Duty
Perform unit testing, tuning and optimization of ETL processes.
Ranking
8
Job Duty
Provide technical support as needed for assigned systems/applications.
Ranking
9
Job Duty
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.
Ranking
10
Job Duty
Provide business and production support on a 24/7 basis as needed.
Ranking
11
Job Duty
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.
Ranking
12
Job Duty
Perform other related duties as assigned.
Posting Detail Information
Posting Number
202301211P
Number of Vacancies
1
Desired Start Date
03/13/2023
Position End Date (if temporary)
Open Date
01/25/2023
Applications Accepted Through Date
02/07/2023
Open Until Filled
No
Information regarding transcripts
The option to upload transcripts is available. Original, official transcripts showing the highest related degree earned is required at the time of hire (even if obtained at BSU). Degree verification will be conducted.
Special Instructions Summary
Supplemental Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
- Resume
- Cover Letter
- Undergraduate Transcripts
- Master's Transcripts
Company
Founded in 1918 in Muncie, Indiana, the public research university has grown to more than 22500 students
Spirited and motivated, we learn, grow, and take flight. Our faculty and staff—everyone in our community—embrace students as learning partners from day one. In classrooms and labs, in immersive learning projects, on the sports fields—with creativity and determination—Cardinals Fly. We are grounded in our values, lifted by our knowledge, and go confidently upward toward ever greater opportunities. Ours is a simple promise: to challenge each other to excel. And with Beneficence as our guide—We Fly.
We are committed to excellence through a talented and diverse faculty and staff. Inclusiveness and freedom of expression are a part of our enduring values and inform all of our efforts. We engage students in educational, research, and creative endeavors that empower our graduates to have fulfilling careers and meaningful lives enriched by lifelong learning and service, while we enhance the economic, environmental, and social vitality of our community, our state, and our world. We are excited that you want to join us in these endeavors!
The university offers excellent benefits, including health care and retirement plans, tuition assistance for employees and dependents, and generous time off with pay.
You need to sign in or create an account to save a job.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert