Employment

Job Opening - Civil Service

IT Technical Associate-DATA ARCHITECT

Classification specification from State of Illinois
  • Code No.: 5031
  • Probation Period: 12 Months
  • Class Title: IT Technical Associate
  • Effective Date: February 06 2013
  • Occupational Area: Professional
  • Promotional Line: None
  • Work Area: AIMS (Administrative Information Management Systems)
  • Application Deadline: March 01 2013
  • Complete State Universities Civil Service System job specification

Additional Information:Completed application, transcript(s), and resume are due no later than 4:30pm on Friday, March 1st, 2013 in the WIU Human Resource Office, Sherman Hall 105, Macomb, Illinois, 61455. (309)298-1971. Preference may be given to Illinois Residents.
Additional Required Qualifications:
*Must have experience with Extract, Transform and Load tools (Pentaho or Ab Initio preferred).
-6 months of experience using Pentaho, Ab Initio, Data Stage, Oracle Warehouse builder, Informatica, or other ETL tool.

*Must be able to write and tune SQL statements.
-1 year of professional experience writing or maintaining SQL code.

*Have demonstrable knowledge of relational database design and normalization processes.
-1 year of professional experience using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.

*Also required is hands-on experience with software engineering processes and methodologies.
-1 year of professional experience in software development lifecycle

*Should know Relational Database Management Systems (RDBMS) concepts, DB2 LUW preferred.
-1 years of professional experience using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.

*Should be familiar with both normalized and dimensional data models.
-1 year using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.

*Familiarity with code repository check-in and check-out procedures.
-1 year professional experience in software development lifecycle

*Experience with Business Intelligence (BI) solutions and Linux is a plus.
-Any professional experience beneficial

*Experience with data modeling and OLAP cubes huge plus.
-Any professional experience beneficial


The starting salary for this position is $3,242.00/month


Civil Service Employment – Information & Instructions

Complete a Job Application online. Please include all employment history on your application.

For an application to be considered complete, supplemental application materials, which may include transcripts, licenses, certifications, and/or a copy of the DD214 (if applicable), should be submitted to the Human Resources Office.

Applicants with completed applications will be contacted to set-up an application evaluation appointment. During the application evaluation your qualifications will be reviewed. If you meet the minimum acceptable qualifications, an appointment for testing will be scheduled for a later date. If you have any questions regarding this process, you may call the Examination Division at (309) 298-1971.

If you believe that you may require a reasonable accommodation during the application evaluation or examination(s), please notify the Human Resource Office at (309) 298-1971, prior to date of the evaluation or examination appointment.

Applications will be reviewed and if you qualify you will be called to set-up an appointment for testing as soon as possible. If you have any questions in regard to this process, you may call the Examination Division at (309) 298-1971.

If you believe that you may require a reasonable accommodation during the application evaluation or testing process, please notify the Human Resource Office at (309) 298-1971, prior to date needed so that appropriate arrangements can be made.

Supplemental application materials can be delivered in person or sent to:

Human Resources Office
Sherman Hall Room 105
1 University Circle
Macomb, IL 61455
Fax: (309) 298-2300

Open: Monday - Friday 8:00 a.m. – 4:30 p.m.

Western Illinois University is an Affirmative Action and Equal Opportunity employer with a strong commitment to diversity and a non-discrimination policy that includes sex, race, color, sexual orientation, gender identity and gender expression, religion, age, marital status, national origin, disability, or veteran status.