DATA MANAGEMENT III - Data Automation Coordinator - 1082

State of Colorado; Denver (CO); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Free parking and access to RTD bus

Flexible working arrangements

Retirement (PERA options)

Medical and dental health plans

Short- and long-term disability

11 paid holidays per year

Tuition assistance

Wellness programs

Professional development opportunities

Career advancement opportunities

Job summary

The Data Management III role at the Colorado Department of Public Health and Environment focuses on transforming data workflows, building dashboards, and delivering timely data insights for program needs. You will work with staff and contractors to translate procedures for automated data tools, and to develop reports using SSRS/BOXI, Excel, Access, and Google applications.

Applicants should have a strong background in data management, reporting requirements, and the ability to train others while

Qualifications

• Six (6) years of professional experience in data management or analysis and management of business processes and systems.
• Graduation from an accredited college or university with a bachelor's degree in business, information technology, management, accounting, public administration, or a related field (and two years of related experience)
• A master’s degree in business, information technology, management, accounting, public administration or closely related will substitute for the bachelor’s degree and one year of experience.

Responsibilities

• Translate business procedures and requirements for new electronic data automation tools.
• Develop, monitor, validating, analyzing and presenting data reports and dashboards using SSRS or BOXI or other reporting language.
• Serve as liaison to determine reporting requirements and train staff in Microsoft and Google applications, including writing macros in Excel and maintaining Access databases.
• Support data quality control and assurance, maintain data flows and develop new ones.

Skills

Data analysis

SSRS

Excel macros

Access databases

Google apps

Communication skills

Education

Bachelor's degree in business, information technology, management, accounting, public administration, or related field

Master's degree in related field substitutes for bachelor’s +1 year experience

Tools

BOXI

Microsoft Office

Google Suite

Job description

Department Information

This position is only open to Colorado state residents.

2026 HR Video -- Combo edited.mp4

At The Colorado Department of Public Health and Environment (CDPHE) we are dedicated to the Colorado for All philosophy - working toward a Colorado where everyone has the opportunity to succeed.

We support the basic human rights of our neighbors regardless of gender, race, ethnicity, religion, national origin, age, sexual orientation, gender identity, citizenship status, education level, disability, socio-economic status, or any other visible or invisible identity. We are committed to increasing the diversity of our staff and providing culturally responsive programs and services. Therefore, we strongly encourage individuals from diverse backgrounds to apply.

Be BOLD.....Make a REAL difference . . join us in serving our communities advancing Colorado's health and protecting the places we live, work, learn, and play, to create a healthy and sustainable Colorado where current and future generations thrive.

CDPHE Offers

• Free parking and access to RTD bus lines.
• Flexible working arrangements
• Retirement ( PERA options), Medical and dental health plans
• Defined Benefit Plan or the PERA Defined Contribution Plan, plus optional 401K and 457 plans
• Paid life insurance
• Short- and long-term disability coverage
• 11 paid holidays per year and generous personal time off
• Tuition assistance
• Wellness programs
• Professional development opportunities on a wide variety of subjects
• Career advancement opportunities throughout the State system

Description of Job

Work Unit

The Data Management Workgroup provides data requirements assessment for the Clean Water Program, stakeholder training for electronic data reporting, internal database training, database reporting and data entry. This workgroup also provides training and assistance to all Clean Water Program personnel for software applications, including but not limited to Xcel, Access, Business Objects, Word, and Google apps. This group is also involved in the CEOS replacement project. (CEOS is the online portal for all Environmental programs.)

Job Duties

This position will work with the supervisor and contractors to translate business procedures and requirements for new electronic data automation tools. Assist in Data Quality Control and Assurance requirements and procedures. Maintain and monitor current data flows and develop new flows. Responsible for developing, monitoring, validating, analyzing and presenting data reports and dashboards based on programmatic needs using SSRS (SQL Server Reporting Services), BOXI (Business Objects XI) or other reporting language (TBD) to be used by management and staff. Primary liaison with staff members to determine reporting requirements. Primary liaison to Program Staff for software assistance and training in Microsoft and Google applications, including writing complex macros in Excel and maintaining Access databases. Secondary liaison (after supervisor) to management for determining reporting requirements.

Key Responsibilities

