Apply on Employer Site

Cambia Health Solutions · 5 hours ago

Pharmacy Data Analyst I, II, or III DOE

United States

Full-time

Remote

Entry, Mid, Senior Level

$58K/yr - $80K/yr

2+ years exp

Cambia Health Solutions is dedicated to creating a person-focused and economically sustainable healthcare system. They are seeking a Pharmacy Data Analyst to provide proactive reporting solutions and advanced data analytics to support strategic goals, while managing complex projects and solving significant issues in pharmacy management.

BiotechnologyHealth CareInformation Technology

H1B Sponsor Likely

Responsibilities

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

Qualification

SQLData analysisMicrosoft ExcelOracle toolsData reportingStatistical analysisProblem-solvingCommunication skillsProject managementTeam collaboration

Required

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

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

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

Preferred

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

Benefits

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.

Company

Cambia Health Solutions

Glassdoor3.4

Cambia Health Solutions is a nonprofit total health solutions company based in the Pacific Northwest/Intermountain region, serving

Founded in 1996

Portland, Oregon, USA

5001-10000 employees

http://www.cambiahealth.com

H1B Sponsorship

Cambia Health Solutions has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (12)

2024 (11)

2023 (7)

2022 (12)

2021 (23)

2020 (24)