Data Analyst Programmer - School of Social Work (146028)

Job description

Description:Data Analyst ProgrammerSchool of Social WorkUniversity of Illinois Urbana-Champaign

Located in Springfield, Illinois

The University of Illinois Urbana Champaign has an opening for a Data Analyst Programmer with the School of Social Work. As a contractor with the Illinois Department of Children and Family Services (IDCFS), the University of Illinois at Urbana-Champaign School of Social Work (SSW) leads national and local research efforts on child maltreatment prevention, child welfare services, and outcomes, designs and tests innovative child welfare interventions, and prepares child welfare workforce.

The Data Analyst Programmer will work within a team environment on Illinois Department of Children and Family Services projects to contribute to scientific knowledge about child safety, family permanence, and child and family well-being and support strategically important goals needed for informed decision making in Illinois child welfare by providing data extraction, data management, data reporting, data analysis, and visualizations.

The University of Illinois is an Equal Opportunity, Affirmative Action employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply. For more information, visit

Major Duties and Responsibilities:

  • Develop well-documented Microsoft SQL and other software scripts to extract, manage, manipulate and analyze complex data from multiple relational tables.
  • Design, test, implement and maintain data collections, data modeling, reports, and visualizations.
  • Write programs to generate presentation-quality tables, reports, spreadsheets, and datasets.
  • Create/define new variables from existing data
  • Analyze and evaluate user data processing needs
  • Test data reports and prepare them for automation.
  • Perform validation of data and quality assurance aspects by analyzing SQL and other software programming activities and procedures as well as comparing output reports to data entry screens.
  • Effectively communicate data analytic procedures, results, and recommendations to the rest of the data team and other relevant stakeholders.
  • Prepare and maintain technical documentation in support of programming, data usage, data exchanges, data analysis, and visualization functions, including job run instructions, user/how-to manuals, system and program diagrams, and program specifications.
  • Provide feedback and informational documentation on the level of effort estimates for user reports, data delivery, and project status updates.
  • Provide expertise and coordination of large project functions to serve user needs and new system development, when appropriate.
  • Participate in and contribute to the IDFCS’s data governance goals, processes, and activities to improve data quality and coordination.
  • Work with the data team and other relevant stakeholders on data quality and application of data.
  • Mentor and advise teammates, as directed by supervisor. Provide input into the planning and execution of technical training programs and seminars on appropriate areas of data processing.
  • Attend meetings and create meeting notes and status reports.
  • Other duties as assigned

Position Requirements and Qualifications:

Required Education and Experience: Three years of progressively more responsible work experience in an Information Technology (IT) related profession. College course work which includes Information Technology (IT), IT Management, or a closely related discipline, 60 semester hours or Associate's Degree equals one (1) year 90-120 semester hours or Bachelor's Degree equals two (2) years. In addition to the following:

  • Experience with relational database management
  • Experience working with Microsoft SQL Server
  • ETL using Microsoft SQL Server Integration and Analysis Services
  • SQL Server Reporting Services (SSRS), and report subscription creation.
  • Experience with Power BI
  • Tableau, or other data visualization software


Education: Bachelor’s degree in Information Management, Computer Science, Mathematics, Statistics, or a scientific discipline required.

Experience: Experience with statistical software programs (Stata, SPSS, SAS) is preferred. Experience and knowledge of the child welfare field is preferred. Prior experience with administrative data systems is preferred.

Knowledge Requirements:

Working knowledge of one of the data visualization software programs. Demonstrated skills in the management and resolution of SQL programming issues. Good oral and written communication skills. Strong analytical and organizational skills. Ability to work independently and effectively follow through with multiple priorities under deadline pressure.

Salary and Appointment Information:

This is a full-time Civil Service Information Technology Technical Associate position appointed on a 12-month service basis located in Springfield, Illinois. There are multiple positions available. Salary is competitive and commensurate with qualifications. The proposed start date is as soon as possible after the closing date.

Applications must be received by July 2, 2021. Apply for this position using the “Apply for Position” button below. If you have not applied before, you must create your candidate profile at If you already have a profile, you will be redirected to that existing profile via email notification. To complete the application process:

Step 1) Submit the Staff Vacancy Application.

Step 2) Submit the Voluntary Self-Identification of Disability forms.

Step 3) Upload the following documents:

  • Cover letter
  • Resume (months and years of employment must be included)
  • Software Skills
  • Academic credentials (unofficial transcripts or copy of diploma may be acceptable) for all degrees attained (if you want to specifically spell out bachelor’s, master’s, and doctorate degrees here, you can)
  • Names/contact information for three references

In order to be considered as a transfer candidate, you must apply for this position using the “Apply for Position” button below. Applications not submitted through this website will not be considered. For further information about this specific position, contact the School of Social Work Human Resources at 217-244-0076 or [email protected]. For questions about the application process, please contact 217-333-2137.

The University of Illinois conducts criminal background checks on all job candidates upon acceptance of a contingent offer. Convictions are not a bar to employment.

As a qualifying federal contractor, the University of Illinois System uses E-Verify to verify employment eligibility.

The University of Illinois must also comply with applicable federal export control laws and regulations and, as such, reserves the right to employ restricted party screening procedures for applicants.

College Name or Administrative Unit:School of Social Work Category:8-Technical Title:Data Analyst Programmer - School of Social Work (146028) Open Date:06/07/2021 Close Date:07/02/2021 Organization Name:School of Social Work




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 6/8/2021
Application Due: 7/2/2021
Work Type: Full Time