FEP Business Intelligence Analyst I

Cambia Health Solutions•Medford, OR

14d•$59,000 - $108,000•Hybrid

About The Position

The FEP Business Intelligence Analyst I is part of Cambia’s FEP Data Analytics team and builds analytics, ad hoc reports, and Sigma or Tableau dashboards, using Python for scripting and analyzing claims, customer service, and clinical data. The role manages analytics projects, communicates with stakeholders, and collaborates across departments to support health plan operations and Cambia’s goal of creating an economically sustainable, person-focused health care system. This is a hybrid role requiring three days per week in the office. The position is based at one of the listed offices: Portland, Vancouver, Renton, Salt Lake City, Boise, Little Rock, Springdale, Fargo, Medford, Burlington, or Lewiston. Candidates must live within commuting distance of their selected office or be willing to relocate. The analyst partners with stakeholders to understand business needs, designs and delivers analytics projects, defines and measures KPIs, and turns data findings into actionable recommendations and strategy. The role also contributes to standardized, automated analytical processes and self-service reporting. The expected hiring range depends on work location, skills, experience, education, training, relevant licensure or certifications, and performance history. National-market locations have a full salary range of $66,000–$108,000 and an 8% bonus target; regional locations have a full salary range of $59,000–$98,000 and an 8% bonus target.

Requirements

Bachelor’s degree in Statistics, Mathematics, Computer Science, Information Technology, Economics, or a related field.
At least 3 years of related work experience; an equivalent combination of education and experience will be considered.
Proficiency in SQL, including complex queries for standard and ad hoc data mining; candidates without SQL experience must demonstrate strength in other listed areas.
Microsoft Excel skills.
Experience with scripting and statistical tools such as Python, R/RStudio, SSIS, Alteryx, or Talend.
Experience with data visualization and reporting tools such as Tableau, MicroStrategy, SPSS, or Power BI.
Experience developing interactive dashboards for data exploration, self-service analytics, and visual storytelling.
Broad data analysis experience across datasets such as demographics, workflow, financial, and healthcare data.
Experience with large-scale data analysis, including interpreting qualitative data such as research and feedback and incorporating it into analyses.
Research and methodology skills, including developing data mining approaches and innovative statistical or mathematical methods.
Technical aptitude.
Creative and analytical problem-solving skills, independently and collaboratively, with the ability to learn quickly and synthesize solutions, options, and action plans.
Ability to collaborate with team members and business stakeholders to define, develop, and deliver analytics supporting routine operations, tactical decisions, and strategic direction.
Ability to clearly communicate complex data, analyses, and findings to support business decisions and program efforts.
Ability to work independently and manage deliverable timelines and client needs.
Accuracy and quality focus, including producing error-free deliverables and supporting a peer review culture.
Candidates must reside within commuting distance of a listed office or be willing to relocate.
Ability to use a wired internet connection for work-from-home options, with minimum upload speed of 5 Mb and minimum download speed of 10 Mb; satellite and cellular connections are not accepted.
Access to a personal mobile device to set up required multi-factor authentication upon joining the company.
Successful completion of a required background check.

Nice To Haves

Experience with AI tools and technologies to enhance productivity and decision-making is highly desired.

Responsibilities

Partner cross-functionally to understand business objectives and deliver routine and ad hoc analyses and reporting that are clear, relevant, and consistent with stakeholder agreements.
Design and execute analytics projects from conceptualization through methodology, data sourcing, analysis structure, reporting, and data visualization.
Deliver accurate project reporting and analyses on time, and provide internal partners with insights for tracking deliverables and ad hoc projects using multiple Healthplan Operations data sources.
Analyze data to explain why outcomes occurred and recommend actions, translating observations into insights, recommendations, strategy, and site optimization.
Define and measure KPIs with team members, identifying ways to track Healthplan Operations metrics and assess initiatives to inform strategy.
Collaborate with internal and external teams to prioritize data-informed recommendations and support corporate initiatives through analysis and KPI measurement.
Develop standardized and automated analytical and statistical processes, best practices, and self-service reporting with team members.
Build FEP analytics, ad hoc reports, and Sigma or Tableau dashboards, using Python for scripting and analyzing claims, customer service, and clinical data.
Manage projects, communicate with stakeholders, and collaborate across departments to meet varied deadlines.

Benefits

Medical, dental, and vision coverage for employees and eligible family members, including mental health benefits.
Annual employer contribution to a health savings account.
Paid time off that varies by role and tenure, plus 10 company-paid holidays.
401(k) retirement plan with a company match and potential discretionary contribution based on company performance, with no vesting period.
Up to 12 weeks of paid parental time off, subject to eligibility requirements.
Wellness programs with participation rewards.
Employee Assistance Fund.
Commute and parking benefits.
Bonus opportunities.
Employee resource groups.
Cambia-supported community outreach opportunities.