Data Analyst - BITS

Department Information This position is open to current Colorado residents only. Please note: This recruitment may be used to fill multiple vacancies. Business Innovation, Technology and Security (BITS) Operations & Strategy provides management and oversight for key administrative and technical services that enables CDHS to achieve their goals. It is responsible for a number of support functions to make our agency as efficient, effective and impactful as possible. Operations & Strategy comprises Human Resources; Facilities Management; Audit; Business Innovation; Technology and Security; Emergency Management; Legal; Performance Management; Communications; Project Management; and Leadership & Organizational Development. Business Innovation, Technology, and Security (BITS) is responsible for managing the Department’s information technology (IT) providers, including relations with the Governor’s Office of Information Technology (OIT). The division serves as the main point of contact for departmental issues involving technology resources and needs and coordinates activities with the program staff for IT support, operations, maintenance, modernization and implementation of new IT systems. Description of Job Hybrid Work Assignment: Minimum of 2 days per week in the office Please note: These working arrangements are subject to change Duties This position will build and maintain CDHS Data using extracted data from various computer programs; to maintain the database and ensure data accuracy; run reports as needed for CDHS; analyze CDHS data to generate metrics to identify trends, patterns, and correlations; to make recommendations and/or propose solutions to improve metrics; and present data to non-technical individuals in a clear, concise manner. Data Analysis Performs simple to highly complex data analysis using data from multiple data sources to identify trends, patterns, and correlations, summarizes findings and presents data-derived insights to HR team members, HR leadership and other CDHS employees and leadership. Researches, evaluates, and analyzes HR data to determine HR metrics and create compelling stories, charts and graphs that drive business to action. Consults with HR team members, HR leaders, AS leaders, and CDHS leaders to define their analytic needs and determine the best way to address those needs. Supports CDHS leadership team to identify business challenges; use fact-based solutions and data analysis to help influence changes to operations, processes, or programs. Investigates problems and applies both quantitative and qualitative methodologies towards recommending solutions. Provides guidance, training, and subject matter expertise to other staff in asking appropriate questions, selecting the right metrics, interpreting the data, and translating data into actionable recommendations. Builds relationships with business leaders to better understand their business and human capital needs, including identifying and determining the appropriate data to be analyzed to support the objectives of key stakeholders. Documents model assumptions and processes. Data Management Performs simple to complex data manipulation and aggregation of data from multiple HR data sources. Designs, develops, and implements data management processes, procedures, and systems. Manipulates and manages large, complex databases, spreadsheets, and queries. Create SQL databases with efficient structures. Write optimized queries, views, and triggers for integration with other applications. Maintain high standards of data quality and integrity. Understand issues related to network performance and security. Consults with others to understand the HR systems currently available, what data and how data is stored/contained within the system and the best way to pull data from the system. Collaborates with stakeholders to determine the type of data to be reported on and incorporates this information into the CDHS HR database. Collaborates with stakeholders to design, build, and automate key HR metrics. Reviews data input and output reporting for accuracy. Maintains data integrity. Creates and maintains audits of various data sets and measures results against various metrics. Looks for new ways to create efficiencies and increase integrity of data. Researches trends, best practices, and emerging technologies that impact HR analytics. Become proficient in any and all new software/technology adopted by CDHS. Performs data back-up and archival on a regular basis. Reporting Creates simple to complex queries and reports, utilizing multiple data sources, for HR and CDHS. Create and maintain standard operating procedures for report creation and criteria used to create reports. Standardizes queries wherever possible for recurring requests. Actively monitor the data analyst shared email account and ensure all inquiries are responded to in a timely manner. Implements and maintains protocols and procedures for reporting data on a daily, weekly, monthly, quarterly and/or yearly basis. Produces reports as requested by HR and CDHS employees, including requests to meet obligations for the AGs office, DPA, CORA and legislative requests. Debugs and optimize existing queries, views, and tables to improve performance. Experience Only Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights Six (6) years of relevant experience in Data Analysis or other occupation related to the work assigned to this position OR Education And Experience A combination of related education and/or relevant experience in Data Analysis or occupation related to the work assigned equal to six (6) years. Preferred Qualifications Experience working with SQL Server Familiarity with R or Python Familiarity with Tableau Familiarity with AppSheets Familiarity with JavaScript Familiarity with Excel and other MS Office applications Conditions of Employment: Standard background check and reference check required 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. Travel in-state will be required 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. CDHS Selection Process Explanation Employment history is calculated on a full-time basis (40/hrs per week). Part-time employment is calculated on a prorated basis to determine qualifications. Be sure your application specifically addresses your qualifications, experience, work products, and accomplishments as they relate to the position and minimum requirements. Preferred Qualifications & Competencies: Relevant years of state service experience Minimum Qualification Screening Process 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 in the application form. Do not use "see resume" or "see attached." You must meet the minimum qualifications to continue in the selection process. Part-time work experience will be prorated. Comparative Analysis Process – Structured Application Review After minimum qualification screening, the comparative analysis process will involve a reviewing and rating of all the information you submit. The comparative analysis step may also include your results from standardized testing. Your Work Experience/Job Duties Document your work experience/job duties to the extent to which you possess the skills, education, experience, minimum qualifications, and preferred qualifications. 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. Supplemental Questions 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). Appeal Rights You may file an appeal with the State Personnel Board or request a review by the State Personnel Director if your application is eliminated. You will find the appeals process, the official appeal form, and how to deliver it on the State Personnel Board website. You or your representative must sign and submit the official appeal form for review. You can find the official appeal form here. 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. Contact The State Personnel Board For Assistance 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 How To Apply To The State Of Colorado The Assessment Process For additional recruiting questions, please contact Jade Green at jade.green@state.co.us About Us & Benefits If your goal is to build a career that makes a difference, join the dedicated people of the Colorado Department of Human Services (CDHS). Our professionals strive to design and deliver high quality human and health services that improve the safety, independence, and well-being of the people of Colorado. Each of us is committed to contributing to a safe and accessible CDHS. In addition to a great location and rewarding and meaningful work, we offer: 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. Our Values 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. ADA Accommodations CDHS is committed to a Colorado for 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. This includes completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or performing 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 cdhs_ada@state.co.us. EEO Statement 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. Additional Support For Your Application Toll Free Applicant Technical Support If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) call NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application 1) ensure your documents are PDF or Microsoft Word files and 2) close the document before you attempt to upload (attach) it. The State of Colorado offers permanent employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: www.colorado.gov/pacific/dhr/benefits Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon. 01 The bottom of this job announcement provides links to additional information on how to apply, the assessment process, toll free applicant technical support, and about how the State of Colorado is an equal opportunity employer. Please acknowledge below that you have read the information provided in these links. This information is available to me and I have read this information. I am unable to access the links with this information on the job posting. (If you select this option, please contact the recruiter, whose information is listed on this announcement, so that they can send this information directly to you.) 02 Your legal name is used in the hiring process for background checks. Did you use your full legal name in your application? If not, please update your information before submitting your application. Yes No 03 If you are a current or former State of Colorado employee, please list your employee number (starts with 997…). Your application may be considered incomplete if you do not provide this information. An incomplete application may not move forward in the Selection process. If you are a former or current state employee, please identify what state agency you work(ed) with and how many years of relevant state service you have related to the position you are applying for. (Ensure this is listed on your application under work experience). 04 Former State employees who were disciplinarily terminated or resigned in lieu of termination must disclose the information on the application. In the space below, please provide an explanation as to why the prior termination or resignation should NOT disqualify your application from the current position. 05 If you are a former or current state employee, please identify what state agency you work(ed) with and how many years of relevant state service you have related to the position you are applying for. (Ensure this is listed on your application under work experience). 06 Please describe your experience developing reports, dashboards, or similar work. 07 Please speak to the code or data tool you are most proficient with and what you have produced using that tool. 08 Please describe any experience you have working with a non-technical audience for explaining and presenting data. 09 Please describe your process for troubleshooting an output such as a report or dashboard. How did you approach this and what steps do you take to solve it? 10 Please describe your preferred team dynamic and share an example of when you worked as part of a team to accomplish a goal. Required Question