Statistical Analyst III-MED-Data Analysis

State of Colorado Job Opportunities - Lakewood, CO3.5

Department Information

The Colorado Department of Revenue (CDOR) employs approximately 1,600 hard-working and dedicated employees throughout Colorado. We can be seen performing functions as varied as auditing and collecting taxes, issuing driver licenses and motor vehicle titles, marketing lottery products, enforcing liquor laws, and regulating gaming, horse racing, marijuana, and the auto industry and assisting the citizens of our state.

CDOR Vision
To become the premier Department of Revenue known for its outstanding customer service, innovation, and dedicated employees.

CDOR Mission
The Department of Revenue will provide quality service to our customers in fulfillment of our fiduciary and statutory responsibilities while instilling public confidence through professional and responsive employees.

The Department of Revenue offers 10 paid holidays per year, paid vacation and sick leave, discounted RTD Eco-Pass, BenefitHub program (discounted merchandise, food and travel, etc), CafeWell, employee wellness program and a great benefit package.

Description of Job
This position is located in the Data Intelligence Team within the Marijuana Enforcement Division (MED).

Melding big data techniques with regulatory compliance objectives, the Data Intelligence Team is an integral part of the Division's mission to promote public safety through innovative problem-solving, while overseeing the nation's oldest commercial marijuana market. The successful candidate will be responsible for designing, developing and refining databases on licensing and inventory tracking data, which is created by the marijuana industry and accessible to the Division for weekly and monthly reporting. Additionally, a primary component of the job will involve interpreting, operationalizing, and applying the Division's rules to industry participants to identify and report on potentially non-compliant behavior.

Main duties of the position include: performing statistical analysis and research, and subsequently, developing data edits to ensure data's integrity and reconciling anomalies in inventory tracking system; designing and developing unique and appropriate statistical models to determine the impact on the industry of proposed legislation and rules and report results to Division leadership; creating risk-based models to evaluate potential non-compliant licensees based on available data; and advising users on interpretation of information presented. Duties also include designing and/or supervising special statistical studies and projects assigned by Division Management; supporting investigators as part of a multi-disciplinary team in planning, coordinating and executing criminal and regulatory investigations through synthesis and clear communication of industry-produced data and statistical rigor, referrals from other government agencies, complaints, or other developed sources.

This position will use advanced-level knowledge and expertise in relational databases, querying and analytic languages, quantitative regression and analysis, and a mature understanding of the power of visualization in order to provide the Division with increased technical capabilities commensurate with data-driven decision making. While predominantly an independent role, the position will assist employee growth in technical skills and be able to integrate into a team dynamic when necessary.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

Minimum Qualifications:
Bachelor's degree from an accredited college or university in statistics, statistical analysis, mathematics, economics, demography, computer science, software development, finance or a related field.

Three years of experience developing analyses utilizing databases, querying languages, and/or analytic software solutions.

Work experience in statistics, statistical analysis, mathematics, economics, demography, computer science, software development, finance or a related field may substitute on a year-for-year basis for the Bachelor's degree.

A Master's or Doctorate degree from an accredited college or university in statistics or statistical analysis or business/data analytics may be substituted for the Bachelor's degree and for one or two years respectively, for the required experience.

Preferred Qualifications:
The preferred candidate will also have
Master's Degree in statistics, statistical analysis, mathematics, demography, software development, finance or a related field;
Knowledge of data collection, management and analysis, using relational databases or scripting languages;
Proficiency with SQL, Hive, Hadoop, Spark, R, Python, Java, or VBA;
Experience with data visualization tools such as Tableau, SAS, SAP, or Qlik;
Intermediate to advanced skills on Microsoft Excel and Access;
Strong analytic thinking, research, and problem solving skills;
Exceptional interpersonal and team working skills;
Excellent verbal and written communication skills.
DOR REQUIRED SKILLS & COMPETENCIES: Competencies required for all DOR positions include good communications skills, interpersonal skills, the ability to multi-task, the ability to work with confidential information, the ability to work in high-stress environments, and the demonstrated ability to assist customers in an efficient, effective, and elegant manner.

CDOR Special Requirements
All employees must be current with their income tax filings and payments with the State of Colorado. This includes successfully passing a pre-employment evaluation of your tax records/accounts.
Employees are in a position of public trust in the performance of their job duties and must operate in a manner that maintains the highest standards of honesty, integrity, and public confidence. All job finalists require successful completion of a background investigation and reference check prior to appointment. Background checks may include national criminal, financial, traffic, civil, education, and/or experience checks or any other checks related to the job assignment. Fingerprint background checks and pre-employment drug testing (which may include using hair follicle drug testing) may be required for some positions.
Appeal Rights
If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination.

Also, if you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging.

Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for more information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at

A standard appeal form is available at: If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. Fax: 303-866-5038. Phone: 303-866-3300. The ten-day deadline and these appeal procedures also apply to all charges of discrimination.
Supplemental Information

All correspondence regarding your status in the selection/examination process will be conducted via e-mail. Include a working email address on your application; one that is checked often as time sensitive correspondence WILL take place via email. Exam information or notification will take place via email; check your email frequently. Please include your current e-mail address on your application and set up your e-mail to accept messages from "" and "" addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam filtered email.

The application will be used to determine if the applicant meets the Minimum Qualification requirements.
The detailed application is the first step in the comparative analysis process and will be used to determine whether an applicant will move on to the next step in the process. They may also be used to determine the top group to be invited for further testing, the applicants rank or establish an eligible list.
Part of, or the entire comparative analysis for this position, may involve a review of the information submitted in the application including the answers to the supplemental questions. Therefore, it is paramount that in the experience portion of the application, the applicant describes the extent to which they possess the education, experience, competencies and background as they relate to the duties outlined in the job announcement, as well as the special and/or preferred qualifications. List your employment history starting with the most recent job, including part-time, temporary, and volunteer jobs. If more than one job was held with a given organization, list each job held as a separate period of employment. Under "Duties," describe clearly the tasks you performed and the nature of your supervisory, technical, or other responsibilities as they relate to the job for which you are applying. Be complete and specific in detailing of duties. Information must be accurate, including dates of employment. If it is found that information provided is falsified, you will not be considered for a job with the State of Colorado and/or may be removed from a job after hire. "See resume" statements will not be accepted in lieu of a properly competed application. Failure to include adequate information or follow instructions may affect the applicant's score and/or prevent them from competing in any subsequent measures used to arrive at a top group of applicants. Factors to be assessed are those outlined in the requirements, competencies, and preferred qualifications.

Years will be expressed in terms of full-time equivalent service with full-time workload equal to one (1) Full-Time Equivalent (FTE) year. No more than 1.00 FTE year may be credited in any twelve (12) month period. Positions working 40 hours or less per week will be pro-rated (i.e. 30 hrs/wk=0.75 FTE=9 mos credit; 20 hrs/wk=0.5 FTE=6 mos credit; 10 hrs/wk=0.25 FTE=3 mos credit)