Colorado
DOLA Data Analyst (Statistical Analyst II)-Term Limited
Colorado, Denver, Colorado, United States, 80285
This is a term-limited position with an anticipated end date of
December 31, 2026
. The position may be extended depending upon funding availability and will be eligible for full benefits. Who can Apply
This opportunity is only open to residents of the State of Colorado. About the Colorado Department of Local Affairs The Department of Local Affairs (DOLA) serves as the primary interface between the State and local communities. The Department provides financial support to local communities and professional and technical services (including training and technical assistance) to community leaders in the areas of governance, housing, and property tax administration. While all state governments provide such services through various Departmental structures, Colorados approach is unique in that these local community services are gathered into one Department of Local Affairs, which has a central focus on strengthening Colorado communities and enhancing livability. Vision The Department of Local Affairs is responsible for strengthening Colorado's local communities through: accessible, affordable, and secure housing; implementing property tax law; capacity building; strategic training, research, and technical assistance; and funding to localities. Mission Our mission is to help strengthen Colorados communities. Why work for the Colorado Department of Local Affairs? The work we do matters greatly. It matters to us and it matters to the citizens of the great state of Colorado. We love our communities and are passionate about supporting our communities. We value the diversity that Colorado offers. If your goal is to build a career that makes a difference in communities across the State, consider joining the dedicated people of the Department of Local Affairs. In addition, we offer a great location and great benefits, which include: Medical and Dental Plans
Strong, secure, yet flexible Retirement Plans including PERA Defined Benefit Plan or PERA Defined Contribution Plan plus pre-tax and ROTH 401K, and 457 plans
Employee Wellness Programs
Paid Life Insurance
11 paid Holidays per year plus Vacation and Sick Leave
Short and Long-Term Disability Coverage
RTD Eco Pass to all eligible State Employees
Flexible work schedule options and hybrid work options
Some positions may qualify for the Public Service Loan Forgiveness Program
Training opportunities
Variety of Free discounts on services and products available through the State of Colorado's Work-Life Employment Discount Program
The eligible list created by this recruitment may be used to fill additional vacancies in this classification. The purpose of the Analysis and Research Team (ART) is to dramatically improve programmatic and operational outcomes by delivering findings and recommendations that inform organizational decision-making. This is achieved through the delivery of analytical products and services by two specializations. Policy Analysts, who synthesize recommendations on how laws, rules, internal policies, or procedures be created, modified, or implemented to further the public good while complying with legal and regulatory requirements. Data Analysts, who develop, maintain, and operate processes that automate and standardize the analysis of data, including data dashboards and data warehousing platforms, so analyses may be produced with efficiency and consistency The position leverages a knowledge of statistical analysis, skills in system design, and problem solving ability to develop analytical systems by transforming disparate source data into ready to consume data for and dashboards for analysts and clients through the use of programming that converts administrative logic into system logic. This opening is an opportunity to contribute to a growing and mission oriented organization and team by collaborating closely with peer analysts and other operations, or customer-facing, staff to ideate and create analyses (with cutting-edge tools) that elevate government transparency and efficiency, while advancing progress towards ending homelessness and housing unaffordablility. The primary duties and responsibilities of this position include, but are not limited to: Develops processes that standardize and automate the analysis and visualization of data using technologies such as analytic data warehouses, statistical scripts, and data dashboards.
This work is primarily executed using programming languages such as Standard Query Language (SQL) and Python or R in code editors such as Google Cloud Console or Microsoft Visual Studio Code and leverage systems such as Google BigQuery and data build tool (dbt).
Conducts requirements gathering, through interviews and independent research, to inform the design and development of data dashboards and their underlying data transformation processes.
This position will bridge the understandings of programmatic and data management staff by identifying the administrative processes and descriptive characteristics to be modeled (such as loans originated in rural areas, or housing vouchers issued in the last month), and tracing these back to candidate data sources (such as data originating from the grant or voucher management systems), to design various models in including: integration models, dimensional models, and reporting tables
Develops tables and dashboards that are used by other analysts to make periodic or ongoing decisions about administrative operations or program and organizational strategy.
Monitors the data that is loaded into, transformed, and served by their analytical programs to verify whether the data within them is still recent and accurate.
Develops relationships with clients so that they can be proactively alerted about issues with data analyses, answer questions on analytical methods, and provide additional context
Class Code & Classification Description I1B2XX Statistical Analyst II Experience Only: Six (6) years of relevant experience operational or economic analysis which must have included: 1) using Python, R, or data visualization software such as Looker Studio (or similar) to prepare, analyze, and present data, or 2) designing analytical queries, views, and tables using SQL. Education and Experience:
A combination of related education in Business Analytics, Economics, Statistics, Mathematics, Computer Science or a closely related field (as determined by the agency) AND experience as described above equal to six (6) years. Ensure that the 'Work Experience section of the application is complete and contains all relevant work experience related to the position that you are applying for. Applicants must upload their unofficial college transcripts that include the student name, college name, courses completed and/or degree with date conferred with this application, in order to receive credit. Under the Job Application Fairness Act (SB 23-058), applicants may redact information from certifications and transcripts that identify their age, date of birth or dates of attendance from an educational institution. Required Competencies Demonstrated experience in descriptive or inferential statistics;
Advanced mathematical knowledge and problem-solving.
Strong organizational skills.
Ability to work across teams.
Strong attention to detail.
Strong analytical skills.
Effective problem-solving skills.
Effective verbal and written communication skills.
Experience in technical writing
Ability to multi-task, prioritize assignments, and organize work to accommodate shifting deadlines.
Experience organizing and analyzing large volumes of business or administrative data;
Advanced proficiency in Microsoft Excel or Google Sheets;
Proficient in mathematical calculations and formulas.
Preferred Qualifications State of Colorado government experience as a specialist or analyst
Experience with data analytics and visualization techniques
Knowledge of enterprise data warehouse design, development, and operations (Google BigQuery and similar columnar databases)
Ability to interpret and apply standards, policies, procedures, regulations, and federal laws.
Presentation skills
Experience in project scoping
Experience in business writing
Conditions of Employment You MUST be a Colorado resident (at the time of application) to apply for this position.
Pre-employment criminal background checks will be conducted as part of the selection process.
Applicants must be legally eligible to work in the United States to be appointed to this position. DOLA uses e-Verify, an Internet-based system, to confirm the eligibility of all newly hired employees to work in the United States. DOLA does not sponsor non-residents of the United States.
Only complete applications submitted by the closing date for this announcement will be given consideration. Failure to submit properly completed documents by the closing date of this announcement will result in your application being rejected. Applicants may submit a resume, cover letter/letter of interest detailing how their experience and background address the stated minimum and preferred qualifications/competencies of the job and attach to the online application. Applications left blank or marked See Resume will not be accepted. Please address every requirement for the position with your experience in your application. The application may include the following documents that MUST be uploaded at the time of application: A resume (this is not a substitute for the online application demonstrating work history)
Transcripts (if using education to meet the minimum qualifications)
DD214 (member-4 form) from applicants that may be eligible for veterans preference
Comparative Analysis
Current and former employees (transfers, voluntary demotions, and reinstatements) are required to participate in the comparative analysis process through this job posting. Applications will be reviewed to determine if you meet the Minimum Qualifications (MQs) for the position.Applicants that meet MQs will be included in the Comparative Analysis process. Colorado Revised Statutes require that state employees are hired and promoted through a comparative analysis which may include, but is not limited to, a suitability screening, training and experience review, eSkills Assessment, oral assessment, written performance assessment or it may include a review of your application and your responses to any supplemental questions by a Subject Matter Expert (SME) to assess and rank applicants; the use of generative AI to draft responses without your manual review and edits is strongly discouraged, as it may decrease the accuracy of your application.Be sure your application specifically addresses the requirements as listed in the minimum qualifications. Address your specialized experience, work products, and accomplishments as they relate to the position duties, required competencies and preferred qualificationsin order to establish an eligible list for referral to the hiring manager for final consideration. 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 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. DOLA 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 a reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to Melissa Bellew, DOLA ADA Coordinator at melissa.bellew@state.co.us. Email Address:
All correspondence regarding your status in the selection/examination process will be conducted via email. Include a working email address on your application; one that is checked often as time sensitive correspondence such as exam information or notification will take place via email. Please set up your e-mail to accept messages from state.co.us and info@governmentjobs.com addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam filtered email. Biweekly Pay:
As of July 1, 2023, all DOLA new hires, including transfers of current state employees and reinstatements of former state employees, will be placed on the biweekly pay schedule. This means you will be paid every other Friday for a total of 26 pay periods over the course of a year. Biweekly pay is also lag pay, meaning you will be paid two weeks after the end of each pay period. Please click here for more information about the move to biweekly payroll. Technical Assistance:
If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) please contact NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application first, ensure your documents are PDF or Microsoft Word files, and second, close the document before you attempt to upload (attach) it. Appeal Rights:
An applicant who has been removed from an employment list or removed from consideration during the selection process may request a review by the State Personnel Director. As an applicant directly affected by the results of the selection or comparative analysis process, you may file a written appeal with the State Personnel Director. Review of the completed, signed and submitted appeal will be timely on the basis of written material submitted by you, using the official appeal form signed by you or your representative. This form must be completed and delivered to the State Personnel Board by email at dpa_state.personnelboard@state.co.us within ten (10) calendar days from your receipt of notice or acknowledgment of the Departments action. For further information on the Board Rules, you can 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/board-rules. For questions related to this job posting, please reach out to Yolanda Roberts via email at yolanda.roberts@state.co.us. #J-18808-Ljbffr
December 31, 2026
. The position may be extended depending upon funding availability and will be eligible for full benefits. Who can Apply
This opportunity is only open to residents of the State of Colorado. About the Colorado Department of Local Affairs The Department of Local Affairs (DOLA) serves as the primary interface between the State and local communities. The Department provides financial support to local communities and professional and technical services (including training and technical assistance) to community leaders in the areas of governance, housing, and property tax administration. While all state governments provide such services through various Departmental structures, Colorados approach is unique in that these local community services are gathered into one Department of Local Affairs, which has a central focus on strengthening Colorado communities and enhancing livability. Vision The Department of Local Affairs is responsible for strengthening Colorado's local communities through: accessible, affordable, and secure housing; implementing property tax law; capacity building; strategic training, research, and technical assistance; and funding to localities. Mission Our mission is to help strengthen Colorados communities. Why work for the Colorado Department of Local Affairs? The work we do matters greatly. It matters to us and it matters to the citizens of the great state of Colorado. We love our communities and are passionate about supporting our communities. We value the diversity that Colorado offers. If your goal is to build a career that makes a difference in communities across the State, consider joining the dedicated people of the Department of Local Affairs. In addition, we offer a great location and great benefits, which include: Medical and Dental Plans
Strong, secure, yet flexible Retirement Plans including PERA Defined Benefit Plan or PERA Defined Contribution Plan plus pre-tax and ROTH 401K, and 457 plans
Employee Wellness Programs
Paid Life Insurance
11 paid Holidays per year plus Vacation and Sick Leave
Short and Long-Term Disability Coverage
RTD Eco Pass to all eligible State Employees
Flexible work schedule options and hybrid work options
Some positions may qualify for the Public Service Loan Forgiveness Program
Training opportunities
Variety of Free discounts on services and products available through the State of Colorado's Work-Life Employment Discount Program
The eligible list created by this recruitment may be used to fill additional vacancies in this classification. The purpose of the Analysis and Research Team (ART) is to dramatically improve programmatic and operational outcomes by delivering findings and recommendations that inform organizational decision-making. This is achieved through the delivery of analytical products and services by two specializations. Policy Analysts, who synthesize recommendations on how laws, rules, internal policies, or procedures be created, modified, or implemented to further the public good while complying with legal and regulatory requirements. Data Analysts, who develop, maintain, and operate processes that automate and standardize the analysis of data, including data dashboards and data warehousing platforms, so analyses may be produced with efficiency and consistency The position leverages a knowledge of statistical analysis, skills in system design, and problem solving ability to develop analytical systems by transforming disparate source data into ready to consume data for and dashboards for analysts and clients through the use of programming that converts administrative logic into system logic. This opening is an opportunity to contribute to a growing and mission oriented organization and team by collaborating closely with peer analysts and other operations, or customer-facing, staff to ideate and create analyses (with cutting-edge tools) that elevate government transparency and efficiency, while advancing progress towards ending homelessness and housing unaffordablility. The primary duties and responsibilities of this position include, but are not limited to: Develops processes that standardize and automate the analysis and visualization of data using technologies such as analytic data warehouses, statistical scripts, and data dashboards.
This work is primarily executed using programming languages such as Standard Query Language (SQL) and Python or R in code editors such as Google Cloud Console or Microsoft Visual Studio Code and leverage systems such as Google BigQuery and data build tool (dbt).
Conducts requirements gathering, through interviews and independent research, to inform the design and development of data dashboards and their underlying data transformation processes.
This position will bridge the understandings of programmatic and data management staff by identifying the administrative processes and descriptive characteristics to be modeled (such as loans originated in rural areas, or housing vouchers issued in the last month), and tracing these back to candidate data sources (such as data originating from the grant or voucher management systems), to design various models in including: integration models, dimensional models, and reporting tables
Develops tables and dashboards that are used by other analysts to make periodic or ongoing decisions about administrative operations or program and organizational strategy.
Monitors the data that is loaded into, transformed, and served by their analytical programs to verify whether the data within them is still recent and accurate.
Develops relationships with clients so that they can be proactively alerted about issues with data analyses, answer questions on analytical methods, and provide additional context
Class Code & Classification Description I1B2XX Statistical Analyst II Experience Only: Six (6) years of relevant experience operational or economic analysis which must have included: 1) using Python, R, or data visualization software such as Looker Studio (or similar) to prepare, analyze, and present data, or 2) designing analytical queries, views, and tables using SQL. Education and Experience:
A combination of related education in Business Analytics, Economics, Statistics, Mathematics, Computer Science or a closely related field (as determined by the agency) AND experience as described above equal to six (6) years. Ensure that the 'Work Experience section of the application is complete and contains all relevant work experience related to the position that you are applying for. Applicants must upload their unofficial college transcripts that include the student name, college name, courses completed and/or degree with date conferred with this application, in order to receive credit. Under the Job Application Fairness Act (SB 23-058), applicants may redact information from certifications and transcripts that identify their age, date of birth or dates of attendance from an educational institution. Required Competencies Demonstrated experience in descriptive or inferential statistics;
Advanced mathematical knowledge and problem-solving.
Strong organizational skills.
Ability to work across teams.
Strong attention to detail.
Strong analytical skills.
Effective problem-solving skills.
Effective verbal and written communication skills.
Experience in technical writing
Ability to multi-task, prioritize assignments, and organize work to accommodate shifting deadlines.
Experience organizing and analyzing large volumes of business or administrative data;
Advanced proficiency in Microsoft Excel or Google Sheets;
Proficient in mathematical calculations and formulas.
Preferred Qualifications State of Colorado government experience as a specialist or analyst
Experience with data analytics and visualization techniques
Knowledge of enterprise data warehouse design, development, and operations (Google BigQuery and similar columnar databases)
Ability to interpret and apply standards, policies, procedures, regulations, and federal laws.
Presentation skills
Experience in project scoping
Experience in business writing
Conditions of Employment You MUST be a Colorado resident (at the time of application) to apply for this position.
Pre-employment criminal background checks will be conducted as part of the selection process.
Applicants must be legally eligible to work in the United States to be appointed to this position. DOLA uses e-Verify, an Internet-based system, to confirm the eligibility of all newly hired employees to work in the United States. DOLA does not sponsor non-residents of the United States.
Only complete applications submitted by the closing date for this announcement will be given consideration. Failure to submit properly completed documents by the closing date of this announcement will result in your application being rejected. Applicants may submit a resume, cover letter/letter of interest detailing how their experience and background address the stated minimum and preferred qualifications/competencies of the job and attach to the online application. Applications left blank or marked See Resume will not be accepted. Please address every requirement for the position with your experience in your application. The application may include the following documents that MUST be uploaded at the time of application: A resume (this is not a substitute for the online application demonstrating work history)
Transcripts (if using education to meet the minimum qualifications)
DD214 (member-4 form) from applicants that may be eligible for veterans preference
Comparative Analysis
Current and former employees (transfers, voluntary demotions, and reinstatements) are required to participate in the comparative analysis process through this job posting. Applications will be reviewed to determine if you meet the Minimum Qualifications (MQs) for the position.Applicants that meet MQs will be included in the Comparative Analysis process. Colorado Revised Statutes require that state employees are hired and promoted through a comparative analysis which may include, but is not limited to, a suitability screening, training and experience review, eSkills Assessment, oral assessment, written performance assessment or it may include a review of your application and your responses to any supplemental questions by a Subject Matter Expert (SME) to assess and rank applicants; the use of generative AI to draft responses without your manual review and edits is strongly discouraged, as it may decrease the accuracy of your application.Be sure your application specifically addresses the requirements as listed in the minimum qualifications. Address your specialized experience, work products, and accomplishments as they relate to the position duties, required competencies and preferred qualificationsin order to establish an eligible list for referral to the hiring manager for final consideration. 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 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. DOLA 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 a reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to Melissa Bellew, DOLA ADA Coordinator at melissa.bellew@state.co.us. Email Address:
All correspondence regarding your status in the selection/examination process will be conducted via email. Include a working email address on your application; one that is checked often as time sensitive correspondence such as exam information or notification will take place via email. Please set up your e-mail to accept messages from state.co.us and info@governmentjobs.com addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam filtered email. Biweekly Pay:
As of July 1, 2023, all DOLA new hires, including transfers of current state employees and reinstatements of former state employees, will be placed on the biweekly pay schedule. This means you will be paid every other Friday for a total of 26 pay periods over the course of a year. Biweekly pay is also lag pay, meaning you will be paid two weeks after the end of each pay period. Please click here for more information about the move to biweekly payroll. Technical Assistance:
If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) please contact NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application first, ensure your documents are PDF or Microsoft Word files, and second, close the document before you attempt to upload (attach) it. Appeal Rights:
An applicant who has been removed from an employment list or removed from consideration during the selection process may request a review by the State Personnel Director. As an applicant directly affected by the results of the selection or comparative analysis process, you may file a written appeal with the State Personnel Director. Review of the completed, signed and submitted appeal will be timely on the basis of written material submitted by you, using the official appeal form signed by you or your representative. This form must be completed and delivered to the State Personnel Board by email at dpa_state.personnelboard@state.co.us within ten (10) calendar days from your receipt of notice or acknowledgment of the Departments action. For further information on the Board Rules, you can 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/board-rules. For questions related to this job posting, please reach out to Yolanda Roberts via email at yolanda.roberts@state.co.us. #J-18808-Ljbffr