IT Technical Associate (Data Services Technician I)

Western Illinois University Quad Cities

Moline (IL)

On-site

USD 44,000 - 48,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Western Illinois University Quad Cities seeks an IT Technical Associate (Data Services Technician I) to learn and assist in database administration, ETL development, and data warehousing practices. You will build ETL modules, test mappings, and document processes under supervision.

The role emphasizes SQL usage, data integration, and collaboration with the IT team to support enterprise data needs. This entry-level position offers growth within the university IT department.

Qualifications

  • High school diploma or equivalent.
  • Two years in IT-related functions (programming, analysis, or systems technology).
  • At least four months of SQL experience with a relational database.
  • At least four months of ETL design or batch programming.
  • Pre-graduation applicants may apply; degree must be conferred at appointment time.

Responsibilities

  • Learns to perform database administration functions and use database tools.
  • Learns ETL modules based on predefined specifications.
  • Gains knowledge in data warehousing, dimensional design and BI.
  • Maintains and documents ETL jobs and mappings.
  • Communicates effectively with supervisor and peers.

Skills

Programming
SQL
ETL
Data warehousing
Analytical thinking

Education

High school diploma or equivalent

Tools

SQL
ETL tools

Job description

IT Technical Associate (Data Services Technician I)

Category: Administrative, Professional & Staff Positions

Department: ADMINISTRATIVE INFORMATION MANAGEMENT SYSTEMS

Locations: Macomb, IL

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:

http://wiu.edu/about

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.

http://wiu.edu/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.

http://wiu.edu/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.

To apply, visit https://apptrkr.com/9964921

je-ed932ae638464388b7c73f9364e37738

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
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
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
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
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
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
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
Director of Student-Athlete Success & Support / Academic Advisor
Director of Student-Athlete Success & Support / Academic Advisor

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 53,000 - 57,000
Health insurance
Dental insurance
Vision plan
+7
Western Illinois University
Western Illinois University

ChamberMaster • Macomb (IL)

On-site
USD 53,000 - 57,000
Health Insurance
Tuition Waiver
Paid time-off
Assistant Women’s Basketball Coach
Assistant Women’s Basketball Coach

Western Illinois University Quad Cities • Moline (IL)

On-site
USD 40,000 - 45,000
Health Insurance
SURS Retirement
Tuition Waiver
+1