Enter a job title or keyword

Data Engineer and Program Analyst


Job Location:

Chicago, IL - USA

Monthly Salary: $ 80000 - 95000
Posted: 17 July 2026 (30+ days ago)
Application Deadline: 14 October 2026
Vacancies: 1 Vacancy

Job Summary


JOB OPPORTUNITY ANNOUNCEMENT
Position Title: Data Engineer and Program Analyst
Division: Operations
Classification: Exempt
Location: Chicago or Springfield Illinois
Salary: $80000-$95000

Position Summary:
The Data Engineer and Program Analyst provides critical data analysis and program support for the Illinois State Treasurers 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 validationand 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.
  • Supportspecific Unclaimed Property initiatives including Money Match and the Direct Mail program.
  • Support ISTOs 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:
Bachelors 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: Process:Please visit 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.


Required Experience:

Senior IC


About Company

Company Logo

Explore how Illinois State Treasurer Michael Frerichs is protecting tax dollars and promoting financial literacy for families.

View Profile View Profile