Data Specialist: KPI Dashboards & Automation

ADP, Inc.; Niles (IL); On-site; USD 34,000 - 39,000; Full time

Job summary

ADP, Inc. is seeking a Data Specialist in Niles, IL to transform raw data into actionable insights, develop KPI dashboards, and automate ETL processes to improve accuracy and efficiency.

You will write Python scripts, query SQL databases, and integrate data from multiple sources while ensuring data quality for real-time decision-making across departments. Collaborating with clinical staff, administrators, and IT, you will deliver tailored data solutions that enhance operational effectiveness and

Qualifications

• Bachelor’s degree in a related field required.
• Experience querying large datasets with SQL.
• Proficient in Python for data manipulation and automation.
• Experience creating KPI dashboards using Tableau or Power BI.

Responsibilities

• Design, develop, and maintain interactive KPI dashboards to monitor health care performance metrics and program outcomes.
• Automate data extraction, transformation, and loading (ETL) processes to streamline reporting workflows and improve data accuracy.
• Write and optimize Python scripts for data analysis and integration from multiple sources including SQL databases.
• Conduct rigorous quality control checks to validate data consistency, completeness, and reliability before dissemination.
• Collaborate with cross-functional teams including clinical staff, administrators, and IT to understand data needs and deliver tailored solutions.

Skills

SQL

Python scripting

KPI dashboards

Data quality control

ETL automation

Education

Bachelor's degree in Data Science, Computer Science, Health Informatics or related field

Master's degree in a relevant discipline

Tools

Tableau

Power BI

Job description

ADP, Inc. is seeking a Data Specialist in Niles, IL to transform raw data into actionable insights, develop KPI dashboards, and automate ETL processes to improve accuracy and efficiency.

You will write Python scripts, query SQL databases, and integrate data from multiple sources while ensuring data quality for real-time decision-making across departments. Collaborating with clinical staff, administrators, and IT, you will deliver tailored data solutions that enhance operational effectiveness and