Data Analyst

Foothills Animal Shelter seeks a data analyst who is committed to advancing our mission and excited to engage in the transformative work of animal welfare. 

Who We Are 

As an open admissions shelter, we are committed to being here for families and their pets in Jefferson County, Colorado. We identify as a socially conscious shelter, caring for over 9,000 dogs, cats, and small animals every year with a compassionate team of staff and volunteers who are committed to the physical and emotional wellbeing of every pet and person we serve. 

What You Bring 

• You are a data storyteller. You transform complex data sets into clear, actionable insights that help teams make smarter decisions and raise critical funds in support of our mission. 
• You are a problem-solver. You see inefficiency as an opportunity, and you are always looking for ways to streamline processes, automate tasks, and improve the way we work. 
• You are a skilled communicator. You have a talent for translating technical concepts into language that resonates with stakeholders of all backgrounds — and you ask thoughtful questions to make sure you’re solving the right problem. 
• You are a team player. As a member of our Development and Community Engagement team, you’ll collaborate closely with colleagues across the shelter and pitch in wherever you’re needed. 
• You are reliable and adaptable. You manage competing priorities with ease, meet deadlines consistently, and stay flexible when timelines shift. 
• You recognize the significance of the human-animal bond, and you are excited to raise funds that support the formation and continuation of these powerful relationships. 

What You’ll Do 

• Build, maintain, and improve reporting and data processes that power our fundraising and marketing efforts and support teams across the shelter. 
• Serve as the go-to expert on shelter data — extracting, cleaning, transforming, and presenting information from our databases to support grant requests, marketing communications, and strategic decision-making. 
• Maintain CRM databases, prepare mailing and communication lists, and develop processes that improve data quality and efficiency. 
• Collaborate with colleagues to identify opportunities for process improvement and automation, and support users in understanding and using the tools and reports you create. 

What We Offer 

• Let’s start with the obvious: we offer truly meaningful work that positively impacts the lives of thousands of animals and people each year. 
• This is a part-time, hourly, hybrid position with a minimum of one day onsite per week at our shelter in Golden, Colorado. Candidates must reside in Colorado. 
• We strive for a healthy work-life balance, and we offer generous time off including floating holidays (awarded annually on your employment anniversary), three weeks of accrued vacation, and paid sick leave. 
• Part time employees meeting minimum service requirements may participate in our retirement plan with up to 4% employer match and immediate vesting. 
• The pay rate for this position will be $30.00 - $33.00 per hour, depending on education and depth and breadth of relevant experience. 

View complete job description here. 

JOB QUALIFICATIONS 

Education and Experience 

• Bachelor’s degree in data analytics, statistics, business, computer science, or related field. OR
• Three years of experience working with complex data sets, including data cleaning, analysis, reporting, and visualization. 

Licenses and Certifications 

• Must obtain Fear Free Shelter certification within 60 days of employment. 

Knowledge, Skills, and Abilities 

• Advanced Excel skills, including VBA, macros, and functions such as VLOOKUP/XLOOKUP, FILTER, UNIQUE, SUMPRODUCT, and INDEX/MATCH. 
• Basic coding knowledge; VBA preferred; Office Scripts is a plus. 
• Experience writing SQL queries. 
• Experience working with Power Automate is a plus. 
• Experience migrating databases and/or CRM platforms is a plus. 
• Ability to extract, clean, transform, visualize, and present data in an organized and meaningful way. 
• Ability to communicate complex ideas and methodologies to stakeholders with varying levels of expertise. 
• Strong time management and task prioritization skills with the ability to take ownership and initiative, independently problem-solve, and manage multiple tasks and concurrent priorities. 
• Strong attention to detail and critical thinking skills. 
• Demonstrated ability to provide excellent customer service and interact with the public in a professional and engaging manner. 
• Ability to collaborate effectively with individuals of diverse skills, backgrounds, and expertise levels. 
• Ability to work in a fast-paced environment and adapt to shifting timelines and priorities. 

PHYSICAL REQUIREMENTS 

• Ability to sit for extended periods while performing computer-based work. 
• Fine motor skills and manual dexterity for keyboarding and operating standard office equipment. 

WORKING CONDITIONS 

• Hybrid work arrangement with a minimum of one day onsite per week at the Foothills Animal Shelter facility; must reside in Colorado. 
• Primarily a desk-based office environment with standard office noise levels. 
• Onsite work is performed in an animal shelter environment with regular exposure to animals, noise, odors, animal hair/dander, and common allergens. 

EQUIPMENT USED 

• Computer and standard office equipment. 
• Shelter databases and CRM platforms (e.g., Shelter Buddy, DonorPerfect). 
• Microsoft Office Suite, including advanced use of Excel. 
• Data visualization and reporting tools.