Senior Data Analyst

Its a great time to join the City of Boulder!

Application Deadline:

Compensation Details:

Scheduled Weekly Hours:

Benefit Eligibility Group:

Locate the Benefit Eligibility Group value on the Employee Benefit Eligibility document to identify the benefits offered for this job.

Job Description Summary:

Job Description:

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Identifies departmental data and technology needs and provides recommendations on business and financial processes; facilitates policy system and process improvements; coordinates data inventorying data collection and research activities; contributes to departmental technology planning within the HHS Data Team; and provides guidance on department policy development method and tool selection application of data governance standards and best practices.
• Conducts data analysis to evaluate the effectiveness of strategic program and policy decisions and leverages findings to design/develop new processes procedures and reports that advance service delivery and datadriven decision making.
• Collaborates with HHS leadership and program managers to implement and maintain best practices; designs and improves business processes to ensure they are efficient aligned with program and financial requirements support accurate and timely reporting and meet federal grant compliance standards.
• Develops configures and maintains HHS Salesforce and Exponent Case Management applications as a Salesforce Administrator including custom objects fields record types page layouts formulas validation rules workflows triggers approval processes Lightning components and other automations while applying change control and change management best practices. Creates reports and dashboards in Salesforce and Power BI and uses Data Loader and other data transformation tools to load update and manage system data.
• Develops complex reports and visualizations using Excel Power Query and Microsoft Power BI for departmental leadership the City Manager City Council and public information requests.
• Collaborates with the Innovation and Technology (IT) team to establish and maintain foundational business processes and technical documentation for HHS programs and to create functional and technical specifications for systems to meet business requirements; participates on city wide team(s) to evaluate new systems and test upgrades to existing systems as they relate to HHS.
• Serves as the department resource in cross-departmental efforts related to data and policy analysis technology improvements and testing financial and outcome reporting process facilitation and problem solving including building effective alliances with other city departments local agencies and community partners.
• Assesses primary research to analyze emerging trends in housing and human services and current local/regional/national conditions to improve city processes; collects and synthesizes local state federal and other relevant data to assess community conditions needs and longterm impacts of departmental work plan; stays current with innovations and best-practice research and data analysis methods outcome-based performance management metrics and approaches relevant to department programs.
• Provides data leadership for Homelessness High Utilizer and Behavioral Health initiatives including establishing and maintaining by-name care coordination lists guiding impact response due to changes to homelessness strategy providing guidance to and data oversight of operational groups; provides active leadership within multidisciplinary teams of legal technical and health program experts in establishing and maintaining robust data privacy and sharing processes.
• Ensures the departments compliance with data privacy and governance regulations specifically HIPAA CJIS and state mental health laws.

MINIMUM QUALIFICATIONS

• Ability to demonstrate excellent written and verbal skills including the ability to produce high quality complex presentation documents.
• Ability to demonstrate proficiency in using advanced technology databases and analytics software- including Microsoft Office Formstack PowerBI project management software and other advanced communication and work management tools.
• Ability to demonstrate skill in establishing and maintaining effective working relationships at all levels of the organization.
• Ability to demonstrate strong analytical problem solving and critical thinking skills.
• Ability to demonstrate strong skills in managing established processes for successful outcomes; strong ability to identify new processes and protocols to improve information and data analytics.
• Ability to demonstrate strong skills in managing multiple projects and tasks and to effectively organize projects and people to meet deadlines in a fast-paced environment.
• Ability to handle confidential or sensitive information appropriately.
• Ability to take appropriate action and to initiate problem resolution and decision making with an outcome-oriented focus within the scope of job responsibilities.
• Ability to understand analyze and effectively communicate about data analytics and indicators in a housing and human services environment.
• Knowledge and experience with housing and human services policy development and/or financing.
• Knowledge of quantitative and qualitative research design methods.
• Knowledge of Salesforce applications and technical requirements or ability to become proficient in Salesforce applications within six months of employment.
• Skill and experience with database and data visualization tools such as Microsoft Power BI and/or ArcGIS Online dashboards and maps.
• Valid Drivers License and ability to maintain an acceptable motor vehicle record.
• Have and maintain acceptable background information including criminal conviction history.

PREFERRED QUALIFICATIONS

• Ability to obtain Criminal Justice Information Systems (CJIS) certification within six months of employment.
• Knowledge and familiarity with federal state and local housing and human services programs and regulations including Federal Grant Programs and compliance requirements
• Knowledge of affordable housing development and finance.
• Skill and experience as a Salesforce System Administrator.
• Skill and experience in creating analyzing and interpreting financial or budget data.
• Skill and experience in project management and serving in a leadership role in a team-based environment.
• Skill and experience with database design.
• Masters degree in Information Technology business data analysis or a related field.
• Six (6) years of progressively responsible management in a municipal government organization.

REQUIRED EDUCATION AND EXPERIENCE

• Bachelors degree in Public Administration Business Information Technology Data Analytics Statistics or related field plus progressively responsible management experience in data or information management in a government or similar organization; or equivalent of eight (8) years experience may substitute for the education requirement only.
• Four (4) years progressively responsible management experience in data or information management in a government or similar organization.

SUPERVISION

Supervision Received: Operations and Homelessness Strategy Senior Manager

Supervision Exercised: None

WORKING CONDITIONS AND REQUIREMENTS

• Physical and Mental Effort: Sufficient clarity of speech and hearing or other communication capabilities that permits the employee to communicate effectively on the telephone and in person. Sufficient vision or other powers of observation that permits the employee to review evaluate and prepare a variety of written documents and materials. Sufficient manual dexterity that permits the employee to operate computer equipment and other office equipment. Sufficient personal mobility and physical reflexes which permits the employee to work in an office setting. Ability to work under stress from deadlines and public contact.

• Work Environment: Works primarily in a clean comfortable environment. Works in a setting subject to continuous interruptions and background noises. This position is subject to the Citys Hybrid Work Policy which establishes a minimum in-person work schedule of the equivalent number of hours associated with two (2) days per standard work week. Must be present within the State of Colorado and be able to work in-person according to the Hybrid Work Policy at the time of employment. Attendance at occasional evening and weekend meetings may be required to perform the duties and responsibilities associated with this position.
• Machines and Equipment Used:Standard office equipment including computers telephones calculators and multi-function printers.

As part of the City of Boulders commitment to a future with equitable access to health prosperity and fulfillment that is not limited by a persons race ethnicity age gender ability religion sexuality or socioeconomic status it is the citys policy to provide equal employment opportunity (EEO) for all individuals. The city does not discriminate in employment opportunities or practices based on race color religion sex (including pregnancy gender identity and sexual orientation) national origin age disability genetic information marital status veteran status or any other characteristic protected by applicable federal state or local law or policy.