Analyst, Data-Housing & Equity

POSITION TITLE: Analyst, Data-Housing & Equity (Full-Time Regular) (Classified)
REQUISITION #: req7352
DEPARTMENT: Social Sustainability
LOCATION: 222 LAPORTE
BENEFIT CATEGORY: Classified (Non-CBU) View Classifications & Benefits
EMPLOYMENT TYPE: Full-Time Regular
ANNUAL SALARY RANGE: $71,615.00 - 119,357.00 (Salaries are paid biweekly)
ANNUAL ANTICIPATED HIRING RANGE: $84,000.00 - $104,000.00 (Salaries are paid biweekly)
SELECTION PROCESS: Application deadline is 3:00 p.m. MT on 12/4/2023.
The City of Fort Collins is a bias-conscious employer. We ask that you please avoid the use of photos when submitting a resume and/or an application for employment. You will receive an email acknowledgment when you have successfully submitted an application. Your completed application will be forwarded to the hiring manager. You will be notified if you are selected for further testing or interviews. Please keep your contact information up-to-date. The status of your application will be updated in your applicant profile. Post-offer background check required.
Why Work For the City of Fort Collins?

• Medical, dental, vision (for self, spouse, children) - eligible on the 1st of the month following date of hire
• Paid vacation, paid holidays, sick leave, and additional one-time bank of 40 PTO hours for new, full-time, Classified and Unclassified Management hires
• Retirement + company contributions - after 6 month probation period and immediate vesting
• Flexible spending: Medical expenses FSA, dependent FSA or both
• Employee Assistance Program: counseling, legal, financial assistance
• Life insurance, short-term and long-term disability
• Wellness program, workout facilities
• Employee/family onsite health clinic
• Learning and development opportunities at all levels in the organization with opportunities for career mobility
• Collaborative work environment

To learn more about The City of Fort Collins and Our Community, please read Our Community and Our Organization Brochure
Job Summary
Responsible for data analysis, evaluation, and reporting on housing, homelessness, and Diversity, Equity and inclusion (DEI) efforts for the City's Social Sustainability Department (SSD) and Equity Office. This position also plays a vital role in creating a data routine for the organization and works collaboratively with other data analysts across the City.
Essential Duties and Responsibilities
The following duties and responsibilities are illustrative of the primary functions of this position and are not intended to be all inclusive.

• Research, plan, identify, gather, monitor, forecast, and analyze data related to Housing & Equity
• Ensure data sets and use of data meet City requirements for technical quality, reliability, reporting, and analysis/evaluation
• Develop, design, implement, and manage City Housing and Equity databases and public-facing dashboards
• Develop standards, policies, and procedures of database management, oversight, and maintenance
• Develop reports, dashboards, and other end-products that offer summaries, alternatives, findings, and recommendations; prepare quarterly/annual progress reports
• Develop relationships with historically excluded community members and play a lead role in the City's efforts to integrate an equity lens into City data collection and reporting
• Evaluate the impact of city funding and programs from a triple-bottom-line and equity perspective
• Create reports, data visualizations, and other data products to show the impact of policies in achieving goals around housing and equity and to support community, City, and Council decision-making around complex social issues
• Ability to tell the story behind and about the data - as well as impacts from policy decisions
• Develop data partnerships across the City organization (e.g., Utilities, Planning Development and Transportation, GIS, and similar)
• Evaluate data methodologies, procedures, and/or processes to propose optimal use of data for the City's Housing and Equity Strategic Plans. Identify problems and recommend improvements, revisions, and/or modifications of data gathering and management processes and procedures.
• Develop, maintain, and schedule customized reports to pull and arrange information from multiple systems for distribution and sharing.
• Conduct benchmarking to identify emerging data needs, trends, and services. Point out anomalies or concerns with data.
• Assist in developing and maintaining local messaging and storytelling through data
• Collaborate as requested with local, regional, state, or federal partners.
• Monitor trends in policies, programs, and the economy to assess whether implementations is occurring adequately
• Assess the potential impacts of proposed policies, including resources needed to implement.

Management Responsibilities
No
City Competencies

• Demonstrated cultural competence to effectively interact, work, and develop meaningful relationships with people of diverse identities, perspectives, and cultural backgrounds.
• Strong learning orientation. Leverages all resources and is creative in ways of learning for self to continue adapting to changing issues and trends.
• A desire and ability to understand the diverse needs of internal and external customers, and to create experiences and deliver services that exceed their expectations.
• A desire and ability to utilize digital tools for organizational information, individual, and teamwork.

Required Knowledge Skills and Abilities

• Graduate-level research skills, including data identification, validation, statistical analysis, and database management.
• Knowledge of and experience with research and statistical methods.
• Strong ability to assemble and analyze large amounts of data and information, identify patterns, errors, and trends, and draw reasonable conclusions.
• Excellent written and verbal communication skills; ability to prepare analytical and summary reports.
• Proficient knowledge in relational database concepts, design, and development.
• Proficient knowledge in data reporting applications such as Crystal Reports, Power BI, and SQL Server Reporting Services.
• Proficient knowledge in database recovery techniques, performance monitoring, and tuning.
• Knowledge of performance measurement and evaluation methodologies.
• Ability to develop and maintain effective working relationships with City staff and management, City Council, and the general public.
• Ability to summarize and communicate findings and policy issues, tell stories with data, and use data to predict future trends depending on policy changes.
• Knowledge of local government organizational structure, functions, and operations.

Required Qualifications
MinimumPreferred
College degree or equivalent work experience. Some positions may require functionally related certification or advanced degrees
Bachelors degree or equivalent work experience in Statistics, Economics, Data Analysis, Computer Science, Mathematics or related field.
Masters degree and directly applicable work experience in statistics, economics, data analysis, computer science, mathematics or related field. Additional coursework or experience using data/statistical analysis in social work; diversity, equity, and inclusion; urban planning; public administration; or similar fields highly desired.
Experience Requirements

• Three (3) or more years of related work experience; or equivalent combination of education and experience.

Studies have shown that women and people of color are less likely to apply for jobs unless they believe they can perform every job description task. We are most interested in finding the best candidate for the job, and that candidate may come from a less traditional background. The City may consider an equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.
The content in this posting was created for recruitment purposes. To view the full job description click the link below.
Analyst, Data-Housing & Equity
The City of Fort Collins will make reasonable accommodations for access to City services, programs and activities and will make special communication arrangements for persons with disabilities. Please call (970) 221-6535 for assistance.
Notice Regarding Medical and/or Recreational Marijuana Use:
Because the possession and use of marijuana, whether for medical use or otherwise, constitutes a federal offense and because the City is a drug free workplace, the City will not accommodate the medical use of marijuana and enforces written policy prohibiting working for the City while marijuana is in the body. The fact that state law recognizes medical marijuana as a prescribed, or otherwise permitted, medication does not alter or otherwise change this policy.
The City of Fort Collins is an Equal Opportunity Employer. Applicants are considered for positions for which they have applied without regard to race, color, religion, creed, national origin or ancestry, sex, sexual orientation (including perceived sexual orientation), gender identity and expression, disability, age 40 years or older, pregnancy or related condition, genetic information, and, in certain specific circumstances, marriage to a coworker or any other status protected under federal, state, or local law.
BACKGROUND CHECK REQUIRED.
Note: Some information in your application may be public information under the Colorado Open Records Act.