DATA REPORTING ANALYST (HEALTHCARE/INSURANCE - ENTRY LEVEL)

The Data Reporting Analyst serves as a data and analytic consultant for functional business areas by collecting and analyzing operation and financial data. Presents findings on any trends and assists business leaders with forecasting in support of evidence based decision making.

Preferred Key Experience:

Must haves:

Beginner to mid-level SQL programming skills

Some ETL (Extract Transform Load) experience

Beginner to mid-level Excel skills

Preferred experience (any or all):

Healthcare/insurance

HEDIS

Tableau/Power BI skills

Alteryx skills

Base-level statistics knowledge

Normally to be proficient in the competencies listed below

Data Reporting Analyst would have

• Bachelor’s degree in mathematics, actuarial science, statistics, computer science or related field

• 3 years of related experience

• Or equivalent combination of education and experience

YOUR ROLE:

• Provides analytical support to any or all divisions of the organization by mining data, conducting analysis, and interpreting results related to business needs.

• Develops methodologies and approaches to new tasks and projects through design and development of analytical models and reports.

• Proactively identify issues and concerns to management.

• Develops knowledge of health plan operations, health plan data sources and structures, and cost containment strategies.

• Identifies problems or needed changes, recommends resolution, and participates in quality improvement efforts.

• Identifies needed reporting, assembles or directs the assembly of reports and distributes such information.

• Performs acceptance testing of new reports, programs and models.

• Documents business requirements and methods used to generate work output.

• Drives analytic innovation and best practices within Cambia.

• Actively identifies and eliminates inefficient or ineffective use of resources and provides recommendation on process improvements.

• May supervise the gathering and analysis of information.

• Serve as a resource on analytic programming tools and methods.

• Reviews data as it relates to health plan operations to assist with the development of cost containment strategies.

• May assist in training of other team members.

WHAT YOU BRING

• Keen analytical and problem solving skills.

• Proven ability to document business requirements.

• Solid oral and written communication skills.

• Advanced knowledge of health plan operations, data sources, data structures within business area.

• Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau).

• Knowledge of analytic programming tools and methods. (SAS, SQL, OLAP, Business Objects, Crystal)

• Proven ability to design and develop reporting tools and dashboards.

• Business sense (finance, accounting, economics, risk management, public health economics, social service research or epidemiology).

• Ability to organize, plan and prioritize assignments within multiple projects.

• Must be able to work with minimal direction and be very flexible to coordinate complex activities that are often subject to rapid or extensive changes.

• Demonstrated success with project management.

• Advanced oral and written communications skills.

• Proven ability to perform difficult analytical tasks with minimal supervision.

The expected target hiring range for this position is $67k – $90k depending on skills, experience, education, and training; relevant licensure / certifications; performance history; and work location. The bonus target for this position is 10% . The current full salary range for a Healthcare Data Analyst is $62.5k Low Range / $78.5k MRP / $102.5k High Range.

Base pay is just part of the compensation package at Cambia that is supplemented with an exceptional 401(k) match, bonus opportunity and other benefits. In keeping with our Cause and vision, we offer comprehensive well-being programs and benefits, which we periodically update to stay current. Some highlights:

• medical, dental, and vision coverage for employees and their eligible family members

• annual employer contribution to a health savings account ($1,200 or $2,500 depending on medical coverage, prorated based on hire date)

• paid time off varying by role and tenure in addition to 10 company holidays

• up to a 6% company match on employee 401k contributions, with a potential discretionary contribution based on company performance (no vesting period)

• up to 12 weeks of paid parental time off (eligible day one of employment if within first 12 months following birth or adoption)

• one-time furniture and equipment allowance for employees working from home

• up to $225 in Amazon gift cards for participating in various well-being activities. for a complete list see our External Total Rewards page.