Pharmacy data analyst

Work from home within Oregon, Washington, Idaho or Utah

Build a career with purpose. Join our Cause to create a person-focused and economically sustainable health care system.

Who We Are Looking For

Every day, Cambia’s dedicated team of Data Analysts are living our mission to make health care easier and lives better. As a member of the Pharmacy Services team, our Pharmacy Data Analysts are 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 – all in service of creating a person-focused health care experience.

Are you ready to transform healthcare data into life-changing insights? Do you thrive on solving complex problems with real-world impact? Then this role may be the perfect fit.

Qualifications

What You Bring to Cambia:

• Bachelor's degree in business, health information administration, mathematics, statistics, computer science or related field
• Minimum 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.

Skills And Attributes

• Advanced to expert-level SQL knowledge and complex report-writing capabilities, with proficiency using data access tools including Oracle suite of tools, Microsoft Access, SQL Navigator, VBA, ODBC, report development, form development, import specs, and case selects
• Advanced proficiency with Microsoft Word and Excel, including expertise in pivot tables, imports, vlookups, functions, macros, and VBA
• Comprehensive understanding of corporate data systems including claims, membership, pricing, and provider data systems
• Well-developed business acumen in finance, accounting, statistics, risk management, and project management
• Knowledge of provider reimbursement methodologies, managed care principles, underwriting, and actuarial principles (helpful)
• Familiarity with medical terminology, diagnosis and procedure coding (helpful)
• Experience with AI tools and technologies to enhance productivity and decision-making in professional settings highly desired
• Highly advanced analytical and problem-solving skills with ability to recognize issues, identify solutions, and implement them effectively
• Excellent oral and written communication skills with ability to effectively present to all levels of management and interface with internal and external customers
• Proven ability to work independently on complex projects with large financial impact and risk to the corporation, performing difficult analytical tasks with minimal supervision
• Creative and innovative approach to applying data and information to support strategic and tactical planning, with ability to develop new methodologies and approaches for tasks and projects
• Leadership capabilities to identify needs for and lead the creation of desk procedures, validate for accuracy and departmental cohesiveness, and lead interdepartmental training activities
• Ability to work effectively both independently and collaboratively within a team, with capability to mentor, coach, and direct other analysts on projects.

What You Will Do At Cambia

• Analyze data and prepare comprehensive reports related to health care services, utilization, costs, trends, enrollment, incentives, and revenue across providers, members, networks, groups, products, and lines of business
• Create and modify complex reports and underlying SQL queries, including BOE universes and automated enterprise dashboards, while identifying needed reporting and directing assembly as appropriate
• Perform statistical analysis and data modeling based on user requests, making strategic recommendations that support business objectives
• Validate own work and complex reporting produced within and outside the department, providing final sign-off and defining procedures, processes, and tools to automate validation
• Maintain existing and develop new information reporting systems to support requirements of internal and external users, evaluating impacts of new products, systems, and work processes on data and reporting systems
• Collaborate with departments responsible for transaction systems to ensure reporting data is captured accurately and that data integrity and reliability are maintained throughout the data warehouse
• Develop and execute balancing and validation routines to ensure data warehouse updates are complete, accurate, and maintain integrity
• Assist business analysts across departments with data interpretation and appropriate uses of data tools and reporting algorithms, providing training in query and report preparation to improve consistency
• Make decisions on issues with significant financial impact and risk to the corporation, proactively identifying concerns and bringing them to management attention
• Communicate analysis results and recommendations in both verbal and written form to stakeholders, determining reporting requirements through ongoing dialogue with information users, and may mentor or lead other analysts on projects

The expected hiring range for a Pharmacy Data Analyst I is $57,800 - $80,200 depending on skills, experience, education, and training; relevant licensure / certifications; and performance history. The bonus target for this position is 5%.  The current full salary range for this role is $54,000 - $89,000.

The expected hiring range for a Pharmacy Data Analyst II is $76,500 - $103,500 depending on skills, experience, education, and training; relevant licensure / certifications; and performance history. The bonus target for this position is 10%.  The current full salary range for this role is $72,000 - $117,000.

The expected hiring range for a Pharmacy Data Analyst III is $92,700 - $125,400 depending on skills, experience, education, and training; relevant licensure / certifications; and performance history. The bonus target for this position is 15%.  The current full salary range for this role is $87,000 - $142,000.

About Cambia

Working at Cambia means being part of a purpose-driven, award-winning culture built on trust and innovation anchored in our 100+ year history. Our caring and supportive colleagues are some of the best and brightest in the industry, innovating together toward sustainable, person-focused health care. Whether we're helping members, lending a hand to a colleague or volunteering in our communities, our compassion, empathy and team spirit always shine through.

Why Join the Cambia Team?

At Cambia, You Can

• Work alongside diverse teams building cutting-edge solutions to transform health care.
• Earn a competitive salary and enjoy generous benefits while doing work that changes lives.
• Grow your career with a company committed to helping you succeed.
• Give back to your community by participating in Cambia-supported outreach programs.
• Connect with colleagues who share similar interests and backgrounds through our employee resource groups.

We believe a career at Cambia is more than just a paycheck – and your compensation should be too. Our compensation package includes competitive base pay as well as a market-leading 401(k) with a significant company match, bonus opportunities and more.

Benefits

In exchange for helping members live healthy lives, we offer benefits that empower you to do the same. Just a few highlights include:

• Medical, dental and vision coverage for employees and their eligible family members, including mental health benefits.
• Annual employer contribution to a health savings account.
• Generous paid time off varying by role and tenure in addition to 10 company-paid holidays.
• Market-leading retirement plan including a company match on employee 401(k) contributions, with a potential discretionary contribution based on company performance (no vesting period).
• Up to 12 weeks of paid parental time off (eligibility requires 12 months of continuous service with Cambia immediately preceding leave).
• Award-winning wellness programs that reward you for participation.
• Employee Assistance Fund for those in need.
• Commute and parking benefits.

Learn More About Our Benefits.

We are happy to offer work from home options for most of our roles. To take advantage of this flexible option, we require employees to have a wired internet connection that is not satellite or cellular and internet service with a minimum upload speed of 5Mb and a minimum download speed of 10 Mb.

We are an Equal Opportunity employer dedicated to a drug and tobacco-free workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, age, sex, sexual orientation, gender identity, disability, protected veteran status or any other status protected by law. A background check is required.

If you need accommodation for any part of the application process because of a medical condition or disability, please email [email protected]. Information about how Cambia Health Solutions collects, uses, and discloses information is available in our Privacy Policy.