Insurance Regulatory Data Analyst (Operations & Policy Analyst 3)
About The Position
The Insurance Regulatory Data Analyst serves as a technical resource for the Department of Consumer and Business Services’ Division of Financial Regulation, supporting internal procedures and working with outside entities. The role conducts comprehensive studies of insurance and financial industry data, systems, processes, and business requirements to identify and recommend improvements that reduce costs, ensure compliance, and improve service delivery. It also manages and examines report filings, helps ensure that companies file complete reports on time, works with companies to support compliance with state and federal laws, and provides technical and analytical support to health insurance compliance staff. The Division of Financial Regulation protects Oregonians’ access to fair products and services through education, regulation, and consumer assistance. The position is represented by the Service Employees International Union (SEIU). It is eligible for part-time telework after the employee gains the proficiency to work independently, but regular, scheduled office hours are also required.
Requirements
- A bachelor's degree in Business or Public Administration, Behavioral or Social Sciences, Finance, Political Science, or another degree demonstrating capacity for the required knowledge and skills, plus four years of professional-level evaluative, analytical, and planning work; OR an equivalent combination of education and experience totaling seven years of professional-level evaluative, analytical, and planning work.
- Expert proficiency with Microsoft Excel, including pivot tables, data connections, charts, and conditional formatting.
- Advanced proficiency with database reporting, query writing, SAS, SQL, and data warehousing.
- Effective business and technical requirements gathering and documentation skills.
- Effective business rule writing skills.
- 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
- Conduct comprehensive studies of insurance and financial industry data, systems, processes, and business requirements.
- Evaluate, identify, and recommend process improvements to reduce costs, ensure compliance, and improve service delivery.
- Manage and examine report filings.
- Ensure companies submit all required filings completely and on time.
- Work with companies to help them comply with state and federal laws.
- Provide technical and analytical support to health insurance compliance staff.
Benefits
- 11 paid holidays a year
- Competitive benefits package
- Advancement and learning opportunities
- Possible eligibility for the Public Service Loan Forgiveness Program
- Part-time telework eligibility after gaining proficiency to work independently
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
