Data Analyst

Description:

Are you a “data nerd” who wants to use your analytical skills, curiosity, and creativity to make a meaningful impact? Do you want to channel your experience working with data to help environmental, social justice, and cultural arts organizations connect with people who care about progressive causes?

As a Data Analyst at Avalon Consulting Group, a full-service fundraising consulting agency, you'll support our Analytics team by transforming complex datasets into insights that drive client strategy. You’ll create compelling data visualizations, automated reports, and actionable analyses that help our clients raise millions to advance their missions. This is an exceptional opportunity to work with mission-driven clients and collaborate with an expert team that’s passionate about data, dedicated to our clients’ causes, and fun!

What You’ll Do with Us

• Analytics & Insights – Create major findings analyses, dashboard reports, ROI analyses, custom analyses, and other deliverables that inform client strategy. Produce data visualizations that communicate trends and outcomes clearly and effectively.
• Data Management & Quality – Clean, standardize, and import data from diverse client sources. Define, follow, and perform quality control measures to ensure data accuracy and reliability.
• Automation & Efficiency – Develop and run SQL queries, optimize data workflows, and produce automated reports to improve data access and consistency.
• Project Coordination – Manage timelines, priorities, and deliverables for multiple client projects. Coordinate across internal teams to ensure work is completed on time and at the highest quality.
• Collaboration & Support – Advise internal teams and clients on appropriate analytical methodologies to achieve project objectives. Participate in Avalon and industry trainings to strengthen your skills and expertise.

Requirements:

What We Need

We’re looking for someone with at least three (3) years of experience as a data analyst working with large databases and datasets. Proficiency in SQL and Tableau Desktop is required, along with strong Excel skills and the ability to manage multiple projects simultaneously.

Experience with SQL Server Management Studio (SSMS) or equivalent tools is expected. The ideal candidate should also bring experience data mining, developing code, and improving computational performance through efficient scripts. Advanced programming or scripting, such as PL/SQL, experience is a plus. Programming in Python or R is highly desired. The ability to create data models and forecasts is highly desired.

Our most successful staff also bring these qualities to the table:

• A strong desire to learn and the wisdom to know when to ask for help
• Exceptional attention to detail
• The ability to manage multiple projects and deadlines at once
• Self-motivation, reliability, and ownership of tasks with minimal oversight
• Resourcefulness and a creative, solutions-oriented mindset
• Top-notch teamwork and collaboration with clients, partners, and peers
• Excellent communication skills, including active listening
• The ability to explain a complex analysis or data insight to a non-technical stakeholder
• An understanding of nonprofit fundraising and the data behind it
• A cool head under pressure in a busy, agency environment
• An ability to bring positivity and a lens of inclusivity to all interactions with colleagues

Why you will love Avalon Consulting…

Since 1997, Avalon has been committed to making the world a better place by helping our clients raise the millions of dollars needed to fulfill their inspiring missions. We’ve created a culture unlike any other agency. We are proud to be a fully remote workplace- hiring the best fundraisers and analysts in the business, no matter where they live in the US. We also love getting together for team and client meetings when necessary. We're strategic, analytical, innovative, collaborative, compassionate, and most of all: passionate about our work. We love what we do, and it shows in our engaged teams, industry awards, and delighted clients.

While you will be working directly with the most delightful group of nerds around, on the Analytics team, you will also be embedded in a culture that embraces data. Analytics is a cornerstone of the work we do. We created our reports to fill a gap in the industry, and are always enhancing our deliverables to make sure we are answering the most pressing questions at the moment and foreseeing questions that might be asked in the future.

Avalon is proud of our supportive and collaborative team environment that encourages professional development while recognizing the importance of flexibility and work-life balance. We are committed to fostering a culture that embraces differences every day, and where each of our staff is supported and inspired to reach their full potential.

Besides being a great place to work, we are pleased to offer a rich, comprehensive benefit plan, including employer-paid health, dental, and vision insurance, generous paid leave, employer-paid life and disability insurance, and a safe harbor 401(k) plan.

The salary range for this position is $70,000-$80,000 annually, commensurate with experience.

If this sounds like an opportunity that you’re excited to pursue, we would love to hear from you! For consideration, please apply using the provided link by submitting your resume and a cover letter.

Avalon Consulting is committed to fostering a workplace focused on belonging where everyone—regardless of their background—feels valued and empowered. We are proud to be an equal opportunity employer and do not discriminate based on race, color, religion, sex, national origin, age, disability, genetic information, marital status, sexual orientation, gender identity or expression, veteran status, or any other legally protected characteristic.