Senior Data Analyst

About Our Job

With competitive pay, great benefits, and endless opportunities, working for the City and County of Denver means seeing yourself working with purpose — for you, and those who benefit from your passion, skills and expertise. Join our diverse, inclusive and talented workforce of more than 11,000 team members who are at the heart of what makes Denver, Denver.

What We Offer

The City and County of Denver offers a competitive salary commensurate with education and experience. The salary range for this position is $82,540.00 – 136,191.00/year. Our starting hiring range is $82,540.00 – $109,366.00/year, based on experience and education.

We also offer generous benefits for full-time employees which include but are not limited to:

• A guaranteed life-long monthly pension, once vested after 5 years of service
• 457B Retirement Plan
• 140 hours of PTO earned within first year + 11 paid holidays, 1 personal holiday and 1 volunteer day per year
• Competitive medical, dental and vision plans effective within 1 month of start date

Location

The City and County of Denver supports a hybrid workplace model. Employees work where needed, at a city site and/or in the community several days a week. In this position, you can expect to work on site at least two days a week at the Republic Plaza at 370 17th Street, Denver, CO 80202. Employees must work within the state of Colorado on their off-site days.

What You’ll Do

At the Department of Housing Stability, we are committed to support Denver residents as healthy, housed and connected. We invest resources, create policy, and partner with various organizations to help keep residents in the homes that they already live in, quickly resolve an experience of homelessness, and connect residents to new housing opportunities. To support these efforts, the department helps to:

• Stabilize residents at risk of involuntary displacement and connect residents to housing resources such as home repairs, rent and utility assistance, and legal support. This work is led by our Homelessness Resolution and Housing Stability Division.
• Support persons experiencing homelessness by connecting them to housing, shelter and other services to get stabilized quickly. This work is led by our Homelessness Resolution and Housing Stability Division.
• Create and preserve existing affordable housing and connect residents at any income level to new housing opportunities through programs such as down payment assistance or counseling services. This work is led by our Housing Opportunity Division.
• Support financial services, contracting and procurement, data analysis and strategic planning, administrative resources, and communications across the housing continuum. This work is led by our Operations Division.

The Senior Data Analyst is part of our Operations Division. As part of the implementation of HOST’s vision of a healthy, housed, and connected Denver, our Senior Data Analyst will join our Data Team, which supports the department through a foundation of strong data systems, analytics, and reporting.

In this role, the Senior Data Analyst will design and implement efficient and effective data solutions to inform departmental decision making and processes. This work will likely involve automation, integrating data from multiple sources, and creating visualizations and other tools to help make data accessible to the HOST team, other City agencies and the public.

Additionally, as our Senior Data Analyst, you will:

• Collaborate with team members to develop dashboards and reports to provide insights into public investment performance and departmental impact, including strategic plan goals, Annual Action Plan targets, and other performance management, communications, and compliance needs.
• Work with internal and external stakeholders to obtain data, understand data needs and design strategies to analyze and evaluate key questions.
• Extract data from key data systems including but not limited to Snowflake, Salesforce, Homeless Management Information System (HMIS) files, and others. Prepares, transforms, analyzes, and visualizes data.
• Develop and test automation scripts and queries. Utilizes data processing and modeling tools to assess data quality and meet project objectives.
• Evaluate processes to restructure and combine data sets across systems for optimal reporting and analysis, particularly those that can be automated through use of coding. Assist the Management Analyst Supervisor and other data team members with all aspects of the team’s functions including performance reporting and monitoring progress.
• Provide advice and support to department/agency teams on cleaning, validating, manipulating, and analyzing data.

What You’ll Bring

We value diversity of ethnicity, race, socioeconomic status, sexual identity, gender, religion, language, ability, and experience and exemplify this through the makeup of our team at all levels. You’ll be right at home here if you cultivate strong relationships and push yourself, your work, the people around you and Denver to the next level.

Our ideal candidate has some or all the following experience, skills, and characteristics:

• Experience cleaning and analyzing data from administrative and relational databases that are built on the following platforms: Snowflake, Salesforce, HMIS, and others.
• Demonstrated proficiency in statistical software and/or coding languages (e.g., DAX, SAS, Stata, SPSS, R, Python, SQL). Experience in data processing, database programming, data analytics, and strong data quality auditing skills.
• Programming experience including automation solutions of medium to high technical complexity in the following languages and platforms: DAX, R, and SQL.  Python, SAS, Stata, SPSS may also be utilized.
• Experience creating visual dashboard reporting from multiple data sources using data intelligence software (e.g., PowerBI, Tableau, etc.).
• Ability to perform statistical analyses and summarize the implications of those analyses to decision makers.
• Experience with data, workflow, and process improvement analysis.
• Working familiarity with Census and other federal housing related data sets. Strong written and verbal communications skills with the ability to communicate to both technical experts and non-technical audiences.
• Ability to work independently and as part of a team to prioritize work across multiple projects and meet critical deadlines.
• Thorough understanding of homelessness or housing programs and using data to advance equity, diversity, and inclusion goals. Passion for ensuring everyone in Denver is healthy, housed, and connected.

Required Minimum Qualifications

• Education requirement: Bachelor’s Degree in Computer Science, Information Systems, Statistics, Actuarial Science, Data Administration, or other related field.
• Experience Requirement: Three (3) years of data analytics experience.
• Education/Experience Equivalency: One (1) year of the appropriate type and level of experience may be substituted for each required year of post-high school education. Additional appropriate education may be substituted for the minimum experience requirements.

Application Deadline

This position is expected to stay open until January 12, 2025. Please submit your application as soon as possible and no later than January 12, 2025, at 11:59 p.m. to ensure consideration.

To be considered for this position, you must include the following on your job application (upload the attachment(s) to the Resume/CV section on the My Experience tab):

• Cover letter detailing your skills and experience with data analysis, usage of systems such as Snowflake, Salesforce, and HMIS, and your interest with our position.
• Resume.

About Everything Else

Job Profile

CD3299 Data Analytics Senior

To view the full job profile including position specifications, physical demands, and probationary period, click here.

Position Type

Unlimited

Position Salary Range

$82,540.00 – $136,191.00

Starting Pay

$82,540.00 – $109,366.00/year, based on experience and education

Agency

Department of Housing Stability

The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law. 

It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days’ notice.

Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.

For information about right to work, click here for English or here for Spanish.