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

Requirements

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
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.

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

SQLdata analysisstatistical analysisdata modelingreport writingdata validationdata interpretationreport developmentVBApivot tables

Soft skills

analytical skillsproblem-solving skillscommunication skillsleadership capabilitiesbusiness acumencreativityindependencecollaborationmentoringtraining

Certifications

Bachelor's degree in businessBachelor's degree in health information administrationBachelor's degree in mathematicsBachelor's degree in statisticsBachelor's degree in computer science