Enterprise Data Warehouse and Data Analytics Manager (SPSA)

Job Requisition ID: 46636 

Start date: 4/24/25
Closing Date: 05/08/2025
​Agency: Department of Healthcare and Family Services
Class Title: SENIOR PUBLIC SERVICE ADMINISTR - 40070 

BPIS: 10003
Skill Option: General Administration/Business Marketing/Labor/Personnel 
Bilingual Option: None
Salary: Anticipated starting salary range $10,500-$12,500/based on experience
Job Type: Salaried
Category: Full Time 
County: Cook
Number of Vacancies: 1
Bargaining Unit Code: None
Merit Comp Code: Federally Funded, Gubernatorial (Management Bill) Exclusion from Collective Bargaining Coverage

****************A RESUME IS REQUIRED FOR THIS JOB POSTING****************

Please attach a DETAILED Resume/Curriculum Vitae (CV) to the MY DOCUMENTS section of your application. You WILL NOT be considered for the position if you attach a CMS100, CMS100b or any other document that is not a Resume or CV.

Why Work for Illinois?

Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.

No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.

Position overview: 

The Department of Healthcare and Family Services is seeking to hire a dynamic, motivated and results driven individual to serve as the Manager of Enterprise Data Warehouse & Data Analytics in the Bureau of Rate Development and Analysis.  This role requires a blend of technical expertise, strategic thinking, and leadership skills to build and manage a high performing, continually improving data organization. The Manager will play a critical role in promoting data literacy across the organization, ensuring that all departments can effectively utilize data to make informed decisions. Collaboration will be a key component of this individual's success and will be required to accomplish the job.  This role sets direction and guides action plans and priorities to meet operational, technical, security, and future state needs of the Enterprise Data Warehouse (EDW). This role will provide leadership, including identification of risks and opportunities, regarding enterprise data with a deep understanding of data governance, data quality, data security, and business intelligence.  The ideal candidate should possess a comprehensive understanding of cloud-based data warehousing, business intelligence concepts, and Master Data Management - particularly in healthcare.

HFS values employees with different backgrounds, life experiences, and talents. 

Employees receive a robust benefit package including:

• Monday-Friday work schedule
• Flexible work schedules are available in many program areas. (Remote work may be an option for certain positions.)
• Health, Life, Vision, and Dental Insurance
• Pension Plan
• Paid Parental Leave
• Deferred Compensation Program and other pre-tax benefit programs (Medical/Daycare)
• Employees earn (12) paid Sick Days annually.
• New Employees earn (10) paid Vacation Days their first year of service and can earn up to (25) paid Vacation Days annually.
• Employees earn (3) paid Personal Days annually.
• (13-14) paid holidays annually (based on start date)

If you are seeking a new opportunity, and this position appeals to you, please apply today!

At the Illinois Department of Healthcare and Family Services (HFS), we value staff as our greatest asset. We work in a spirit of teamwork to help millions of Illinoisans access high quality healthcare and fulfill child support obligations to advance their physical, mental, and financial well-being. We provide healthcare coverage for children and adults through Medicaid and other medical programs, and we help ensure that children receive financial resources from both their parents through Child Support Services. The HFS Office of the Inspector General investigates, audits and reviews program activity to ensure the integrity of our programs is maintained.

HFS is committed to promoting and preserving a workplace culture that embraces diversity, equity, and inclusion.  We welcome and value employees with different backgrounds, life experiences, and talents.  It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement.  In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation. HFS is an equal opportunity employer.

Essential Functions

• Subject to management approval, plans, develops, organizes, and manages the research and analysis activities to manage and assess the Division’s Data Management and Health Services Research Programs
• Serves as full line supervisor
• Manages the daily operations of the Department’s Enterprise Data Warehouse (EDW)
• Plans, develops, organizes, and manages the research and analysis activities to manage the data needs of the Department and external entities
• Attends meetings with Medical Programs Division Administrator and/or Bureau Chief
• Serves as spokesperson representing the department on boards and committees
• Performs other duties as required or assigned, which are reasonably within the scope of the duties enumerated above

Minimum Qualifications

• Requires knowledge, skill, and metal development equivalent to completion of four (4) years of college
• Requires prior experience equivalent to four (4) years of progressively responsible administrative experience in a public or business organization

Preferred Qualifications

• Minimum of three (3) years of professional experience analyzing and/or interpreting Medicaid program policy, guidelines, and operations
• Working knowledge of database architecture and data modeling
• Working knowledge of data engineering and business intelligence tools
• Minimum of three (3) years of experience code utilizing SQL-based languages and similar scripting-based languages
• Minimum of three (3) years of professional experience translating technical concepts to different audiences
• Minimum of three (3) years of professional experience developing and leading data strategies including but not limited to data governance, quality and appropriate tooling
• Minimum of three (3) years of professional experience leading data warehouse development teams using cloud data warehouse platforms
• Minimum of three (3) years of experience supervising staff
• Minimum of three (3) years of experience developing and managing a major data management program for a public or private organization
• Bachelor’s degree in computer science, management information systems, data science, data analytics or related fields

Conditions of Employment

• Requires completion of a background check and self-disclosure of criminal history
• Requires the ability to travel in the performance of duties, with overnight stays as appropriate
• Requires the ability to utilize and maintain state issued equipment such as a laptop
• Overtime is a condition of employment, and you may be requested or required/mandated to work overtime including scheduled, unscheduled or last-minute overtime. This requires the ability to work evenings and weekends
• Certain provisions of the revolving door restrictions contained in 5 ILCS 430/5-45 apply to this position. As a result, the employee should be aware that if offered non-State employment during state employment or within one year immediately after ending State employment, the employee shall, prior to accepting any such non-State employment offer, notify the Office of the Executive Inspector General for the Agencies of the Illinois Governor (OEIG) or may be subject to a fine
• This position has been found to meet the requirements in section 4A-101 of the Illinois Governmental Ethics Act requiring the occupant/employee to file a Statement of Economic Interest. The Illinois Governmental Ethics Act (5 ILCS 420/4A et seq. requires certain state officials and employees to file annual Statements of Economic Interest with the Office of the Secretary of State that will be made available for examination and copying by the public. All employees required to file a Statement of Economic Interest are also required to file the Supplemental Statement of Economic Interest with the Executive Ethics Commission. (See Executive Order 15-09) Fines and penalties apply to untimely filings
  • The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description

 Work Hours:  Monday - Friday 8:30 a.m. - 5:00 p.m. 
Work Location:  401 S. Clinton St., Chicago IL 60607 
Email: HFS.DMPApps@illinois.gov
Posting Group: Leadership & Management

Revolving Door:
Certain provisions of the revolving door restrictions contained in 5 ILCS 430/5-45 apply to this position. As a result, the employee should be aware that if offered non-State employment during State employment or within one year immediately after ending State employment, the employee shall, prior to accepting any such non-State employment offer, notify the Office of the Executive Inspector General for the Agencies of the Illinois Governor (“OEIG”) or may be subject to a fine.

The main form of communication will be through email. Please check your “junk mail”, “spam”, or “other” folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:

• donotreply@SIL-P1.ns2cloud.com
• systems@SIL-P1.ns2cloud.com