Transparency Data Science Lead (Statistical Analyst IV) - DORA: DOI Hybrid

Hybrid Workplace Arrangement: 

Although this position will be designated under the department’s hybrid workplace program, it will still be required to report to the department office on a scheduled basis and at the discretion of the supervisor, based on business needs.  

This announcement may be used to fill multiple vacancies.

The Department of Regulatory Agencies (DORA) is dedicated to preserving the integrity of the marketplace and is committed to promoting a fair and competitive business environment in Colorado.

Consumer protection is our mission.

DORA values and promotes diversity, supporting a workplace that is inclusive of people from different backgrounds and experiences; creating an environment that is reflective of our communities; promoting positive relationships; and putting forth unique perspectives to fulfill our mission. 

• Employer-sponsored RTD EcoPass, with offices located at Civic Center Plaza, above the RTD Civic Center station and just a few blocks from RTD light rail. 

• Extensive work-life programs such as flexible schedules, training and professional development opportunities on a wide variety of subjects, and more! 

• Employee wellness programs, including the Colorado State Employee Assistance Program (CSEAP), which provides free, confidential counseling services.

• Bike-to-work programs, including access to storage lockers and bike racks.

• Flexible retirement benefits, including a choice of the PERA Defined Benefit Plan or the PERA Defined Contribution Plan, plus optional 401K and 457 plans.

• Medical and Dental Health Insurance for employees and optional coverage for their dependents.

• Life Insurance for employees, and optional coverage for their dependents.

• Paid Time Off, including 11 paid holidays.

• Short- and long-term disability coverage.

• Tuition assistance program.

The Colorado Division of Insurance (DOI) regulates the insurance industry in Colorado. DOI helps consumers by answering their questions, investigating their complaints, and helping them to understand their insurance. The division regulates and monitors insurance companies in Colorado, as well as insurance agents, ensuring all are following the law.

The Affordability Program - Data Science work unit exists to develop, implement, and maintain the data strategy of the Division of Insurance (DOI). The data science unit works with policy teams to prioritize, collect, and analyze data relevant to new legislation and current division authority such as compiling data that exists in rate filings and other data calls from insurance carriers, including assisting the DOI in the collection, storage, and transfer of data; ensuring appropriate data collection, security, and dissemination; implementing new data infrastructure and processes across the division; analyzing data relevant to programs, policies, and new legislations; and advising policy teams on data needs and interpreting analysis results.

Position: SFA 4336

Data Science is an emerging field that is quickly becoming an insurance industry standard by applying data driven approaches to design insurance products that are going to be offer to consumers. To help, DOI adapts to a changing industry and bridges the gap between the insurance industry and the division, this position works with the manager of insurance data science and applies emerging industry best practices in data science to the division’s consumer protection and regulatory mission, and specifically to the Affordability Program’s directive to make healthcare more affordable.
 
The position manages all aspects of the implementation and ongoing work from SB24-080, which requires health insurance carriers in the state to submit bigdata relevant to provider and pharmacy reimbursement rates. The position works with the Colorado Office of Information Technology (OIT) and procurement to ensure DOI can ingest the required data, works with carriers to ensure data submissions are accurate, and works with the data science manager and other stakeholders to develop reports and policy proposals based on this data. After understanding and cleaning intricate and large data sets, the position designs and conducts complex analyses using inferential and descriptive statistics. The position is responsible for determining what analyses must be done, prioritizing them, and creating reports to translate the results to a variety of audiences. The data is new nationally and the position is responsible for implementing a first in the nation analysis and reporting suite that is going to be a model for other states and researchers across the country. The data is ingested bi-annually and the position updates and improves upon the analysis, and reports on an ongoing basis by applying new statistical and data science principles.

Duties include, but are not limited to:

• Developing, maintaining, and updating the data schemas required for the machine-readable files, including running stakeholder meetings, gathering feedback, using advanced SQL to ingest, stage, validate, analyze, and report on the data in Big Query and Tableau;
• Utilizing statistical principles to validate submitted data, working with carriers to improve accuracy, and ensuring compliance with statutes and regulations, including handling technical descriptions of any issues, working directly with technical staff to describe the issues in non-technical terms to the division leadership and other stakeholders;
• Working with leadership to assess non-compliance and recommend Division action, acting as the lead in the technical description of non-compliance, determining what is necessary for carriers to reach compliance, and determining whether carriers meet requirements or not;
• Developing, implementing, and improving statistical models to determine completeness and accuracy;
• Creating, updating, and maintaining a lookup tool for internal staff to understand summary statistics about any carrier/provider/rate combination that the position has validated in the data;
• Utilizing SQL, Python, R, and Tableau to analyze data and using advanced statistical data and data science processes to identify trends, patterns, and anomalies;
• Serving as the lead analyst in the data science work unit, including guiding staff on matters related to data science, statistics, and reporting; supervising the work of two statistical analysts; and assisting the data science manager in training staff on incorporating data and analysis;
• Training the data science work unit analysts on statistical and technical processes (i.e. SQL optimization, Tableau visualization best practices, or efficient database structure);
• Assisting the data science manager in training the division staff in technical skills of how to use Tableau to clean and develop reports or how to use and interpret reports, depending on staff level of access and knowledge; and hosting Tableau user groups to disseminate learnings.

