IT Technical Associate (Data Services Technician I) - Western Illinois University

Interview Exchange

Macomb (IL)

On-site

USD 44,000 - 48,000

Full time

11 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health Insurance
Dental Insurance
Vision Plan
Life Insurance
Retirement Plans (SURS, 403(b), 457)
Tuition Waiver
Paid time-off

Job summary

Western Illinois University is seeking a FT ITTA-Data Services role on Macomb campus. You will learn and perform ETL, SQL, and data warehousing tasks under supervision, growing in database administration, BI concepts, and enterprise data integration.

Starting wage is commensurate with experience, with full Illinois state benefits and a benefits team contact for questions. This role offers a clear learning path and opportunities in BI and data management at WIU.

Qualifications

  • High school diploma or equivalent required.
  • Two years of IT coursework or work experience in related IT fields.
  • Minimum two years in programming, analysis, or systems technology.

Responsibilities

  • Learn to perform database administration tasks under supervision.
  • Develop ETL modules based on predefined specs and test mappings.
  • Gain knowledge in data warehousing, dimensional design, and BI concepts.
  • Use tools to create, modify, and maintain database objects and documentation.
  • Communicate effectively with supervisor and peers.
  • Assist in understanding data issues and propose DB integration solutions.
  • Contribute to unit tests and support enterprise ETL jobs deployment.

Skills

SQL
ETL concepts
Data warehousing
BI concepts
Communication

Education

High school diploma or equivalent
Two years IT coursework/experience

Tools

ETL tools
SQL-based tools

Job description

Category: Administrative, Professional & Staff Positions

Department: ADMINISTRATIVE INFORMATION MANAGEMENT SYSTEMS

Locations: Macomb, IL

Posted: Nov 11, 2026

Closes: Nov 22, 2026 - 11:59 PM EST

Type: FT - Continuous

PositionID: 206615

Recognized as a "Best Midwestern College" by the Princeton Review. Western Illinois University, accredited by the Higher Learning Commission, serves nearly 5,000 students at its traditional, residential campus in Macomb, IL and its metropolitan, non-residential branch campus in Moline, IL.

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 positionlearns Extract, Transformation and Load (ETL) programming techniques, which includes testing, configuring, maintaining and documenting ETL jobs. The employeelearns 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 solutionsfrom 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, includingdeploying 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 questions on benefits, or eligibility, contact our benefits team at HR-Benefits@wiu.edu or by calling 309-298-1971.

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)
  • 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.

3. 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).

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.

More than 61 undergraduate degree programs, 41graduate programs, two doctoral programs and 16post-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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IT Technical Associate (Data Services Technician I)
IT Technical Associate (Data Services Technician I)

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 44,000 - 48,000
Western Illinois University Quad Citi...
Western Illinois University Quad Citi...

Greater Quad Cities Hispanic Chamber of Commerce • Macomb (IL)

On-site
USD 26,000 - 28,000
Health Insurance
Dental Insurance
Vision Plan
+2
Senior Events Coordinator - Western Illinois University
Senior Events Coordinator - Western Illinois University

Interview Exchange • Macomb (IL)

On-site
USD 40,000 - 44,000
Health Insurance
Paid time off
Tuition waiver
+1
Western Illinois University Quad Citi...
Western Illinois University Quad Citi...

Gqchcc • Moline (IL)

On-site
USD 48,000 - 53,000
Health Insurance
Dental Insurance
Retirement plan (401k/403b)
+2
Academic Advisor – Computing, Data, and Mathematical Sciences
Academic Advisor – Computing, Data, and Mathematical Sciences

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 46,000 - 52,000
Health Insurance plans
Dental Insurance
Vision Plan
+1
Associate Director of Student Success, Quad Cities campus
Associate Director of Student Success, Quad Cities campus

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 48,000 - 53,000
Health Insurance plans
Dental Insurance
Vision Plan
+5
QC Office Support Specialist
QC Office Support Specialist

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 25,000 - 28,000
Health Insurance
Tuition Waiver programs
Employee Assistance Program
+1
Program Coordinator (Student Support Coordinator)
Program Coordinator (Student Support Coordinator)

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 45,000 - 49,000
Health Insurance
Dental Insurance
Vision Plan
+5
Associate Director of Student Success, Quad Cities campus - Western Illinois University
Associate Director of Student Success, Quad Cities campus - Western Illinois University

Western Illinois University • Macomb (IL)

On-site
USD 48,000 - 53,000
Admissions Counselor, Military Affiliated
Admissions Counselor, Military Affiliated

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 46,000 - 52,000
Health Insurance plans (HMO’s, OAP’s,Q
Dental Insurance
Vision Plan
+11