Data and Strategy Analyst

Reporting to the Strategy Lead, the Data and Strategy Analyst will support the data analysis, management, and training for Crown Family Philanthropies’ (CFP) strategic priority areas with a special focus on key initiatives.

Key Areas of Responsibility

Data Analysis and Strategy:

• Conduct robust data analyses to identify program/process improvement opportunities and evaluate the impact of key strategic initiatives such as the Tuition Accessibility Partnership Fund and Chi-Rise 
• Communicate clear recommendations for improvements, decision-points, and on areas for deeper exploration based on analyses
• Provide guidance and support to Program Teams in developing robust Data Dashboards to inform their grantmaking strategies, including the collection, aggregation and analysis of data from a range of data sources
• Review and provide feedback on external evaluations of initiatives funded by the Foundation, including both qualitative and quantitative analyses
• Create visualizations for data analyses and insights
• Proactively address potential roadblocks or complications as decisions are discussed and provide alternative solutions to improve efficiency 

Data Management:

• Support data management for all Program Teams, both in Excel and Salesforce, including data input, data cleaning, and report generation
• Clean and consolidate data from a variety of data sources, including identifying and resolving inconsistencies and duplications
• Work with external partners to collect data reports and ensure consistency, including documentation of all data sources 

Training:

• Develop data best practices and establish protocols to audit for consistency across staff members and teams
• Document Salesforce and other processes to help build out training materials
• Prepare and facilitate timely staff trainings in collaboration with other departments including providing training to newly onboarded staff
• Provide opportunities for staff to ask questions and seek guidance as needed on data practices

Cross-Department Coordination and Engagement:

• Coordinate with CFP team across Program Areas, operations, and family engagement to ensure cross-functional communication and consistency
• Play an advisory and collaborative role within the Analyst team, providing guidance or mentorship to CFP colleagues on data and evaluation issues related to the non-profit and/or philanthropic sectors`
• Participate in cross-functional teams that advance organizational aims around social impact and family engagement
• Engage in initiatives that foster team collaboration, including meetings, trainings, retreats, and special projects, taking the lead where interest, expertise, and opportunity coalesce

 Education/Experience

• Bachelor's degree or commensurate experience; master’s degree in relevant field is a plus
• At least three years of experience in strategic analysis, management consulting, or program evaluation
• Experience in or familiarity with the nonprofit sector (including board service or volunteer work) is a plus

Core Competencies (Skills and Abilities)

• Exceptional analytical skills – comfort with cleaning, organizing, and analyzing a range of data sets and translate those analyses to insights
• Willingness to learn about a variety of program areas and explore a range of data sources
• Comfort with ambiguity and working through limited data accessibility 
• Superb organizational skills including ability to prioritize agendas and manage conflicting needs; ability to respond flexibly to shifting priorities 
• Meticulous attention to detail, particularly when tackling administrative tasks and data entry
• Ability to problem solve independently and in groups 
• Capacity for peer mentorship and training
• Willingness to take initiative and bring new concepts to the team
• Ability to think and implement at both strategic and tactical levels
• Intermediate-advanced Microsoft Excel (ex: SUMIF formulas, pivot tables, VLOOKUPs etc.)
• Experience working with large data sets and CRMs (Salesforce is a plus) 
• Experience with data visualization tools such as Tableau is a plus

Additional Information 

Henry Crown and Company and the Crown Family Philanthropies division are committed to creating a diverse environment and proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. 

Don’t meet every single requirement? Studies have shown that women, members of the LGBTQIA+ community, individuals experiencing disability and BIPOC are less likely to apply to jobs unless they meet every single qualification. At HCC we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

Hybrid Work Environment

Henry Crown and Company and CFP currently operate in a hybrid work environment, with staff expected to work in the downtown Chicago office a minimum of two days per week. 

About Crown Family Philanthropies 

Crown Family Philanthropies (“CFP” or the “Foundation”) is the philanthropic division of Henry Crown and Company (see below) and supports the Crown Family’s philanthropic and grantmaking endeavors. In 2009, after more than 60 years of family grantmaking under the name Arie and Ida Crown Memorial, CFP was developed to represent and facilitate an array of family grantmaking practices. Today the legacy of Arie and Ida Crown lives on in the work continued by their descendants, who remain dedicated to the Jewish tradition of tikkun olam, or “repairing the world.” Supported by a professional staff, CFP is led by more than 50 family members across multiple generations who come together to set strategy and make grantmaking decisions.

About Henry Crown and Company 

Henry Crown and Company is a Chicago-based, privately-held operation [not a 501(c)(3) nonprofit organization] that manages business interests and coordinates investments falling into four broadly-defined categories: publicly-traded securities, real estate, investment funds, and privately held operating companies. The corporate office employs approximately 200 professionals in the areas of investment management, corporate development, accounting, tax, human resources, information technologies, legal, family services, philanthropy, and administration.