Data Engineer and Program Analyst

Chicago, IL

Full Time

State of Illinois Treasurer's Office

Experienced

JOB OPPORTUNITY ANNOUNCEMENT

Position Title:    Data Engineer and Program Analyst
Division: Operations
Classification:    Exempt
Location: Chicago or Springfield, Illinois
Salary:   $80,000-$95,000

Position Summary:

The Data Engineer and Program Analyst provides critical data analysis and program support for the Illinois State Treasurer’s Office (ISTO). This position will play a key role in informing evidence-based decisions across multiple program areas, analyzing program effectiveness, supporting program operations and developing reports that aid in the optimization of ISTO initiatives. This position works closely with internal teams to collect, ingest, analyze, and interpret complex datasets, supporting program administration and providing insights that drive operational efficiency. Attendance is an essential function of this position.

Duties and Responsibilities:

Conduct data ingestion, validation, and analysis to evaluate the effectiveness and impact of ISTO programs.
Develop reports, dashboards, and data visualizations to communicate key findings and trends to stakeholders.
Analyze program data for trends and anomalies to inform proactive adjustments, focusing on continuous program and process improvements through technology enhancements, automation, system updates, and responses to new legislation.
Coordinate and oversee information exchanges with external vendors and governmental partners, utilizing secure transfer methods (SFTP/FST) to support and enhance ISTO business practices.
Support specific Unclaimed Property initiatives including Money Match and the Direct Mail program.
Support ISTO’s data integrity and security policies by ensuring compliance with data management best practices.
Performs other duties as required or assigned which are reasonably related to the duties enumerated above

Specific Skills:

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Proficiency in data analysis tools such as Excel, SQL, Python, or R.
Familiarity with data visualization software, such as Tableau, Power BI, Looker, or similar tools.
Experience in database management, data cleaning, and data validation.
Strong analytical skills with the ability to translate data into actionable insights.
Excellent written and verbal communication skills, with the ability to present complex data findings clearly.
Detail-oriented with strong organizational and time-management skills.
Familiarity with public sector programs, especially in financial or community services, is a plus.
Familiarity with GIT, GitHub (or similar), and CI/CD best practices is a plus.
Familiarity with cloud-based environments like Microsoft Azure or Amazon AWS is a plus.
Must possess a strong understanding of business process/operations and ability to maintain strong relationships with all levels of staff including Management, Compliance, Legal, and Executive Leadership.

Education and Work Experience:

Bachelor’s degree in computer science, data science, mathematics, public administration, or related field desired; three (3) or more years of experience in data analysis, program evaluation, or a related role, OR any equivalent combination of experience and training that provides the required knowledge, skills, and abilities to carry out the duties of the position.

Illinois State Treasurer Employee Benefits:
As a State of Illinois Employee, you will receive a robust benefit package that includes the following:

A Pension Program
Competitive Group Insurance Benefits including Health, Life, Dental and Vision Insurance
Up to 4 Paid Personal Business Days annually
12 Paid Sick Days annually (Sick days carry over from year to year)
15-25 Days of Paid Vacation time annually - (15 days in year one of employment)
13 Paid Holidays annually, 14 on even numbered years, and 1 Floating Holiday.
12 Weeks Paid Parental Leave
Deferred Compensation Program - A supplemental retirement plan
Optional Pre-Tax Programs such as Medical Care Assistance Plan (MCAP), Dependent Care Assistance Plan (DCAP)
Federal Public Service Loan Forgiveness Program eligibility
Commuter Savings Program (Chicago only)

For more information about our benefits please visit:https://cms.illinois.gov/benefits/stateemployee.html

Application Process: Please visit https://illinoisstatetreasurer.applytojob.com/apply to apply by completing the online application, and uploading a resume and letter of interest.

Equal Employment Opportunity Employer. Applicants must be lawfully authorized to work in the United States.

Applicants are considered for all positions without regard to race, color, religion, sex, national origin, sexual orientation, age, marital or veteran status, or the presence of a non-job related medical condition or disability.

Apply for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Cover Letter*

Who referred you to this position? Enter their first and last name here.*

What's your citizenship / employment eligibility?*

What's your highest level of education completed?*

College or University*

GPA*

Are you 18 years of age or older?*

What languages do you speak fluently?*

Desired salary*

Earliest start date?*

Have you filed an application with our office before?* YesNo

If yes, give date

Have you been employed with our office before?*

If yes, give date

Are you currently employed?*

Are you on a layoff and subject to recall?*

Can you travel if a job requires it?*

How did you hear about this posting?*

If Personal Contact or Other, please specify

Will you now or in the future require visa sponsorship in order to continue employment with the Treasurer?*

Current or Previous Employer*

Current or Previous Employer Address*

Current or Previous Employer Supervisor*

Current or Previous Employer Dates of Employment*

Current or Previous Employer Job Title*

Current or Previous Employer Reason for leaving*

Current or Previous Employer Duties Performed:*

Previous Employer #2*

Previous Employer #2 Address*

Previous Employer #2 Supervisor*

Previous Employer #2 Dates of Employment*

Previous Employer #2 Job Title*

Previous Employer #2 Reason for Leaving*

Previous Employer #2 Duties Performed:*

Previous Employer #3*

Previous Employer #3 Address*

Previous Employer #3 Supervisor*

Previous Employer #3 Dates of Employment*

Previous Employer #3 Job Title*

Previous Employer #3 Reason for Leaving*

Previous Employer #3 Duties Performed:*

Are you currently in compliance with all state and federal income tax requirements?*

Are you a member of the National Guard or a veteran of the U.S. military Service?*

If yes, list branch:

Date of service:

Have you ever been fired from a job? (Downsizing/Layoff is not applicable)*