Senior Data Solutions Analyst

Scope of Responsibilities

• Partner cross functionally to understand underlying business issues and utilize technology and reporting to create tools/processes to create efficiencies.
• Spearhead initiatives that eliminate manual work and repetitive tasks.
• Assist in impact and other financial analysis that will be presented to Senior Management.

Job Summary

• 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 senior leadership team.
• Create automated solutions to improve efficiencies across departments.
• Provide team leadership and guidance to Data Solutions Analysts.
• 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.
• 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.
• Shares knowledge with peers and others and supports knowledge management efforts.
• Participates 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.

Job Skills Required

• Proficiency in SQL and other coding languages (Python, R, Java, etc.)
• Strong analytical skills
• Strong organizational skills
• Strong interpersonal skills and collaborative ideology
• Strong written and verbal communication skills
• Proficiency in Microsoft desk 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
• 3-5 or more years’ previous experience in the PBM or healthcare industry

Preferred

• 3-5 or more years’ previous experience in the PBM or healthcare industry
• Experience using business intelligence tools such as Power BI