Data Analyst (Operations & Policy Analyst 3)

As a Data Analyst, you will serve as a technical resource for the Division of Financial Regulation for internal procedures and working with outside entities. Duties include:

• 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, * 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. 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.
• This position is subject to a fingerprint background check for any convictions directly related to its duties and responsibilities. Only job-related convictions will be considered and will not automatically disqualify the candidate.
• 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. NOTE: If claiming preference please be sure to check your Workday account for pending tasks in the “My Tasks” section at the top of the Candidate Home page.
• We hire preferred workers! For more information, please visit our website: Preferred Worker Program.
• The Department of Consumer and Business Services (DCBS) does not offer VISA sponsorships. If your employment authorization and documentation is contingent on sponsorship now or in the future, you will not meet our agency employment eligibility standards. Within three days of hire, you will be required to complete the US Department of Homeland Security’s I-9 form confirming authorization to work in the United States. DCBS will use E-Verify to confirm that you are authorized to work in the United States.

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., * 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

Requested 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
• 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

• 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

To equitably protect and empower consumers and workers while maintaining a predictable yet innovative regulatory environment for the businesses we regulate.

The Department of Consumer and Business Services (DCBS) is a progressive business regulatory state agency dedicated to the mission of protecting and serving Oregon’s consumers and workers while supporting a positive business climate. The department administers state laws and rules governing workers’ compensation, occupational safety and health, financial institutions, insurance companies and building codes. The department has consumer protection and education programs, offices, and ombuds to help consumers, injured workers, and businesses.

This position is with the Division of Financial Regulation (DFR). DFR’s mission supports that of the department by protecting Oregonians’ access to fair products and services through education, regulation, and consumer assistance. The division is responsible for ensuring the safety and soundness of financial institutions, the availability and affordability of financial products, and the fair treatment of consumers. Functions include licensing, regulating, and monitoring the conduct of banks, credit unions, financial services providers, health care service contractors, insurance companies, and licensed or registered agents of such entities.

This position is represented by the Service Employees International Union (SEIU).