Data Management II - Hybrid.

About the role

This position is responsible for monthly processes, straightforward projects, and data-driven assignments as directed by the supervisor. The position involves obtaining, checking, preparing, and populating confidential departmental and statewide data from multiple sources into existing databases and reports.

• Data procedures related to benefits enrollment, vacancy assessments, employee salary range penetration, etc.
• Performing quality control checks on database material and deliverables of peers.
• Managing data and organizing sources into integrated data query systems.
• Leveraging knowledge to assist with upcoming transitions to a new state payroll system.
• Querying data from statewide data sources and completing a variety of data requests and CORA responses related to workforce information.
• Keeping current on State HR and data system structures, processes, and procedures.
• Designing and maintaining surveys within Google forms, or similar programs if needed.
• Assisting with Excel training classes offered to department personnel.
• Working with internal staff (analytics, budget, and accounting) to formulate, investigate, develop, and implement improvements to processes related to the Department's workforce or payroll data.
• Serving as the primary contact on network and Google drive organization and maintenance.
• Leading the unit’s Standard Operating Procedure (SOP) inventory, performing light document control procedures, and initiating routine SOP maintenance efforts across the unit.
• Training unit members on how to properly initiate revisions, publish new versions, properly archive, and update the SOP inventory in the FSU process document log.
• Designing and maintaining a unit toolkit of information covering the unit's overall datasets and utilized data fields, including alignment and cross-referencing of all standard operating procedures generated by the unit, core functional duties, and the datasets themselves.

Responsibilities

• Routine Data Processes
• Data procedures related to benefits enrollment, vacancy assessments, employee salary range penetration, etc.
• Performing quality control checks on database material and deliverables of peers.
• Managing data and organizing sources into integrated data query systems.
• Leveraging knowledge to assist with upcoming transitions to a new state payroll system.
• Querying data from statewide data sources and completing a variety of data requests and CORA responses related to workforce information.
• Keeping current on State HR and data system structures, processes, and procedures.
• Designing and maintaining surveys within Google forms, or similar programs if needed.
• Assisting with Excel training classes offered to department personnel.
• Working with internal staff (analytics, budget, and accounting) to formulate, investigate, develop, and implement improvements to processes related to the Department's workforce or payroll data.
• Serving as the primary contact on network and Google drive organization and maintenance.
• Leading the unit’s Standard Operating Procedure (SOP) inventory, performing light document control procedures, and initiating routine SOP maintenance efforts across the unit.
• Training unit members on how to properly initiate revisions, publish new versions, properly archive, and update the SOP inventory in the FSU process document log.
• Designing and maintaining a unit toolkit of information covering the unit's overall datasets and utilized data fields, including alignment and cross-referencing of all standard operating procedures generated by the unit, core functional duties, and the datasets themselves.

Requirements

• At least five (5) years of relevant experience in data management and analytics OR a combination of related education and/or relevant experience in data management and analytics equal to at least five (5) years.
• Previous State Service related to the work assigned to the position.
• Fluency in Google and Microsoft Office Suite (Excel, Word, Access, PowerPoint).
• Ability to demonstrate professionalism while providing exceptional customer service.
• Exceptional communication skills which include the ability to adapt verbal and written communication style, both formal and informal, to various situations and all levels within the organization.
• Demonstrated ability to independently identify and analyze issues and develop appropriate solutions and plans of action.
• Strong organization, prioritization and self-motivation skills demonstrating a strong work ethic and accomplishes job assignments in a timely manner setting enhanced objectives for self.
• Experience analyzing trends and metrics to support the development of solutions, programs and policies.
• Strong planning skills; attention to detail; productive without compromising quality.
• Ability to work under tight deadlines and adapt to changing priorities.
• Effective interpersonal and relationship building skills with all levels of the organization.

Qualifications

• Residency Requirement: This posting is only open to residents of the State of Colorado at the time of submitting your application.

Skills

• Google and Microsoft Office Suite (Excel, Word, Access, PowerPoint) proficiency.
• Knowledge of VBA and/or SQL programming.
• Professionalism and exceptional customer service skills.
• Ability to drive projects/issues to completion.
• Strong organizational, prioritization, and self-motivation skills.
• Experience analyzing trends and metrics to support the development of solutions, programs, and policies.
• Strong planning skills; attention to detail; productivity under tight deadlines.
• Effective interpersonal and relationship building skills with all levels of the organization.

Benefits

The State of Colorado offers a competitive compensation and benefits package to accompany employment opportunities. Please see the Benefits Overview video for details on the benefits offered to employees.

Pay

Details on pay will be provided upon hire.

Schedule

Details on schedule will be provided upon hire.

Department Information

The Department of Personnel & Administration (DPA) is the foundation for dependable state government, leading with responsiveness, integrity, and teamwork. We provide services to other government agencies and all Coloradans by taking bold initiative toward a government with engaged employees, innovative solutions, and constructive partnerships. DPA provides a wide range of programs and services, from custodial & maintenance to financial and human resources support, which assist other state agencies in fulfilling their missions. At DPA, there are countless opportunities to contribute to meaningful work that supports and serves the people of Colorado. The wide variety of positions in DPA allow individuals to learn about state operations and provide for long-term career growth. If your goal is to build a career that makes a difference and build greater public confidence in good government, consider joining the dedicated people of the State of Colorado; it's a chance to combine your expertise with public service.