Data Reporting Analyst

Job Type

Full Time




4801 Courthouse Street
Suite 220
United States


The GuideStar Data Services Team has a critical role to play at GuideStar. Leveraging over 20 years of nonprofit data this team provides a continuous stream of valuable data services and insights about the sector to a wide range of external and internal stakeholders every day. 

As a member of GuideStar's Data Services Team you will:

  • See data as fun and interesting and you bring a spirit of inquiry to your work each day
  • Enjoy being a member of a collaborative team that works together to achieve shared goals
  • Bring expertise in building and maintaining high-quality reporting and analysis solutions to provide the best possible data solutions to our customers
  • Have high standards and a process improvement mind-set to your work and to the team - helping us to develop more efficient, effective and value-add solutions every day
  • Be comfortable and confident engaging with customers to understand their needs and consult with them on the ways our data can help meet those needs  

Specific Duties of this role include:

  • Designing, building and maintaining reporting framework for our team – enabling us to develop and deliver consistent, high-quality data sets quickly.
  • Leading technical efforts with the Data Services team to increase organizational efficiencies through the design, implementation and use of standards and automated processes wherever possible.
  • Maintaining and managing the backlog of data improvement opportunities needed to advance our program and offerings
  • Delivering Custom Datasets - working with the sales team to scope client needs, assist in the generation of sales estimates, client communication, design, documentation and delivery of the custom data extracts, and post-delivery client support
  • Serving as a subject matter expert for data related questions from clients and internal stakeholders.

  • Partner with Director in development and assessment of new data product ideas.
  • Taking on special Data Analysis/Research projects as assigned.

Skills/Experience/Aptitude we are looking for:


  • Demonstrated ability to write moderate to complex SQL working against large relational databases – Transact SQL experience preferred
  • Proficiency with Microsoft and BI Technologies – such as Excel PowerPivot, PowerBI, SQL Server Integration Services, and SQL Reporting Services tools or other like tools
  • Experience building reporting data models
  • Demonstrated ability to establish and to follow technical standards
  • Experience helping a team to develop automated processes to enhance efficiency and consistency of work products
  • Ability to manipulate, package, visualize, present and deliver information to different audiences at an intermediate level using Excel, PowerBI, and PowerPoint
  • Exposure to R, Python and related languages is a plus



  • Ability to quickly become versed in the definitions and meaning of the data we are working with
  • Experience in receiving and interpreting requests for and questions about data and the ability to think through how to leverage the data at hand to meet the stakeholder need
  • Ability to apply various mathematical calculations and statistical techniques to datasets
  • Ability to analyze and synthesize large quantities of data into digestible and actionable packages
  • Ability to draft recommendations and lead efforts to address internal technical improvement opportunities for the team

Communication, Collaboration, and Customer orientation:

  • Strong listener - able to take in and understand and respond to the needs of a wide variety of stakeholders with differing levels of technical and/or non-profit knowledge
  • Able to 'translate' business needs to more technically oriented teammates and convey more technical information in business-friendly terms to non-technical stakeholders
  • Professional and polished in communications of all types
  • Comfortable reaching out to solve problems and enjoys working cross-team
  • Partners with the sales team to deliver a high level of customer satisfaction
  • Brings a sense of urgency to customer engagements

Subject Matter Expertise:

  • Knowledge of Non-profit Data or the non-profit sector is a big plus


  • Bachelor’s degree in technical subject, business, economics, math, accounting, or similar subjects with demonstrated successful completion of quantitative and database related courses or equivalent work experience
  • Minimum of 3 years experience
  • Certifications in Excel PowerPivot, SQL, SSIS or common BI tools would be preferred


  • Preferred location is Williamsburg but will consider other locations for the right candidate

GuideStar USA Inc. is EEO/AA/VET/DISABLED Employer.


If you care about nonprofits and the work they do and have relevant skills and experience, please consider applying even if your background doesn’t perfectly match our ideal credentials. We are committed to diversity and especially encourage members of underrepresented communities to apply”.



Five Reasons You’ll Love Working at GuideStar:

  1. Culture – We have a fun, open, engaged culture
  2. Continuous Learning – We are experienced professionals who want to mentor, so you’ll learn from some of the best
  3. Forty-eight hours/year to volunteer – Your choice for how you want to make an impact
  4. New technologies – we’re constantly looking at new technologies and ways to engage internally and externally-so you will keep your skills up-to-date and will continue to grow
  5. A competitive benefits package

Professional Level

None specified

Minimum Education Required

4-year degree

How To Apply

Please email cover letter and resume.