This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13863054 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. 1. Learns to use software tools and utilities to create, modify, and maintain database objects, 2. Learns database and data warehouse programming standards, 3. Learns and/or develops and tests Extract, Transformation, and Load (ETL) modules based on predefined specifications 4. Provides effective communications with direct supervisor and peers 5. Learns and gains knowledge in database creation and design, data warehousing, dimensional design and business intelligence 6. Learns to understand and assess source system data issues and recommends solutions from data integration standpoint 7. Learns and/or designs, codes, and writes unit test cases from functional requirements 8. 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 func ions, 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). 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