FEP Business Intelligence Analyst I

FEP Business Intelligence Analyst I

Hybrid role (3 days/week in office) at our Portland, Vancouver, Renton, Salt Lake City, Boise, Little Rock, Springdale, Fargo, Medford, Burlington, and Lewiston offices. Candidates must reside within commutable distance of that location or be willing to relocate.

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 FEP Business Intelligence Analysts is living our mission to make health care easier and lives better. As a member of the FEP Data Analytics team, our FEP Business Intelligence Analysts build FEP analytics, ad-hoc reports, and Sigma or Tableau dashboards using Python for scripting; analysis of claims, customer service, and clinical data; manage projects, communicate with stakeholders, and collaborate with cross-departmentally to meet varied deadlines– all in service of creating an economically sustainable health care system.  

Do you thrive in a fast-paced environment where collaboration and flexibility are key? Are you energized by turning data into insights that help shape better health plan operations? Then this role may be the perfect fit. 

What You Bring to Cambia: 

Qualifications:  

• Bachelor's degree in Statistics, Mathematics, Computer Science, Information Technology, Economics, or a related field
• 3+ years of related work experience
• An equivalent combination of education and experience will be considered 

Skills and Attributes: 

• SQL proficiency (complex queries for standard and ad hoc data mining); candidates without SQL experience must demonstrate strength in other listed areas
• Microsoft Excel skills
• Scripting and statistical tools experience, such as Python, R/RStudio, SSIS, Alteryx, and Talend
• Data visualization and reporting tools experience, such as Tableau, MicroStrategy, SPSS, and Power BI
• Interactive dashboard development for data exploration, self-service analytics, and visual storytelling
• Broad data analysis experience across datasets such as demographics, workflow, financial, and healthcare data
• Large-scale data analysis, including interpreting qualitative data (research, feedback) and incorporating it into analyses
• Research and methodology skills, with the ability to develop data mining approaches and innovative statistical or mathematical methods
• Technical aptitude at some level
• Experience with AI tools and technologies to enhance productivity and decision-making (highly desired)
• Whole-brain thinking: creative and analytical problem-solving, both independently and on teams, with the ability to learn quickly and synthesize solutions, options, and action plans
• Collaboration skills to partner with team members and business stakeholders to define, develop, and deliver analytics that support routine operations, tactical decisions, and strategic direction
• Clear communication of complex data, analyses, and findings in ways that support business decisions and program efforts
• Independent work with strong management of deliverable timelines and clients
• Accuracy and quality focus, producing error-free deliverables and supporting a peer review culture

What You Will Do at Cambia:  

• Partner cross-functionally to understand business objectives and deliver routine and ad hoc analyses that are clear and relevant to stakeholders, including reporting that meets stakeholder agreements
• Design and execute analytics projects from start to finish, including conceptualization, methodology, data sourcing, analysis structure, and reporting or data visualization
• Ensure timely delivery of accurate project reporting and analyses, and provide insights to internal partners on tracking deliverables and ad hoc projects drawing on multiple sources across Healthplan Operations
• Turn data into action by moving beyond "what happened" to "why it happened" and "what should be done," converting observations into insights, insights into recommendations, and recommendations into strategy and site optimization
• Define and measure KPIs with team members, identifying the best ways to track metrics across Healthplan Operations to assess the success of new and existing initiatives and shape strategy
• Collaborate with internal and external teams to prioritize recommendations based on data insights and support corporate initiatives through analyses and KPI measurement
• Develop standardized, automated processes with team members, including analytical and statistical methods, best practices, and self-service reporting, to deliver sustainable, impactful data while building strong business partnerships that drive efficiency and strategic goals

Pay ranges vary based on the candidate's work location. The expected hiring range depends on skills, experience, education, and training; relevant licensure / certifications; and performance history.

• National pay structure — applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, and Salt Lake City metro areas: The full salary range is $66,000 - $108,000 and the bonus target is 8%.
• Regional pay structure — applies to North Dakota, and to Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The full salary range is $59,000 - $98,000 and the bonus target is 8%.

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.

As part of our security requirements, new hires will need access to a personal mobile device to set up Multi-Factor Authentication (MFA) upon joining the company. MFA is an important layer of protection for accessing Cambia systems and is required for all employees.