Pharmacy Data Analyst I, II, III - DOE
Portland, OR, United States
Cambia Health Solutions
Cambia Health Solutions is a family of companies headquartered in Portland, Oregon, working to create a person-focused and economically sustainable healthcare system. Discover how Cambia’s dedication to cutting-edge innovation and positive...Pharmacy Data Analyst I, II, III
Work from home within Oregon, Idaho, 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 Pharmacy Data Analysts are living our mission to make health care easier and lives better. . As a member of the Pharmacy Informatics team is where you'll leverage your expertise to drive healthcare transformation through advanced analytics and data-driven solutions.
As a Pharmacy Data Analyst, you'll play a pivotal role in shaping strategic decisions by developing sophisticated reporting solutions and conducting complex analyses that directly impact our corporate initiatives. We're seeking a highly skilled technical professional with pharmacy data experience who excels at managing multifaceted projects and solving high-stakes challenges with significant financial implications. Your analytical prowess will be instrumental in supporting pharmacy management decisions and developing innovative long-term solutions. This role offers an exciting opportunity to be at the forefront of healthcare evolution, where your expertise in data analytics will directly contribute to optimizing pharmacy services and advancing our mission of transforming healthcare delivery.
What You Bring to Cambia:
Qualifications:
Pharmacy Data Analyst I
Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field
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
Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field and
5 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.
STARS and MES experience strongly preferred
Pharmacy Data Analyst III
Bachelor’s degree in business, health information administration, mathematics, statistics, computer science or related field
8years’ 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.
STARS and MES experience strongly preferred
Skills and Attributes:
Pharmacy Data Analyst I
Demonstrates advanced SQL expertise and report-writing capabilities, with proficiency in Oracle suite, Microsoft Access, SQL Navigator, and advanced Excel functions (pivot tables, VBA, macros, vlookups).
Possesses strong analytical, critical thinking and problem-solving skills, with ability to independently perform complex analyses and develop innovative methodologies for new projects.
Exhibits comprehensive understanding of corporate data systems (claims, membership, pricing, provider) and healthcare fundamentals including medical terminology, diagnosis/procedure coding, and provider reimbursement methodologies.
Demonstrates well-developed business acumen in finance, accounting, statistics, risk management, and project management, with ability to support strategic and tactical planning through creative data applications.
Excels in written and oral communication, effectively interfacing with internal/external stakeholders while leading interdepartmental training and documentation initiatives.
Creates and validates desk procedures, ensuring departmental cohesiveness and accuracy while managing cross-functional training activities with minimal supervision.
Applies managed care principles, underwriting knowledge, and actuarial concepts while identifying and implementing solutions to complex business challenges.
Pharmacy Data Analyst II - In addition to level I
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 III - In addition to level I and II
Ability to work well independently or with a team. Mentors/coaches others. May direct or lead Analyst I or II on projects.
What You Will Do at Cambia:
Pharmacy Data Analyst I and II
• Develops and maintains complex SQL-based reports, BOE universes, and enterprise dashboards while implementing automated validation procedures and providing final sign-off on departmental reporting.
• Performs advanced statistical analysis, data modeling, and trend analysis across healthcare services, utilization, costs, enrollment, and revenue metrics, delivering actionable insights for all business lines.
• Designs and maintains robust information reporting systems, including data validation routines and balancing protocols, ensuring data warehouse integrity and reliability for both internal and external stakeholders.
• Evaluates and analyzes impacts of new products, systems, and work processes on data infrastructure, while proactively identifying and addressing potential issues with significant corporate risk implications.
• Serves as a technical mentor, providing training and support to business analysts in query development and reporting methodologies, promoting consistency across the organization.
• Collaborates cross-functionally to ensure accurate data capture, interpret complex datasets, and determine reporting requirements while communicating findings through verbal and written channels.
• Makes high-stakes decisions with substantial financial impact, contributes to departmental deadlines, and maintains responsibility for final validation of complex reporting across the organization.
Pharmacy Data Analyst III - In addition to Level I and II
Seen as the technical expert on pharmacy data analytics issues.
May mentor/coach others. May direct or lead Analyst I or II on projects.
#LI-remote
The expected hiring salary range for a Pharmacy Data Analyst I is $56,950 - $77,050 a year 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 $53,000 - $88,000 a year.
The expected hiring salary range for a Pharmacy Data Analyst II is $75,650 - $102,350 a year 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 $71,000 - $116,000 a year.
The expected hiring salary range for a Pharmacy Data Analyst III is $91,800 - $124,200 a year 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 $91,800 - $124,200 a year.
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.
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 and Affirmative Action employer dedicated to workforce diversity and 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 CambiaCareers@cambiahealth.com. Information about how Cambia Health Solutions collects, uses, and discloses information is available in our Privacy Policy.
Tags: Computer Science Data analysis Data Analytics Data warehouse Excel Finance Mathematics Oracle Privacy RDBMS SQL Statistics
Perks/benefits: 401(k) matching Career development Competitive pay Equity / stock options Flex hours Flex vacation Health care Medical leave Parental leave Salary bonus Signing bonus Team events Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.