Senior Data Solutions Analyst

KPH HEALTHCARE SERVICES, INC; Chicago (IL); On-site; USD 75,000 - 95,000; Full time

Job summary

A healthcare solutions provider based in Chicago is seeking a Data Solutions Analyst to enhance efficiency through data analysis and reporting. The role involves building automated solutions with SQL, developing data pipelines, and conducting financial analysis for various departments. Candidates should have a Bachelor's in Business or Computer Science and strong SQL skills. Experience in the healthcare industry or with business intelligence tools like Power BI is preferred. The position requires communication and collaboration with department leaders.

Qualifications

• Proficiency in SQL and other coding languages (Python, R, Java, etc.).
• Strong analytical, organizational, interpersonal, and written & verbal communication skills.
• Proficiency in Microsoft desktop tools such as Excel and Access.

Responsibilities

• Build out automated solutions using SQL to solve complex reporting needs.
• Develop data pipelines to automate manual processes.
• Provide and analyze dashboard reporting to drive business decisions.
• Perform various financial analyses such as impact reports and contract pricing analysis.

Skills

Proficiency in SQL

Analytical skills

Organizational skills

Interpersonal skills

Written communication skills

Verbal communication skills

Education

Bachelor's Degree or higher in Business or Computer Science

Tools

Microsoft Excel

Microsoft Access

Power BI

Job description

Overview

This role will require occasional travel to Syracuse, NY for training and meetings. KPH and its affiliates are unable to provide any level of immigration sponsorship now or in the future.

Scope of Responsibilities

The Data Solutions Analyst will partner cross functionally to understand underlying business issues and will utilize technology and reporting to create tools/processes to create efficiencies. As a Data Solutions Analyst, you will spearhead initiatives that eliminate manual work and repetitive tasks and assist in impact and other financial analysis that will be presented to Senior Management.

Job Summary

You will transform and organize data sets, analyze data trends, and create digestible reports and visualizations. Partner with department leaders to analyze data elements to identify opportunities to optimize performance across these departments and provide summary findings to the senior leadership team. Create automated solutions to improve efficiencies across departments.

Responsibilities

• Build out automated solutions using SQL to solve complex reporting and calculating needs.
• Develop data pipelines to automate manual processes.
• Reduce ad-hoc requests through development of automation and dashboards.
• Provide and analyze dashboard reporting to help drive business decisions.
• Recommend systems process improvements for various ProAct departments and ProAct Pharmacy Services.
• Collaborate with various department managers to identify, develop, and maintain reporting needs.
• Perform various financial analysis such as impact reports, contract pricing analysis, and other ad hoc requests.
• Support pricing department with analysis that identifies key trends and areas of improvement.
• Analyze, develop, and present reporting on individual client performance to ensure contractual optimization.
• Create tools with a user interface that will empower new users to run reports easily.
• Maintain appropriate documentation of applications and business processes.
• Support sales operations with business opportunity target analysis and reporting towards sales performance.
• Integrate with operations and develop process improvement roadmap.
• Run reports in a supporting/backup role when needed.
• Assist management with forecasting/annual budget.
• Share knowledge with peers and others and supports knowledge management efforts.
• Participate in developing individual skill sets to meet today and tomorrow’s business needs.
• Responsible for completing all mandatory and regulatory training programs.
• Perform other duties as assigned.

Qualifications

• Proficiency in SQL and other coding languages (Python, R, Java, etc.).
• Strong analytical, organizational, interpersonal, and written & verbal communication skills.
• Proficiency in Microsoft desktop tools such as Excel and Access.

Education

• Required: Bachelor’s Degree or higher in Business or Computer Science.

Experience

• Required: 3-5 or more years’ previous experience in a related position.
• Preferred: 3-5 or more years’ previous experience in the PBM or healthcare industry.
• Preferred: Experience using business intelligence tools such as Power BI.
• Must possess knowledge of security concepts applicable to this role and function.