Business Technology Analyst Visa Sponsorship Jobs in Illinois

Location: Macomb, IL
Category: Administrative, Professional & Staff Positions
Job Type: FT - Continuous
Posted On: Wed Nov 11 2026

Job Description:

Responsibilities: This position works under direct administrative supervision of an ITTA-Data Services Technician IV and is responsible for learning to perform database administration functions and use database administration tools. This position learns Extract, Transformation and Load (ETL) programming techniques, which includes testing, configuring, maintaining and documenting ETL jobs. The employee learns relational database management concepts and data warehousing best practices.

• Learns to use software tools and utilities to create, modify, and maintain database objects
• Learns database and data warehouse programming standards
• Learns and/or develops and tests Extract, Transformation, and Load (ETL) modules based on predefined specifications
• Provides effective communications with direct supervisor and peers
• Learns and gains knowledge in database creation and design, data warehousing, dimensional design and business intelligence
• Learns to understand and assess source system data issues and recommends solutions from data integration standpoint
• Learns and/or designs, codes, and writes unit test cases from functional requirements
• Learns and/or performs maintenance and support of enterprise ETL jobs, including deploying ETL mappings

WORK LOCATION: Macomb Campus

APPOINTMENT: As soon as possible

MONTHLY WAGE: $3,905-$4,295 (Anticipated starting salary of $3,905)

Western Illinois University employees may be eligible for a variety of State of Illinois benefits. These benefits are administered through the Illinois Department of Central Management Services (CMS). These benefits include: Health Insurance plans, (HMO's, OAP's, QCHP, and CDHP), Dental Insurance, Vision Plan, Life Insurance, Accidental Death & Dismemberment (AD&D), Supplemental Long-Term Disability (LTD), Flex Spending Accounts (HAS, MCAP, and DCAP), 403(b) Supplemental Retirement Plans and 457(b) Deferred Compensation Plans.

Eligible employees are required to participate in the State Universities Retirement System (SURS). SURS is the retirement administrator for employees in public higher education in the State of Illinois.

Other benefits available to eligible employees include: paid time-off, Employee Assistance Program, Tuition Waiver programs, and discounts to the local YMCA.

For a full list of benefits as a WIU employee, please visit our Benefits Homepage: http://www.wiu.edu/vpas/human_resources/benefits/.

For questions on benefits, or eligibility, contact our benefits team at HR-Benefits@wiu.edu or by calling 309-298-1971.

Job Requirements:

1. High school diploma or equivalent.

2. Any one or any combination totaling two (2) years (24 months) from the following categories:

A. College coursework which includes Information Technology (IT), IT Management, Programming, IT systems, or a closely related discipline, as measured by the following conversion table or its proportional equivalent:
- 30 semester hours equals one (1) year (12 months)
- Associate's Degree (60 semester hours) equals eighteen months (18 months)
- 90 semester hours equals two (2) years (24 months)
- Bachelor's Degree (120 semester hours) equals three (3) years (36 months)

B. Work experience in IT-related functions, such as hardware/software support, programming, network design, network engineering, IT systems integration, or closely related field.

1. Two (2) or more years of experience in programming, analysis, or systems technology field.

a. At least four (4) months of work experience utilizing SQL with a relational database

b. At least four (4) months of work experience in ETL design or batch programming

Pre-graduation applicants are welcome to apply. In order to be considered for employment, the degree must be conferred at the time of application, unless applicant is in the final semester of a degree program; if so, the degree must be conferred at the time of appointment. For a degree to be considered, it must be conferred from a regionally accredited degree-granting institution of higher education (or equivalent from an international accrediting body).

Additional Information:

About WIU

Since 1899, Western Illinois University has provided outstanding educational opportunities to individuals in west central Illinois and well beyond our region and state. WIU's traditional residential campus in Macomb, Illinois, is the educational, cultural and athletic center of the region, while the WIU-Quad Cities non-residential branch campus in Moline, Illinois, is the only public university in the immediate Quad Cities region.

WIU-Macomb, IL: Western's traditional, residential main campus offers a comprehensive slate of undergraduate and graduate programs, including a doctorate in education, and post-baccalaureate certificates. A diverse community in west central Illinois, Macomb features a unique blend of agriculture, industry, service, retail, education, and culture. Macomb serves as the county seat, with connections across the state with Amtrak providing twice-daily service from Macomb to Chicago (and point in between). Macomb is located approximately 75 miles from the Quad Cities International Airport (Moline, IL) and 70 miles from the Greater Peoria Regional Airport (Peoria, IL).

WIU-Quad Cities: Located on the banks of the Mississippi River in Moline, Illinois, the WIU-Quad Cities campus is the only public four-year regional university that serves the Quad Cities region. Designed as a metropolitan commuter campus, WIU-Quad Cities offers select undergraduate, graduate, and doctoral programs. Moline is located just 80 miles north of the Macomb campus and is centered within a diverse, bi-state community of 383,000 that offers a broad range of cultural, social, and entertainment amenities and experiences, as well as varied businesses and industries.

Academics

More than 61 undergraduate degree programs, 41 graduate programs, two doctoral programs and 16 post-baccalaureate certificate programs prepare students for a successful career after graduation.

Student Resources

More than 200 student organizations at Western provide social, academic, recreation, athletics, service, academic, and many other opportunities for students to grow and learn, develop leadership skills, and much more.

Numerous concerts, lectures, films, dance performances, cultural events and more are presented and performed each year, along with numerous major theatrical and dance productions and studio shows, and a variety of service-oriented projects and activities.

WIU Intercollegiate Athletics

The University's athletics program, based on the Macomb campus, sponsors 17 NCAA Division I intercollegiate men's and women's varsity sports. All varsity sports compete at the Division I level through The Ohio Valley Conference.