Analyst, Database Insight

Combined Jewish Philanthropies - Boston, MA4.5

Full-timeEstimated: $54,000 - $75,000 a year
EducationSkills
Passion. Purpose. Impact. CJP is at the heart of Greater Boston's Jewish community, but our reach is felt around the world. We bring together the resources, volunteers, leadership, and expertise to care for people in need, advocate for Israel, and ensure a vibrant Jewish future. Together, we're helping struggling families find financial stability, making Jewish learning relevant and inclusive, connecting the next generation to Jewish life, and so much more. Our greatest resource is our people — the staff, volunteers, partners and leaders who help make Greater Boston’s Jewish community a welcoming home. It’s this energy and commitment that drive CJP’s mission. We are one of Boston's oldest and most respected philanthropic organizations and we are currently seeking an Analyst, Database Insight.

The Analyst, Database Insight will have responsibility for development and maintenance of CJP reports, queries, and data visualization, as well as provide database and End User support and customer service to internal clients. This person will assist the system user community by fulfilling requests, extracting information, providing specialized training, and serving as a key organizational resource for CJP’s Constituent Relationship Management system (Blackbaud CRM, known internally as Maven).

He/She will develop and maintain the portfolio of strategic, reusable reports using the CRM’s built-in query tools, advanced Excel tools, and business intelligence/data visualization tools including Microsoft Power BI. Additionally, this person will develop custom reports as needed by Senior Team and the Board using descriptive analytics.

ESSENTIAL FUNCTIONS:
Database/End User support:
Maintain administrator-level expertise on Maven
Fulfill a wide range of user requests for database extracts and support by collaboratively strategizing with our end user community to understand the desired outcomes and business needs
Understand and perform key database functions and serve as an approachable resident expert for the user community
Build well-designed, sustainable queries and reports in Maven using SQL-like tools
Provide user support and training for database functionality to multiple departments throughout the organization

Business Intelligence:
Collect report requirements, recommend parameters, and strategize with partners across the organization to build scalable, intuitive, flexible, and sustainable information tools with strong visual components
Use SQL-like front-line query tools, Excel, Power BI, and similar tools to fulfill varied analytical needs
Maintain, improve, and support ongoing organizational dashboards and reporting updates
Work with large data sets and develop testing methods to ensure accuracy
Perform extracts and analysis of fundraising, financial, engagement, and community activity to support identification of significant trends
Work with Data Strategy & Insight team and key stakeholders to identify strategic opportunities for business process improvements and advanced analysis
Provide assistance on special projects, including automation of key functionality and custom report requests
Other duties as assigned with or without accommodation

Education:
Bachelor’s degree or equivalent required.

Experience:
2-4 years’ experience working in a fundraising, analytics, or similar environment, proven ability in working with and querying from a complex CRM system, and a background or experience with analytical reporting and data visualization
Experience with Blackbaud eCRM, Blackbaud Raiser’s Edge, Salesforce, or other advanced CRM or fundraising databases is highly desirable. Advanced knowledge of Excel is required; Microsoft Power BI experience highly desirable

Skills/Competencies:
Ability to demonstrate caring, creativity, insight, flexibility, and strong collaboration skills in building partnerships across the organization
Strong analytical skills, with an emphasis on effectively visualizing data.
Attention to detail
Excellent interpersonal and communication skills
Ability to work both independently and collaboratively in a dynamic environment
Experienced with a complex fundraising, donor, or CRM systems at a ‘Super User’ or “Administrator” level
Expert skills in MS Excel with experience using data models and Power Pivot highly desired
Maturity, flexibility and the ability to focus on detail while handling multiple tasks and working with diverse personalities
Ability to manage confidential information sensitively and appropriately
Ability to be flexible and adaptable to changes and shifting priorities

Other:
Ability to work additional time during periods of peak demand and time critical projects