DATA MANAGEMENT III - Data Automation Coordinator - 1082.

Colorado Department of Public Health and Environment; Denver (CO); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Free parking

Flexible working arrangements

PERA retirement options

Health and dental plans

Defined Benefit / DC plans

401K and 457 plans

Life insurance

Disability coverage

11 paid holidays and PTO

Tuition assistance

Wellness programs

Professional development opportunities

Career advancement

Job summary

Colorado Department of Public Health and Environment is seeking a Data Management III to translate procedures for electronic data automation tools, maintain data flows, and develop reports and dashboards for management use.

The role requires strong data analysis skills, experience with Google and Microsoft suites, and the ability to train staff in software applications, including advanced Excel macros and Access databases.

Qualifications

• Six (6) years of professional experience in data management or analysis and management of business processes and systems.
• OR Bachelor's degree plus two (2) years of related experience.
• OR Master's degree substitutes for bachelor’s plus one year experience.

Responsibilities

• 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.
• Develop, monitor, validate, analyze and present data reports and dashboards (SSRS/BOXI or similar).
• Serve as primary liaison with staff to determine reporting requirements.
• Provide training and software assistance to Program Staff on Microsoft and Google applications, including Excel macros and Access databases.

Skills

Data management

Data analysis

Interpersonal skills

Problem solving

Timeliness & accuracy

Communication (verbal & written)

Self-motivation & independence

Education

Bachelor's degree in business/IT/management

Master's degree substitute for experience

Tools

Excel

Access

Google apps

Job description

Department Information

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

Some positions may qualify for the Public Service Loan Forgiveness (PSLF) Program. For more information, go to: https://studentloans.gov/myDirectLoan/pslfFlow.action#!/pslf/launch

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 Complete Application Packet Must Include

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