Senior Data Analyst

City of Boulder•Boulder, CO

1d•Hybrid

About The Position

Under general direction, the Senior Data Analyst provides leadership in the development of community indicators, metrics, data collection and analytics for the Housing and Human Services (HHS) department, including the Regional Housing Strategy, Human Services Strategy, Homelessness Strategy, City Affordable Housing Trends, City’s housing action plan, Boulder Valley Comprehensive Plan, Area Plans, external community funding programs and other work plan projects. This includes researching and developing indicators, metrics and data collection methods and conducting program and data integration and analysis to assess progress on community goals and project priorities; collaborating with department and city teams, including the City Innovation Team; and acting as lead indicator and metrics developer for department with community partners on joint projects.

Requirements

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 Driver’s License and ability to maintain an acceptable motor vehicle record.
Have and maintain acceptable background information, including criminal conviction history.
Bachelor's 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.

Nice To Haves

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.
Master’s degree in Information Technology, business, data analysis, or a related field.
Six (6) years of progressively responsible management in a municipal government organization.

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 data‑driven 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 long‑term 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 department’s compliance with data privacy and governance regulations, specifically HIPAA, CJIS, and state mental health laws.