AppSheet Platform & Business Solutions Analyst

Department Information

Description of Job

Job Description:

This position serves as the primary technical expert and business solutions analyst for the AppSheet platform, driving the application lifecycle from requirements to support. The growth of AppSheet solutions across the HR technology portfolio requires a dedicated position to successfully scale existing and potential new applications for CDHS. This role merges the responsibilities of a Business Analyst with functions that support product management and system administration, acting as a technical specialist for the AppSheet platform. The position will be an expert in AppSheet and is responsible for translating business needs into application configurations, prioritizing work with stakeholders, and providing system-level support. The position will be an expert in AppSheet but will also cross-train and be available to support the entire HR and Financial Services technology portfolio.

• AppSheet Application Configuration and System Administration
  • Configuration management
  • Access control and security, provisioning varying levels of user access, and implementing and maintaining role security to ensure appropriate data sharing and compliance with privacy requirements.
  • Approve and grant varying levels of user access to AppSheet applications based on established security controls and business needs.
  • Determine the best course of action to address and resolve client concerns or system issues within an AppSheet application.

• 
  Business Process Analysis and Requirements Management
  • Managing product backlog and defining business requirements by collaborating with prospective users and business stakeholders to understand their needs and translate them into product requirements (user stories, acceptance criteria) for AppSheet solutions.
  • Assist in prioritization, helping to manage the product backlog based on changing requirements and business value.
  • Analyzing existing applications for effectiveness and developing strategies for improving or leveraging these systems via the AppSheet platform.

• 
  User Acceptance Testing (UAT), Training, and Customer Support

  • Developing and overseeing testing documentation, including test plans, linking testing to requirements, and coordinating User Acceptance Testing (UAT) sessions with internal stakeholders to validate new bug fixes or features.

  • Training and communication, including designing and maintaining training materials, conducting training sessions for system users, and developing and implementing a communication plan to ensure all impacted departments and users are informed of new releases or changes.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

Experience Only:

Six (6) years of relevant professional experience, which must include at least six (6) months of technical experience designing, developing, or supporting solutions on the low-code/no code Google AppSheet platform, acquired within the last three (3) years.

OR

A combination of related education and/or relevant professional experience equal to six (6) years, which must include at least six (6) months of technical experience designing, developing, or supporting solutions on the low-code/no code Google AppSheet platform, acquired within the last three (3) years.

• 
  AppSheet Platform Expertise: Proficiency in the Google AppSheet platform, including the ability to configure applications, write complex expressions, build automations/workflows, and manage data source connections.

• Business Requirements & Analysis: Proven experience in analyzing business processes and translating complex business needs into clear, actionable technical requirements (such as user stories and acceptance criteria) for low-code/no-code solutions.
• Proactive Problem Solving & Initiative: Exceptional analytical skills with a strong focus on process improvement, an ability to anticipate potential issues, and a drive to independently develop and implement effective solutions.
• Quality Assurance & Change Management: Demonstrated ability to design and lead User Acceptance Testing (UAT), develop comprehensive user training materials, and execute release and change management communication plans.
• System Security & Administration: Strong understanding of system administration and security best practices, particularly regarding access control, role-based security, and platform configuration management.
• Independent Project Execution: Ability to work independently with minimal supervision, effectively manage time in an unstructured environment, and prioritize multiple IT project tasks in a high-pressure setting to meet strict deadlines.
• Communication & Collaboration: Exceptional interpersonal and communication skills required to effectively engage and collaborate with diverse technical and non-technical audiences across all levels of the organization.

• Standard employment background check and reference check required.
• Must possess a valid, non-restricted Colorado Driver’s License.
• This position requires State of Colorado residency at the time of application (unless otherwise identified in the posting), and residency within the state throughout the duration of employment in this position.
• Former State employees who were disciplinarily terminated or resigned in lieu of termination must:
  • Disclose that information on the application.
  • Explain why the prior termination or resignation should not disqualify you from the current position.
  • Provide your employee number from your prior State employment. Absent extraordinary circumstances, prior disciplinary termination or resignation in lieu of termination and failure to provide this information will disqualify the applicant from future State employment with CDHS.

• Preferred Qualifications & Competencies:

  • Relevant years of state service experience.

A Human Resources Analyst will review the work experience/job duties sections of the online job application to determine whether your experience meets the minimum qualifications for the position. You must complete the official State of Colorado online application. Cover letters and resumes WILL NOT be reviewed during the minimum qualifications screening process. You must specifically document your work experience and qualifications. Do not use "see resume" or "see attached."

After minimum qualification screening, the comparative analysis process will involve a review and rating of all the information you submit. The comparative analysis step may also include your results from an eSkills Test.

If listed, answer all supplemental questions as your answers to these questions will be evaluated during this phase. Provide at least 4-8 sentences for each supplemental question.

Answer the supplemental questions completely and thoughtfully. We will rate your answers based on the content of your response and your writing skills (spelling, grammar, and clarity of your writing).

• 
  You or your representative must sign and submit the official appeal form for review.
• You can find the official appeal form here (Download PDF reader).
• You must be deliver the official appeal form to the State Personnel Board:
  • By email (dpa_state.personnelboard@state.co.us), or
  • Postmarked in US Mail to(1525 Sherman Street, 4th Floor, Denver CO 80203, or
  • Hand delivered (1525 Sherman Street, 4th Floor, Denver CO 80203), or
  • Faxed (303.866.5038) within ten (10) calendar days from your receipt of notice or acknowledgement of the department’s action.

• At (303) 866-3300, or
• Refer to the Colorado Code of Regulations (CCR) 801-1, State Personnel Board Rules and Personnel Director's Administrative Procedures, Chapter 8, Resolution of Appeals and Disputes, within the Rules webpage.

Supplemental Information

• Strong, secure, yet flexible retirement benefits including a PERA Defined Benefit Plan or PERA Defined Contribution Plan plus 401(k) and 457 plans
• Medical and dental health plans
• Employer supplemented Health Savings Account
• Paid life insurance
• Short- and long-term disability coverage
• 11 paid holidays per year plus vacation and sick leave
• State of Colorado Employee BenefitHub Resource Center
• Employee Wellness program
• Excellent work-life programs, such as flexible schedules, training and more
• Remote work arrangements for eligible positions
• • Some positions may qualify for the Public Service Loan Forgiveness Program.

• We believe in a people-first approach: We prioritize the needs, well-being, and dignity of the individuals, families and communities we serve. We commit to respect, fairness and access in every decision, policy and interaction. We engage client voices and experiences in the development and implementation of the services we provide.
• Balance creates quality of life: We want our team to be resilient through a supportive workplace that values flexibility, health and wellness, and employee engagement.
• We hold ourselves accountable: We take responsibility through our actions, programs, and results for the state of health and human services in Colorado.
• Transparency matters: We are open and honest with employees, our partners, the Coloradans we serve, and the public.
• We are ethical: We abide by what is best for those we serve by doing what is right, not what is easy.
• Collaboration helps us rise together: We work together with all partners, employees, and clients to achieve the best outcomes for Coloradans.

The State of Colorado is an equal opportunity employer

We are committed to increasing a “Colorado for ALL" of our staff and providing culturally responsive programs and services. Therefore, we encourage responses from people of all backgrounds and abilities. The State of Colorado believes that a “Colorado for ALL” drives 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.