- Salary
- $80k – $95k
- Location
- Chicago, IL
- Type
- Full-time
- Department
- Engineering
- Education
- PhD
- Visa
- Not sponsored
- Closing date
- Today
- Source
- ApplyToJob
Description
JOB OPPORTUNITY ANNOUNCEMENT
Position Title: Data Engineer and Program Analyst
Division: Operations
Classification: Exempt
Location: Chicago or Springfield, Illinois
Salary: $80,000-$95,000
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:
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)
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.
Skills
PythonRAWSAzureCI/CDSQLData ScienceGitGitHubExcelTableauPower BILookerCompliance
