Statewide IL - IT Technology Associate L2 (Business Analytics & Reporting Technician)

Location : Springfield, IL, USA Department : Division of Specialized Care for Children

FTE : 1

Work Schedule : Monday - Friday 8am - 4:30pm Workplace Type : Hybrid Position Summary Supports DSCC's mission by developing and maintaining enterprise analytics and data engineering solutions that transform complex data into actionable insights. The role enhances existing BI assets — including Power BI reports, semantic models, and automated refresh processes — while building scalable data pipelines and analytics platforms. This position leverages modern cloud and big data technologies such as Microsoft Azure Data Lake, Azure Synapse Analytics, Azure Databricks, Microsoft Fabric, Python, SQL, and Apache Spark to ingest, process, and analyze large and diverse datasets. Responsibilities include designing ETL/ELT workflows, optimizing data models, and supporting lakehouse architecture for reporting and advanced analytics. Working with DSCC business units and the PMO, the role applies statistical analysis, machine learning techniques, and automation to identify trends and deliver predictive insights. The position also supports DSCC's Reporting and Data Governance Framework. Duties & Responsibilities Design, maintain, and enhance Power BI dashboards, reports, and semantic models to deliver accurate and actionable insights for DSCC leadership and operational teams. Design and implement enterprise reporting and analytics solutions that support operational monitoring, strategic planning, and data-driven decision making across DSCC programs. Develop and maintain scalable cloud-based data architectures including data lake and lakehouse environments to support enterprise analytics and large-scale data integration. Design and manage automated data pipelines and transformation workflows using modern data engineering practices to ingest, process, and prepare large datasets for analytics and reporting. Work closely with DSCC business units and the PMO to gather requirements, translate business needs into technical solutions, SSIS packages, and ensure analytics solutions align with organizational priorities. Maintain and optimize SQL Server databases and query performance to support reliable and efficient analytics workloads. Develop and maintain enterprise data models, semantic layers, and optimized data structures to support reporting, advanced analytics, and scalable data access. Apply statistical analysis and machine learning techniques using tools such as Python or Spark ML to identify patterns, trends, and predictive insights where appropriate. Ensure compliance with DSCC data governance policies, HIPAA regulations, and PHI protection standards while maintaining strong data quality and lineage practices. Provide training and technical guidance to staff on Power BI, data access tools, and self-service analytics capabilities. Participate in cross-functional teams to support DSCC’s quality improvement and operational initiatives to improve data processes, automation, and enterprise analytics capabilities. Strong orientation toward customer service, data accuracy, and clear communication with non‑technical users. Minimum Qualifications Bachelor’s Degree in Computer Science or a closely related field of study. Minimum of five years of professional-level IT experience in BI Data Analytics & Integration, including demonstrated experience in designing, implementing, and supporting application interfaces, and developing, modifying, distributing, and testing reports, metrics, dashboards, and self‑service reporting capabilities. Master’s degree in Information Technology, Computer Science, Data Analytics, or a related field. Minimum of five years of experience in business intelligence/reporting roles. Expert-level proficiency in Power BI, SQL Server, SSIS, data science/big data concepts, and ETL development; data engineering, cloud data platforms (Azure Data Lake, Synapse, Fabric); understanding of healthcare data and PHI compliance. Data visualization, SQL query writing, and ETL data pipeline development and management (Python, SQL, Spark). Strong collaboration with project managers and business analysts, translating business requirements into technical specifications, and working with care coordination teams. Benefits This position is intended to be eligible for benefits. This includes Health, Dental, Vision, Life Insurance, a Retirement Plan, Paid time Off, and Tuition waivers for employees and dependents. Equal Opportunity The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit Required Employment Notices and Posters to view our non‑discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, and employment eligibility review through E-Verify. Accommodations The university provides accommodations to applicants and employees. Request an Accommodation. Artificial Intelligence Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person. #J-18808-Ljbffr University of Illinois Chicago