• Automation of electronic data transfer implementation
• ICIS/Database/CEOS Report Writing
• Monitoring of automated data exchanges
• Training internal staff and stakeholders

Minimum Qualifications, Substitutions, Conditions Of Employment & Appeal Rights

DATA MANAGEMENT III (H1D3XX)

Minimum Qualifications

Six (6) years of professional experience in data management or analysis and management of business processes and systems.

OR

Graduation from an accredited college or university with a bachelor's degree in business, information technology, management, accounting, public administration, or a related field

AND

Two (2) years of professional experience in data management or analysis and management of business processes and systems.

OR

A master's degree in business, information technology, management, accounting, public administration or closely related will substitute for the bachelor's degree and one year of experience.

This experience must be substantiated within the Work Experience section of your application. "See Resume" will not be accepted. In addition, part-time work will be prorated.

Preferred Qualifications And Essential Competencies

• Database experience
• Relevant years of State service shall be considered
• Experience working with Google and Microsoft Suite products
• Excellent interpersonal and customer service skills
• Problem solving
• Ability to ensure that work performed meets standards for timeliness, accuracy and completeness
• Keen attention to detail
• Ability to self-motivate
• Ability to work well independently as well as in/with a team
• Strong verbal and written communication skills and effective listening skills

Conditions Of Employment

• A pre-employment background check will be conducted as part of the selection process.

Appeal Rights

As an applicant who has been removed from consideration during the selection or comparative analysis process, you may file an appeal with the State Personnel Board and/or request a review by the State Personnel Director. A standard appeal form is available on the State Personnel Board website, https://spb.colorado.gov/forms-and-filing. 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 ten (10) days of your receipt of this notice: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. Fax: [phone]. Phone: [phone]. Email address: [e-mail]. The ten-day deadline and these appeal procedures also apply to all charges of discrimination. Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at spb.colorado.gov.

Supplemental Information

• A completed State of Colorado application.
• If using education to qualify, or to demonstrate completion of preferred coursework, a copy of your college/university transcripts. Transcripts can be attached to your CO Jobs application. Late transcripts will not be accepted.
• A cover letter describing how your professional experience aligns with the preferred qualifications.
• If you are a veteran, a copy of your DD214 must be attached to your colorado.gov/jobs application.

The Selection Process

• All applications that are received by the closing of this announcement will be reviewed against the Minimum Qualifications in this announcement. Candidates who meet the minimum qualifications proceed to the next step.
• Colorado Revised Statutes require that state employees are hired and promoted based on merit and fitness through a comparative analysis process.

Part of, or all of, the comparative analysis for this position may be a structured application review, which involves a review of the information you submit in your application materials by Subject Matter Experts (SMEs) against the preferred qualifications.

• A top group, up to six candidates, will be invited to schedule an interview with the hiring manager.

E-Verify: CDPHE uses e-Verify, an Internet-based system, to confirm the eligibility of all newly hired employees to work in the United States. Learn more about E-Verify, including your rights and responsibilities.

ADAAA Accommodations

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. The Colorado Department of Public Health and Environment 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 [e-mail] or call 303-692-2060, option 5.

The State of Colorado offers permanent employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: www.colorado.gov/pacific/dhr/benefits

Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.

Application Question 1

Applicants for State of Colorado classified positions must be current residents of Colorado. Are you a current resident of the State of Colorado who can provide proof of Colorado residency?

• Yes
• No

Application Question 2

A pre-employment background check will be conducted as part of the selection process. Should your background check reveal any charges and convictions, it is your responsibility to provide the Colorado Department of Public Health and Environment Human Resources office with an official disposition of any charges. Conviction does not mean automatic disqualification and will be assessed on a case-by-case basis. As a condition of employment, are you willing and able to submit to a background check?

• Yes
• No

Application Question 3

Have to attached a cover letter to your submitted application. If you have not attached a cover letter to your application do so now.

• Yes
• No

Application Question 4

This position requires educational transcripts or diplomas to be submitted if you are using education to be meet the minimum qualifications for this position or for the substitution of education for some experience. If you are using education to meet the minimum qualifications or substitution for this position, a copy of your unofficial (or official) transcript/diploma is required please attach to your application by the application deadline. Have you attached your transcripts?

• Yes
• No
• Required Question