Application Guide

How to Apply for Analyst / Sr. Analyst

at Public Equity Group

🏢 About Public Equity Group

Public Equity Group (PEG) is a unique network of strategy and management consultants dedicated to driving social impact across diverse sectors like education, housing, and civil rights. By partnering with a wide range of regional and national organizations, PEG offers a collaborative environment where you can work on projects that genuinely matter. Their commitment to diversity and inclusion, especially encouraging applicants with lived experience in systems affecting disadvantaged communities, sets them apart as an employer that values both expertise and empathy.

About This Role

As an Analyst at PEG, you'll gain hands-on experience in non-profit strategy and management consulting, working remotely with a professional network. Your primary focus will be on synthesizing data from sources like the US Census to support client projects, requiring strong Excel skills. This role is an exceptional learning opportunity for recent graduates to apply analytical skills to real-world social impact challenges while receiving mentorship from seasoned professionals.

💡 A Day in the Life

A typical day might start with a virtual check-in with your project team to discuss tasks and deadlines. You'll spend a significant portion of your day in Excel, cleaning and analyzing data from government sources, and then create summaries or visualizations to share with senior consultants. You might also attend a webinar or meeting with a client to understand their needs, and end the day by documenting your findings and updating project trackers.

🚀 Application Tools

Generate Cover Letter

AI-powered, tailored for Public Equity Group

Interview Prep

Practice questions for this role

🎯 Who Public Equity Group Is Looking For

  • A recent undergraduate with strong analytical skills and proficiency in Microsoft Excel for data manipulation and synthesis.
  • Someone with a passion for social impact and ideally with professional or lived experience in systems like the US justice system, immigration, child welfare, or affordable housing.
  • A self-starter who thrives in a remote work environment and can manage multiple tasks independently while collaborating with a diverse team.
  • An excellent communicator who can synthesize complex data into clear insights for clients and team members.

📝 Tips for Applying to Public Equity Group

1

Highlight specific Excel skills, such as using VLOOKUP, pivot tables, or data cleaning, and provide examples of projects where you used these skills.

2

Emphasize any experience or coursework related to social impact, non-profits, or public policy, and connect it to PEG's mission.

3

In your cover letter, explicitly mention any lived or professional experience with the systems listed (justice, immigration, child welfare, etc.) if applicable, as PEG encourages this.

4

Tailor your resume to showcase data analysis projects, even if they are from academic or volunteer settings, and quantify your impact where possible.

5

Research PEG's client sectors and mention specific areas of interest in your application to demonstrate genuine alignment with their work.

✉️ What to Emphasize in Your Cover Letter

['Express your passion for using data to drive social change and how this role aligns with your career goals.', "Highlight your Excel proficiency and provide a specific example of how you've used data to inform decisions or solve a problem.", 'Mention your interest in learning from experienced consultants and contributing to diverse projects across sectors.', 'If applicable, share your personal or professional connection to the communities PEG serves, showing your commitment to their mission.']

Generate Cover Letter →

🔍 Research Before Applying

To stand out, make sure you've researched:

  • → Explore PEG's website to understand their mission, values, and the types of clients they serve (e.g., education, housing, climate).
  • → Look up recent projects or case studies that PEG has published to see the kind of work you'd be involved in.
  • → Research the specific challenges in the non-profit sectors PEG focuses on, such as how data is used in program evaluation or grant reporting.
  • → Check if any PEG team members are on LinkedIn and read their profiles to gain insights into the company culture and career paths.
Visit Public Equity Group's Website →

💬 Prepare for These Interview Topics

Based on this role, you may be asked about:

1 Behavioral questions about how you've handled data-heavy tasks in the past, such as cleaning messy datasets or meeting tight deadlines.
2 Technical questions about Excel, like how you would perform a VLOOKUP or create a pivot table to summarize data.
3 Questions about your motivation for working in non-profit consulting and what you know about PEG's client sectors.
4 Scenarios where you have to synthesize data from multiple sources (e.g., Census data) to tell a compelling story.
5 Questions about your experience working remotely and how you stay productive and communicate effectively with a distributed team.
Practice Interview Questions →

⚠️ Common Mistakes to Avoid

  • Don't submit a generic cover letter that doesn't mention PEG or its specific focus on social impact and diverse systems.
  • Avoid downplaying your Excel skills; instead, be honest about your proficiency and show willingness to learn if you lack advanced skills.
  • Don't ignore the remote aspect – failing to address how you work independently or manage time in a remote setting can be a red flag.

📅 Application Timeline

This position is open until filled. However, we recommend applying as soon as possible as roles at mission-driven organizations tend to fill quickly.

Typical hiring timeline:

1

Application Review

1-2 weeks

2

Initial Screening

Phone call or written assessment

3

Interviews

1-2 rounds, usually virtual

✓

Offer

Congratulations!

Ready to Apply?

Good luck with your application to Public Equity Group!

← Back to Job Listing Apply Now →