Insurance Regulatory Data & Policy Analyst

State of Oregon; Salem (OR); On-site; USD 70,000 - 108,000; Full time

Benefits offered by this job

11 paid holidays a year

Competitive benefits package

Part-time telework option

Job summary

The Department of Consumer and Business Services (DCBS) in Oregon is seeking an Insurance Regulatory Data Analyst (Operations & Policy Analyst 3) to serve as a technical resource for the Division of Financial Regulation. You will conduct in-depth studies of insurance data, manage filings, and support health insurance compliance with state and federal laws.

The role requires strong analytics, data visualization, and communication skills, plus familiarity with Excel, SAS, SQL, Power BI and ArcGIS.

Qualifications

• 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, plus 4 years of professional-level evaluative, analytical and planning work.
• OR seven years of professional-level evaluative, analytical and planning work.
• Expert proficiency with Excel (pivot tables, data connections, charts, conditional formatting)
• Advanced proficiency with SAS, SQL, and data warehousing
• Experience with Power BI
• Strong data visualization and storytelling with data
• Knowledge of data governance and metadata management
• Strong communication skills for translating technical analysis into actionable insights
• Subject matter knowledge of the insurance industry
• Experience 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

• Conduct comprehensive studies of insurance and financial industry data to evaluate, identify and recommend process improvements that reduce costs, ensure compliance and improve service delivery
• Manage and examine report filings
• Ensure timely and complete filing of all companies
• Work with companies to gain compliance with state and federal laws
• Provide technical and analytical support to health insurance compliance staff

Education

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

Tools

Microsoft Excel

Power BI

SAS

SQL

R

ArcGIS

Python

Job description

The Department of Consumer and Business Services (DCBS) in Oregon is seeking an Insurance Regulatory Data Analyst (Operations & Policy Analyst 3) to serve as a technical resource for the Division of Financial Regulation. You will conduct in-depth studies of insurance data, manage filings, and support health insurance compliance with state and federal laws.

The role requires strong analytics, data visualization, and communication skills, plus familiarity with Excel, SAS, SQL, Power BI and ArcGIS.