Data Analyst, Operations & Policy Analyst 3

Jobtailor

Salem (OR)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor invites a data-focused professional to join Oregon's health and insurance compliance team. The role involves analyzing insurance industry data, evaluating processes, and delivering compliant solutions for filing and reporting across multiple entities.

The ideal candidate uses Excel, SQL, SAS, and Power BI to produce actionable insights, supports health insurance compliance, and communicates findings to stakeholders effectively.

Qualifications

Bachelor's degree in Business or Public Administration, Behavioral or Social Sciences, Finance, Political Science or any degree showing capability; and four years professional-level evaluative, analytical and planning work
Any combination of experience and education equivalent to seven years of professional-level evaluative, analytical and planning work
Expert proficiency with Microsoft Excel (pivot tables, data connections, charts, conditional formatting)
Advanced proficiency with database reporting, query writing, SAS, SQL, and data warehousing
Effective business and technical requirements gathering/documentation skills
Effective skills in business rule writing
Experience with Power BI
Strong understanding of statistical methods and applied analytics
Competence in data visualization best practices and storytelling with data
Understanding of data governance, data quality, and metadata management
Strong communication skills for translating technical analysis into actionable insights
Subject matter knowledge of the insurance industry
Experience working with health insurance claims database systems
Experience with mental health parity and health insurance network adequacy
Proficiency in R for statistical analysis, visualization, and reporting
Experience with ArcGIS (or other GIS platforms) for spatial data analysis and mapping
Strong Python skills for data manipulation, automation, and analytics workflows.

Responsibilities

Serve as a technical resource for the Division of Financial Regulation for internal procedures and working with outside entities
Conduct comprehensive studies of insurance and financial industry data, systems, processes, and business requirements to evaluate, identify and recommend process improvements that effectively reduce costs, ensure compliance, and improve service delivery
Managing and examining report filings
Ensuring timely and complete filing of all companies
Working with companies to help gain compliance with state and federal laws
Providing technical and analytical support to health insurance compliance staff

Skills

Data visualization

Statistical methods

Strong communication

Analytical thinking

Problem solving

Data governance

Python programming

R programming

Education

Bachelor's degree in Business/Public Administration/Finance/Police?

7 years experience in evaluative/analytic/planning work

Tools

Microsoft Excel

SQL

Power BI

SAS

ArcGIS

Data warehousing

Database querying

Job description

Serve as a technical resource for the Division of Financial Regulation for internal procedures and working with outside entities
Conducting comprehensive studies of insurance and financial industry data, systems, processes, and business requirements to evaluate, identify and recommend process improvements that effectively reduce costs, ensure compliance, and improve service delivery
Managing and examining report filings
Ensuring timely and complete filing of all companies
Working with companies to help gain compliance with state and federal laws
Providing technical and analytical support to health insurance compliance staff

Requirements

A bachelor's degree in Business or Public Administration, Behavioral or Social Sciences, Finance, Political Science or any degree demonstrating the capacity for the knowledge and skills; and four years professional-level evaluative, analytical and planning work
Any combination of experience and education equivalent to seven years of professional-level evaluative, analytical and planning work
Expert proficiency with Microsoft Excel (pivot tables, data connections, charts, conditional formatting)
Advanced proficiency with database reporting, query writing, SAS, SQL, and data warehousing
Effective business and technical requirements gathering/documentation skills
Effective skills in business rule writing
Experience with Power BI
Strong understanding of statistical methods and applied analytics
Competence in data visualization best practices and storytelling with data
Understanding of data governance, data quality, and metadata management
Strong communication skills for translating technical analysis into actionable insights
Subject matter knowledge of the insurance industry
Experience working with health insurance claims database systems
Experience with mental health parity and health insurance network adequacy
Proficiency in R for statistical analysis, visualization, and reporting
Experience with ArcGIS (or other GIS platforms) for spatial data analysis and mapping
Strong Python skills for data manipulation, automation, and analytics workflows.

Core Competencies

Demonstrates expertise in data analysis, compliance, and process improvement within the insurance industry, utilizing advanced skills in Microsoft Excel, SQL, and R for effective reporting and visualization. Strong ability to translate complex technical data into actionable insights while ensuring adherence to regulatory standards.

Highest-signal resume keywords