MINIMUM QUALIFICATIONS (MQs):
There are two ways to qualify for this position: 1) Experience OR 2) A Combination of Education and Experience
Option 1: Experience

• Eight (8) years of full-time professional* work experience in the healthcare industry, insurance industry (i.e. life and health insurance), and/or government agency performing three (3) of the following:
  • Developing and/or conducting data analysis; 
  • Troubleshooting, answering, and resolving data issues/inquiries (external/internal);
  • Developing, implementing, and/or improving data analysis models with SQL;
  • Creating reports and analyzing data results;
  • Demonstrated experience with/knowledge of statistical data, data science, and/or big data.
• Of the eight (8) years, one (1) year must include formal supervisory** experience as either a Unit Supervisor (responsible for the pay, status, and tenure of subordinate employees), or as a Team or Work Leader, partially accountable for the work product of other team members. 

• Associate’s Degree and Experience: Graduation from an accredited college or university with an associate’s degree in business, computer science, data science, database management, economics, public administration, public health, statistics, mathematics, or a field of study related to the work assignment; AND
• Six (6) years of full-time professional* work experience in the healthcare industry, insurance industry (i.e. life and health insurance), and/or government agency performing three (3) of the following:
  • Developing and/or conducting data analysis; 
  • Troubleshooting, answering, and resolving data issues/inquiries (external/internal);
  • Developing, implementing, and/or improving data analysis models with SQL;
  • Creating reports and analyzing data results;
  • Demonstrated experience with/knowledge of statistical data, data science, and/or big data.
• Of the six (6) years, one (1) year must include formal supervisory** experience as either a Unit Supervisor (responsible for the pay, status, and tenure of subordinate employees), or as a Team or Work Leader, partially accountable for the work product of other team members.

• Bachelor’s Degree and Experience: Graduation from an accredited college or university with an associate’s degree in business, computer science, data science, database management, economics, public administration, public health, statistics, mathematics, or a field of study related to the work assignment; AND
• Four (4) years of full-time professional* work experience in the healthcare industry, insurance industry (i.e. life and health insurance), and/or government agency performing three (3) of the following:
  • Developing and/or conducting data analysis; 
  • Troubleshooting, answering, and resolving data issues/inquiries (external/internal);
  • Developing, implementing, and/or improving data analysis models with SQL;
  • Creating reports and analyzing data results;
  • Demonstrated experience with/knowledge of statistical data, data science, and/or big data.
• Of the four (4) years, one (1) year must include formal supervisory** experience as either a Unit Supervisor (responsible for the pay, status, and tenure of subordinate employees), or as a Team or Work Leader, partially accountable for the work product of other team members.

• Partial credit toward the degree requirement will be given for completed college/university coursework that did not result in a degree. A master's or doctorate degree from an accredited college or university in a field of study related to the work assignment will substitute for the bachelor's degree requirement.

• Demonstrated experience working in the healthcare industry, in a state government agency, in the insurance industry, and/or in the Colorado Division of Insurance conducting data analysis;
• Demonstrated experience as a work leader, including assigning tasks, monitoring work progress and workflow, reviewing the final product of the assignment from the staff, and establishing work standards;
• Demonstrated experience working in a fast-paced, high-volume environment, and adapting to shifting priorities, as needed; 
• Demonstrated experience utilizing and an understanding of statistical methods and best practices to analyze data sets;
• Demonstrated experience working with data sets, including health care/pharmacy data, in the commercial (private) and/or public health insurance industry;
• Demonstrated experience researching and designing methods to collect, clean, transform, and analyze data;
• Demonstrated experience performing quantitative and qualitative analysis on raw, messy data;
• Demonstrated experience tracking data and reporting out, or answering inquiries related to raw data;
• Proficiency in database design and the use of SQL with Google Big Query or AWS-managed databases;
• Proficiency in the use of Python, R, and/or Tableau to analyze data;
• Demonstrated experience working with various databases, data structures, or other appropriate infrastructure, marrying data to support data analysis, research, and evaluation.

