You are viewing a preview of this job. Log in or register to view more details about this job.
Email

Job Title: Senior Data Analyst

Job Requisition ID: 48213 

Closing Date: 7/21/2025

Salary: $7,787 a month

Work Hours: M-F 8:30AM - 5:00PM

Work Location: (Hybrid) 320 W Washington St, Springfield, Illinois, 62767

Union Position: Yes

Work authorization: US work authorization required at time of application. No sponsorship available. Not eligible for F1 OPT/CPT. Positions are W2 only and cannot be converted to a contract position. If you have questions about your work authorization eligibility, please email doit.recruitment@illinois.gov. 

Questions? Email doit.recruitment@illinois.gov

Transcripts are required for consideration.

 

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. 

This position serves as the Senior Data Analyst supporting the Illinois Department of Insurance (IDOI). 

In this role, you will perform advanced data analysis, reporting, and data infrastructure support to ensure that data-driven decisions align with business goals. 

You will design and optimize SQL queries, ETL workflows, and dashboards using Microsoft data tools. 

Additionally, you will support continuous improvement by identifying opportunities to streamline data access, enhance reporting capabilities, and promote data quality and integrity across all application systems. 

If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!


As a State of Illinois employee, you receive a comprehensive benefits package including:

  • Competitive Group Insurance benefits including health, life, dental and vision plans
  • Flexible work schedules (when available and dependent upon position)
  • 10 -25 days of paid vacation time annually (10 days for first year of state employment)
  • 12 days of paid sick time annually which carryover year to year
  • 3 paid personal business days per year
  • 13-14 paid holidays per year dependent on election years
  • 12 weeks of paid parental leave
  • Pension plan through the State Employees Retirement System
  • Deferred Compensation Program – voluntary supplemental retirement plan
  • Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
  • Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility


For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx 

 

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.

 

Essential Functions

  • Under administrative direction, serves as the Senior Data Analyst for the Department of Innovation & Technology (DoIT), supporting the Department of Insurance (DOI), directing, creating, monitoring, and maintaining complex relational databases utilizing advanced analysis, design and development software tools to coordinate the development and implementation of complex databases.
  • Advises management of the feasibility and cost effectiveness of conversion of manual processes used in the regulation of the Insurance industry and in processing license applications for insurance companies and insurance agents to database applications.
  • Develops and refines database design and definition standards for Microsoft SQL Server, Snowflake, and Microsoft tools such as Dataverse in collaboration with other team members, under the guidance of the Networks, Database & Applications Manager (DBA).
  • Serves as a project leader on highly complex projects while independently planning, developing, and implementing techniques for gathering and interpreting data and leads data initiatives involving complex data analysis, reporting solutions, and system enhancements that span multiple departments or agencies.
  • Plans and executes training programs and subject matter seminars on advanced data analysis, SQL development, and reporting tools to enhance team skills and capabilities.
  • Collaborates with the SQL team and application developers to monitor, analyze, and report on relational database performance and data usage, supporting optimization of application processes and maintenance schedules.
  • Keeps abreast of new developments in the information technology field by continuing education through online training platforms, meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
  • Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.

 

Minimum Qualifications

  • Requires knowledge, skill, and mental development equivalent to four (4) years of college with coursework in computer science or directly related fields.
  • Requires three (3) years of professional experience in Application Services or a related Information Technology field.
     

Preferred Qualifications

  • Three (3) years of professional experience designing and implementing complex database structures using Microsoft SQL Server, including development of stored procedures, triggers, and performance-tuned queries
  • Three (3) years of professional experience using Microsoft data tools, including SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, and ODBC for data connectivity, in support of relational database management.
  • Three (3) years of professional experience developing and maintaining ETL workflows to support enterprise data integration and reporting across systems.
  • Three (3) years of professional experience performing complex data analysis, including writing and optimizing advanced SQL queries, and evaluating database performance metrics.
  • Three (3) years of professional experience using data visualization and reporting platforms such as Microsoft Power BI, SSRS, or comparable tools to develop dashboards and support decision-making
  • Three (3) years of professional experience planning and delivering training or seminars related to database systems, reporting tools, or data analysis methodologies.
  • One (1) year of professional experience monitoring, diagnosing, and resolving relational database performance issues or executing database optimization tasks.
  • Ability to develop and maintain collaborative relationships with cross-functional teams to support the implementation of data standards, workflow improvements, and application enhancements across departments or agencies.
  • Ability to coordinate and guide the activities of team members to achieve project goals and organizational objectives.
  • Ability to communicate technical information clearly in verbal and written formats to audiences with varying levels of technical expertise, including executive leadership.

 

Conditions of Employment

NOTE: Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position. 

  • Requires the ability to verify identity.
  • Requires employment authorization to accept permanent full-time employment with State of Illinois.
  • Requires the ability to pass a position specific, agency required background check.
  • Requires self-disclosure of criminal history.
  • Requires the ability to travel in the performance of duties.
  • Requires the ability to work outside of normal hours to meet deadlines.
  • Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
  • Requires the ability to attend seminars, conferences and training to remain current on methods, tools, ideologies or other industry related topics relevant to job duties.
  • Requires the ability to lift and carry objects or equipment weighing up to 20 pounds This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.


The conditions of employment listed are incorporated and/or related to any duties included in the position description.