Data Services Analyst

Position Summary: Candid is a nonprofit that provides the most comprehensive data and insights about the social sector. We get you the information you need to do good. Candid currently has an opportunity for a Data Services Analyst. The Data Services Analyst will work with a team of data experts to deliver valuable data services, insights, and reporting about the social sector to a wide range of external and internal stakeholders every day. This client facing and technical role will help shape the way we deliver data services products to clients.

Position: Data Services Analyst

Reporting to: Senior Data Services Manager

Supervises: N/A

Schedule: 35-hour work week, Monday through Friday

Compensation: $45,000 - $73,000 (this range is for the NYC area and will be adjusted for other localities; additionally, factors like skills and experience will be considered).

Location: Remote. In-person attendance is expected twice per year during our annual, weeklong all-staff summits. Additional in-person meeting participation is expected at least once per quarter for senior leaders and at least once per month for the executive team. Staff not located in the NYC area are expected to travel for these meetings. 

Benefits: Health insurance (medical, dental, vision), retirement contribution with additional option for a match, paid life insurance and AD&D, paid leave time (PTO, compassionate leave, volunteer, holiday, parental), short-term and long-term disability, pre-tax transit, flexible spending accounts, supplemental insurance, summer hours, and Public Service Loan Forgiveness (PSLF) program eligible employer.

Responsibilities  

• Deliver custom data sets to customers - working with the sales team to scope client needs, consulting on the generation of sales estimates, client communication, design, documentation and delivery of the custom data extracts, and post-delivery client support
• Build and maintain high-quality reporting and analysis solutions to provide the best possible data solutions to our customers
• Participate in daily Data Services stand up meetings
• Increase organizational efficiencies through the design and implementation of automated processes wherever possible
• Design, build and maintain technical frameworks for our team – enabling us to develop and deliver consistent, high-quality data sets quickly
• Design, build and maintain visualization dashboards for stakeholders to better understand our data
• Accountable for building and maintaining Data Services product offerings
• Document and share developed code for peer review and also, peer review other team members work
• Partner and collaborate with internal teams on cross departmental projects
• Ensure data consistency between Candid's subscription tools and reporting database
• Taking on special projects as assigned

As a member of Candid’s Data Services team, you will: 

• See data as fun and interesting and 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
• Have a strong aptitude for learning new techniques for analysis and visualization of data
• Enjoy working with a wide variety of stakeholders – to understand their needs and consult with them on the ways our data can help meet those needs 
• Bring 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

Requirements  

• Detail-oriented yet “big picture” in approach to assignments.
• Experience in gathering requirements from stakeholders and provide data solutions that meet those needs
• Ability to analyze and synthesize large quantities of data into digestible and actionable packages for stakeholders
• Ability to apply various mathematical calculations and statistical techniques to datasets
• Proficient writing moderate to complex SQL working against large relational databases
• Experience in using SQL Server Tools such as SQL Integration Services, Reporting Services, Management Studio to build, maintain and execute large, repeated data extracts a plus
• Demonstrated ability to write Python, C#, and related languages a plus
• Experience with data visualization tools such as PowerBI and Tableau a plus
• Experience with machine learning or natural language processing a plus
• Experience with Azure DevOps for source and version control a plus
• Experience with Snowflake and AWS for cloud computing a plus
• Strong