Pharmacy Data Analyst I, II or III (DOE)

Pharmacy Data Analytics is responsible for providing proactive reporting solutions and advanced data analytics in support of the strategic goals of the corporation. The Pharmacy Data Analyst supports pharmacy management decisions and corporate key initiatives through leadership functions and long-term solutions development. The Analyst is a highly skilled technical resource and possesses the ability to manage complex projects and solve issues with large financial impact and/or risk to the corporation. The Analyst is key in supporting pharmacy services successful transformation of healthcare.

Key Qualifications and Experience

• Bachelor’s degree in Business, Health Information Administration, Mathematics, Statistics, Computer Science or related field and 2+ years relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems. OR an equivalent combination of education and experience.
• Must have advanced SQL knowledge and report-writing capabilities.
• Proficient using data access tools, specifically Oracle suite of tools, Microsoft Access, SQL Navigator, etc.
• Proficient with word processing (MS Word) and spreadsheet (MS Excel) programs. Must be proficient with pivot tables, imports, vlookups, functions, macros and VBA.
• Advanced analytical and problem-solving skills.
• Ability to recognize issues and problems; helps identify, document and implement the solution.
• Well-developed business sense (finance, accounting, statistics, risk management, project management).
• Solid oral and written communication skills. Interface effectively with internal and external customers.
• Able to identify need for and lead the creation of desk procedures, validating for accuracy and departmental cohesiveness. Lead interdepartmental training activities.
• Proven ability to perform difficult analytical tasks with minimal supervision.
• Ability to work well independently or with a team. Mentors/coaches others. May direct or lead Analyst I or II on projects.
• Ability to be creative and innovation in the application of data and information to support strategic and tactical planning.
• Ability to develop methodologies and approaches for new tasks and projects.
• Strong understanding of all relevant corporate data systems including claims, membership, pricing and provider data systems.
• Knowledge of provider reimbursement methodologies, managed care principles, underwriting and actuarial principles helpful.
• Familiarity with medical terminology, diagnosis and procedure coding is helpful.

• Must have advanced/complex SQL knowledge and report-writing capabilities. Seen as department expert.
• Proficient using data access tools, specifically Oracle suite of tools, Microsoft Access, SQL Navigator, SQL, VBA, ODBC, report development, form development, imports specs and case selects, etc.
• Advanced skills with word processing (MS Word) and spreadsheet (MS Excel) programs.
• Highly advanced analytical and problem-solving skills.
• Excellent oral and written communication skills. Ability to effectively present to all levels of management.
• Proven ability to work independently with complex projects with large financial impact and/or risk to the corporation.
• Proficient understanding of all relevant corporate data systems including claims, membership, pricing and provider data systems.

• Pharmacy Data Analyst I would have a Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field and 2 years’ relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience.
• Pharmacy Data Analyst II would have a Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field and 4 years’ relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience.
• Pharmacy Data Analyst III would have a Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field and 6 years’ relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience.

If you’re seeking a career that affects change in the health care system, consider joining our team at Cambia Health Solutions. We advocate for transforming the health care system by making health care more affordable and accessible, increasing consumers’ engagement in their health care decisions, and offering a diverse range of products and services that promote the health and well-being of our members. Cambia’s portfolio of companies spans health care information technology and software development; retail health care; health insurance plans that carry the Blue Cross and Blue Shield brands; pharmacy benefit management; life, disability, dental, vision and other lines of protection; alternative solutions to health care access and free-standing health and wellness solutions.