DATA MANAGEMENT III - Data Automation Coordinator - 1082

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

Benefits offered by this job

Free parking

Flexible working arrangements

PERA retirement options

Medical and dental health plans

Life insurance

Disability coverage

Holidays and PTO

Tuition assistance

Wellness programs

Professional development

Career advancement

Job summary

Colorado Department of Public Health and Environment (CDPHE) seeks a Data Management professional to translate business procedures into electronic data automation tools and to develop, monitor, and present data reports for leadership.

You will work with the Data Management Workgroup to support the Clean Water Program, using SQL Server Reporting Services and Business Objects, while training staff on Microsoft and Google applications.

Qualifications

• Six (6) years of professional experience in data management or analysis and management of business processes and systems.
• Bachelor’s degree in business, information technology, management, accounting, public administration, or related field
• Two (2) years of professional experience in data management or analysis and management of business processes and systems.
• 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

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

Skills

Interpersonal skills

Customer service

Attention to detail

Communication skills

Self-motivation

Teamwork

Education

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

Master's degree substitute for bachelor's +1 year experience

Tools

SSRS

Business Objects XI

CEOS

Excel (macros)

Google Apps

Access databases

Job description

This position is only open to Colorado state residents.

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

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

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.

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.

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.