COMPASS Interface Lead / Data Management V - Hybrid

This position is only open to Colorado state residents.

This posting may fill more than one vacancy.

Thank you for your interest in working for the State of Colorado. Join us and find meaningful work in public service to our state and its residents, helping to make Colorado a great place to live and work in. Please watch the short video below for tips on applying. Apply for a job with the State of Colorado

To learn more about what happens after you apply for a position with the State of Colorado, please watch the short, informative video. What Happens After You Apply

Colorado for All Philosophy: Colorado for All means working toward a Colorado where everyone has the opportunity to succeed. It means 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.

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. Our professionals strive to support state government and the residents of Colorado. Customer service is a key component for every position in state government as is the focus on ideas and ways to redesign the delivery of services in making state government more.

 

Good Government Starts Here! 

 

Why We Want You:

We want your expertise, positive energy, drive to succeed, and love of this great state as we work to elevate the expectations Coloradans have of their government.

What You'll Get From Us:

In return for the skilled work you do, DPA provides a competitive compensation and benefits package to accompany employment opportunities. Please see the Benefits Overview video for details on the benefits offered to employees.

• This position is the subject matter expert on the design and function of interface and automated spreadsheet upload for CORE/COMPAS applications. 
• This position oversees and completes changes related to these system functions, including highly specialized knowledge related to mapping and translation of interface files per CORE/COMPAS specifications to ensure the data is populated into the system correctly to be utilized in day-to-day statewide accounting, budget, payroll, and HR activities. 
• This position has knowledge and provides cross-SME support in areas of system integration functions as well, including managing BIRT forms, features of FUD, and transaction attachment management. Additionally, position is responsible for completing all aspects of CORE/COMPAS system administration functions, including monitoring and troubleshooting nightly cycle processes, managing help desk tickets and change orders, executing SQL queries and research in the database to determine issue root causes, manipulating data to correct known errors, assisting with management of inbound / outbound interface file movements, and providing support and maintenance of the test environments, including environment refresh activities. 
• This position is also responsible for participating and leading change management activities, such as end-user testing activities, business and system process improvements, working with users to understand their business needs, and processing requests to migrate changes/patches into the applications. 
• Finally, the position provides support administering Security and Workflow functions, as needed for team work continuity.

A summary of the duties and responsibilities will include, but are not limited to, the following:

CORE/COMPAS Interface & Automated Spreadsheet upload: 

• Position oversees and administers the CORE/COMPAS interfaces and spreadsheet upload processes, to include management of new and existing interface scripts, translation maps created via vendor Pentaho tool, and templates for spreadsheet upload and other interface uploads. 
• Position provides support of all interface jobs and system loading functions for all CORE/COMPAS applications, including troubleshooting research and resolution of any incident tickets or user requests, assistance to the Tier I Help Desk in addressing user questions in this area, and providing nightly cycle reconciliation reporting of interface processing. 
• Position facilitates design, testing, and implementation of configuration requests for new and updated interface/spreadsheet uploads according to established change management procedures, and provides alternate solutions to users as appropriate when configuration to the business need is not technically possible within system operating framework.

CORE/COMPAS Administration: 

• Position monitors and troubleshoots nightly cycle processes, completing outreach as needed to vendor or agency staff to address issues with interface file processes and batch job activities within the Financial and/or Payroll application and to other downstream CORE/COMPAS applications. 
• Position manages help desk ticket and change order requests, adhering to established change management and other processes in timely research and resolution of the ticket requests. 
• Position is responsible for participating in and leading change management activities for assigned projects, such as end-user testing activities, business and system process improvements, working with users to understand their business needs, and adhering to patch migration processes. 
• Position is expected to seek out and understand end users’ business needs and provide prompt, accurate, courteous customer service in delivery of all communications and tasks. 
• Position utilizes SQL queries and research into the database to determine issue root causes, manipulate data to correct known errors, or in support of audit reporting.
• Position provides support in maintenance activities for test environments, including coordinating, scheduling, and post-validating refresh activities.

CORE/COMPAS Integrations:

• As needed, position will provide support on Integration functions for the CORE applications, to include research and resolution of help desk tickets and change orders as directed by manager. 
• As needed, position will assist team members with form creation or updates via BIRT and will work with vendor counterparts on the integration of ECM for document attachments, will provide assistance as needed for Multi-factor and/or VPN technologies for accessing CORE/COMPAS applications, and will investigate and leverage Application Program Interfaces (APIs) as appropriate for real-time integration and data sharing between CORE/COMPAS applications and external systems. 
• Position will participate in issue troubleshooting and resolution with CORE/COMPAS Integration Administration SME and vendor staff.

*A Human Resources Analyst will only review the work experience/job duties sections of the online job application to determine whether you meet the minimum qualifications for the position for which you are applying. Cover letters and resumes WILL NOT be accepted in lieu of the official State of Colorado online application, but may be attached. Applicants must meet the minimum qualifications to continue in the selection process for this position. Work experience and qualifications must be specifically documented on your online application. Do not use "see resume" or "see attached" statements on your application. Resumes WILL NOT be reviewed for minimum qualification screening. If it is determined that you meet the minimum qualifications, your application will also be used as part of the comparative analysis process to identify a top group for further consideration.

This position is advertised in line with the Governor’s executive order (Executive Order 2022 015) focused on skills-based hiring practices that focuses on the knowledge, skills, and abilities specific to the job and aligns the hiring process accordingly. Skills-based hiring reduces potential barriers for applicants and allows for reduced bias in the hiring process by providing a direct description of skills that are unique to the duties assigned to the position with a recognition that the applicant may have developed these skills through education, training or past experiences.

Residency Requirement: 

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

Class Code & Classification Description: 

H1D5XX

DATA MANAGEMENT V

Minimum Qualifications: 

Experience Only:
At least eight (8) years of relevant experience in an occupation related to the work assigned to this position

OR

Education and Experience: 
A combination of related education and/or relevant experience in an occupation related to the work assigned equal to at least eight (8) years.

The exceptional candidate will possess the proven ability or accomplishment in the following preferred qualifications:

• Previous state or local service related to the work assigned to the position

• Experience in State of Colorado professional accounting in the CORE System or another State ERP

• Demonstrated experience with implementing accounting, payroll, procurement and budget functionality in ERP financial systems

• Demonstrated experience with using data translation tools (such as Pentaho, Biztalk, Informatica, Actian or similar) to transform interfaced data and map it into or out enterprise scale applications

• Demonstrated experience with creating, implementing and managing APIs

• Demonstrated experience with enterprise scale system implementations/upgrades, including working in a lead contributor role in all areas of the project SDLC

• Demonstrated ability to absorb, process, and apply a large volume of information and materials

• Outstanding interpersonal skills including the ability to communicate clearly and effectively, both orally and in writing, with a variety of constituents

• Proficiency in SQL, Excel, PowerPoint and Word
  
  

Conditions of Employment:

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

Comparative Analysis Process 
The comparative analysis process for this position may consist of a structured application review, an online assessment and a structured interview.

Appeal Rights: 

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: 303-866-5038. Phone: 303-866-3300. Email address: [email protected]. 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.

Employment Philosophy: The State of Colorado strives to build and maintain workplaces that value and respect all Coloradans. We are building a Colorado for All through a commitment to equal opportunity and hiring based on merit and fitness. The State is committed to non-discriminatory practices in hiring, employment, and advancement opportunities.

Accommodations: The Department of Personnel & Administration 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, Heather Siegal [email protected]