Data Analyst (Operations & Policy Analyst 3)

About the role

The Department of Consumer and Business Services (DCBS) is a progressive business regulatory state agency dedicated to protecting and serving Oregon's consumers and workers while supporting a positive business climate. The Division of Financial Regulation (DFR) within DCBS is responsible for ensuring the safety and soundness of financial institutions, the availability and affordability of financial products, and the fair treatment of consumers.

Responsibilities

• 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 experience professional-level evaluative, analytical and planning work.

Skills

• 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.
• 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.
• Strong Python skills for data manipulation, automation, and analytics workflows.

Benefits

For a complete listing of the duties and responsibilities of this position, please review the position description. Here’s what you will get:

• Rewarding work in a productive and creative environment.
• Colleagues who are passionate about public service.
• Work/life balance, 11 paid holidays a year, and a competitive benefits package.
• Advancement and learning opportunities that will help grow your career with the State of Oregon.
• Possible eligibility for the Public Service Loan Forgiveness Program.

Pay

This position is eligible to telework on a part-time basis once the incumbent has gained the proficiency to perform work independently. However, regular, scheduled office hours are also required. The salary range listed is the non-PERS eligible rate. If you are already a participating PERS member or once you become PERS eligible after 6 months of employment, the salary range will increase by 6.95% and the required 6% employee retirement contribution will be deducted from your pay.

Schedule

On average, candidates new to state service will most likely be offered compensation in the lower to mid-level of the salary range. The salary range listed is the non-PERS eligible rate. If you are already a participating PERS member or once you become PERS eligible after 6 months of employment, the salary range will increase by 6.95% and the required 6% employee retirement contribution will be deducted from your pay.

Additional Information

• Per the Pay Equity Law passed in 2017, an employee pay assessment will be conducted to determine what pay step the successful candidate will be offered. The assessment will be based on the relevant experience, education, training, and certifications documented in the application materials.
• The State of Oregon does not request or require your age, date of birth, attendance or graduation dates from an educational institution during the application process. This information may be required after the interview process, depending on the requirements of the position.
• Eligible veterans and Oregon National Guard servicemembers (current and former) who meet the qualifications of the position will be awarded candidate preference. For further information, please see the following website: Veterans, Disabled Veterans & State Servicemembers.