• Demonstrated written communication skills, including the ability to convey information to various stakeholders in a clear, accurate, and concise written manner;
• Demonstrated verbal communication skills, including the ability to effectively convey information to audiences in a concise manner;
• Demonstrated attention to detail;
• Sound judgment and the confidence to make decisions on a routine basis;
• Demonstrated critical thinking and analytical skills, including having the ability to evaluate information in order to apply knowledge and to decide on the most appropriate course of action;
• Demonstrated prioritization and time management skills, including planning, organizing tasks, and managing work assignments;
• Customer service, including the ability to diplomatically interact with difficult customers, build relationships, and maintain communication with stakeholders;
• Problem-solving skills, including the ability to review and analyze information in order to recommend solutions;
• Flexibility and adaptability, including the ability to multi-task effectively by managing competing and constantly changing priorities to meet tight deadlines, and the ability to adapt to changing work environment;
• Interpersonal skills, including the ability to collaborate with various stakeholders;
• Demonstrated ability to understand and abide by workplace principles, practices, and behaviors as internally identified and defined by the division and department;
• Ability to travel independently, including work in-office, as required by business needs and scheduled by the supervisor;
• Leadership skills, including the ability to effectively lead a team, train staff, delegate tasks, and cultivate a respectful and successful workplace environment;
• Integrity and high ethical standards;
• Accountability, reliability, including attendance;
• Ability to maintain confidential, controversial, or sensitive information;
• Self-starter, including the ability to work independently, learn new processes, utilize own knowledge and that of the supervisor, and complete work with minimal supervision;
• Demonstrated professional demeanor;
• Knowledge and understanding of the use of PC software applications including Microsoft Office (Access, Word, Excel, etc.), and Google Suite (Doc’s, Sheets, Slides, Calendar, etc).

• The successful passing of a reference check and/or, if required, a background check.
  • A reference check may include but is not limited to: contacting previous and current supervisors to verify employment and discuss performance, a review of the personnel file, a review of the performance record, etc.
  • The type of background check depends on the job duties of the position, and can include a review of any criminal record, credit report, and/or driving record.
• Ability to travel independently, including work in-office, as required by business need and scheduled by the supervisor.
• Effective September 20, 2021, employees will be required to attest to and verify whether or not they are fully vaccinated for COVID-19. Employees who have not been fully vaccinated may be required to submit to serial testing in the future. Upon hire, new employees will have three (3) business days to provide attestation to their status with proof of vaccination. Vaccinated employees must provide proof of vaccination.
  • Note: Fully Vaccinated means two (2) weeks after a second dose in a two-dose series of the COVID-19 vaccine, such as the Pfizer or Moderna vaccine, or two (2) weeks after the single-dose vaccine, such as Johnson & Johnson’s Janssen vaccine, as defined by the most recent State of Colorado’s Public Health Order and current guidance issued by the Colorado Department of Public Health & Environment.

PLEASE READ - Required Application Materials

Interested individuals must submit the following online:

1. A completed State of Colorado Application (log-in to your current NeoGov account or create a NeoGov account to complete the online application). Note: Incomplete applications, including incomplete work history sections or "see résumé," "see attachment," or "see addendum" statements, will not be accepted in lieu of a completed application form.

2. A current email address on your application, as all communication pertaining to this position will be conducted via email. Please set up your email to accept messages from info@governmentjobs.com and ‘@state.co.us’ addresses, and check your email often. Note: The department cannot guarantee the successful delivery of email, including incorrect filtering into junk mail folders.

3. A detailed cover letter, explaining how you meet the required competencies and how your accomplishments, qualifications, skills, areas of expertise, personal characteristics, etc. make you a good fit for this position; you may also attach additional documents that demonstrate this.

Comparative Analysis Process: Structured Application Review

Part of, if not the entire, comparative analysis process for this position will involve a review of the information you submit in your application materials; Therefore, it is paramount that in the experience portion of your application and cover letter, you describe the extent to which you possess the education, experience, and competencies outlined in the job announcement as well as the required and/or preferred qualifications/competencies. You are also encouraged to attach additional documents to that effect. Failure to include adequate information or follow instructions may affect your score and prevent you from competing in subsequent measures used to arrive at a top group of applicants.

Veterans’ Preference: Candidates who wish to assert Veterans’ Preference should attach a copy of their DD214 to their application. Failure to do so will result in being denied Veterans Preference.

PLEASE NOTE: Former State Personnel System employees who were disciplinarily terminated or resigned in lieu of termination must disclose this information on the application.  Colorado Revised Statutes require that all state employees be hired and promoted through competitive examination of merit and fitness.  Failure to include the required information, failure to follow instructions, and/or failure to submit materials by the application deadline may result in your application not being considered for the position and may affect your score or inclusion in the final pool of qualified candidates. 

The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.

ADAAA Accommodations: DORA is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADAAA Coordinator, at dora_adacoordinator@state.co.us.

While a salary range is posted for this position, an eventual salary offer is determined by a comprehensive salary analysis, which considers multiple factors including but not limited to education and experience compared to others in the organization doing substantially similar work. 

Check out our excellent benefits package!

Appeal Rights: 

If you receive notice that you have been eliminated from consideration for this position, you may file an appeal with the State Personnel Board or request a review by the State Personnel Director.

An appeal or review must be submitted on the official appeal form, signed by you or your representative. This form must be delivered to the State Personnel Board by email, US Mail, faxed or hand-delivered within ten (10) calendar days from your receipt of notice or acknowledgment of the department’s action.

For more information about the appeals process, the official appeal form, and how to deliver it to the State Personnel Board go to spb.colorado.gov or refer to 4 Colorado Code of Regulations (CCR) 801-1, State Personnel Board Rules and Personnel Director's Administrative Procedures, Chapter 8, Resolution of Appeals and Disputes, at spb.colorado.gov under Rules.