Sr. Associate Director Data Insights

Philadelphia, PA, US, 19104

​Location: LOC_HOME-Home/Remote Office Location 

Req ID: 230911

Shift: Days

Employment Status: Regular - Full Time 

This role is eligible for a hybrid work option!

Seeking Breakthrough Makers   

Children’s Hospital of Philadelphia (CHOP)—named America’s 2022 Best Large Employer by Forbes—offers countless ways to change lives. Our diverse community of more than 20,000 Breakthrough Makers will inspire you to pursue passions, develop expertise, and drive innovation.

At CHOP, your experience is valued; your voice is heard; and your contributions make a difference for patients and families. Join us as we build on our promise to advance pediatric care—and your career. 


CHOP’s Commitment to Diversity, Equity, and Inclusion 

CHOP is committed to building an inclusive culture where employees feel a sense of belonging, connection, and community within their workplace. We are a team dedicated to fostering an environment that allows for all to be their authentic selves. We are focused on attracting, cultivating, and retaining diverse talent who can help us deliver on our mission to be a world leader in the advancement of healthcare for children. 

We strongly encourage all candidates of diverse backgrounds and lived experiences to apply. 

Job Summary

Reporting to the Director of Data Services and Business Analytics, the Foundation’s Sr. Associate Director of Data Insights works closely with key stakeholders in Development, Finance, Information Systems, and other areas to manage the department’s reporting and analytic fulfillment & quality for the Foundation. This position serves as liaison to the Information Systems department for specific initiatives and tasks. 

The Associate Director incumbent oversees the day-to-day operations of the data warehouse, fundraising analytics and reporting solutions. The incumbent will continually evaluate and identify new opportunities in informatics, technology, and Business Intelligence (BI)/data warehousing. They will also participate in the selection and implementation of new technologies.

They will work closely with Development staff on data and reporting projects, and with peers on enhancements to business processes and technical solutions.

Job Responsibilities

Oversee Data Warehouse, Fundraising Analytics and Reporting Solutions and Fulfillment

  • Using non-profit or other business experience, direct the data warehouse and BI development initiatives
  • Oversee and manage operational reporting and ad-hoc list fulfillment
    • Collaborate to prioritize customer needs, allocate resources, and ensure analytic utilization within the department’s teams
    • Ensure accurate, formatted information for immediate operational use at all departmental levels
    • Review daily/weekly/monthly/yearly reports
    • Ensure that data in Fundraising DW is correct and reports meet departmental needs
  • Oversee the development and maintenance of a catalog of strategic reports for the Foundation

Job Responsibilities (Continued)

  • Oversee and manage Information Analysis
    • Ensure integrity of all subsequent manipulation and analysis
    • Supervise and perform data analysis including but not limited to: correlation, impact, distribution, trending and projection
    • Oversee, manage, create, deploy, and maintain BI solutions
  • Manage the development and maintenance of a data warehouse and trusted reporting data marts/blocks
    • Manage key data resources
    • Supervise the maintenance of tables, views, indexes, functions, stored procedures, and SQL packages
    • Follow Data Warehouse Design Principles (Kimball)
  • Prepare supporting business and technical documentation and specifications
  • Serve as lead on use of all reporting tools

Job Responsibilities (Continued)

Supervise Staff

  • Lead a team and provide technical direction to team of 2 analysts/report writers
  • Supervise problem management, client relations, and resource management
  • Supervise staff in reporting quality and maintenance
  • Prioritize requests in queue
  • Institute training on reporting and other analytic tools


Support Projects for New Technologies

  • Work closely with Director of Development Platforms and Systems to:
    • Create proof of concept to test new technologies, as it relates to reporting and analytics
    • Implement new data story telling technology as best suited for Development Department

Required Education and Experience

Required Education:

  • Bachelors Degree

Required Experience:

  • At least five (5) years of Business Intelligence/Business Analytics experience

Preferred Education, Experience & Cert/Lic

Preferred Education:

  • Master's Degree

Preferred Experience:

  • At least five (5) years of Data Warehousing experience

Additional Technical Requirements

  • Query Tools:  Use of SQL Server Business Intelligence Tools (Reporting Services and Analysis Services), plus other analytical and data visualization tools 
  • Data Mining & Statistics:  Familiarity with data mining tools and technologies and/or statistical packages such as SPSS or SAS; knowledge of basic statistical concepts and techniques
  • Server and Database Skills:  Knowledge of Application Databases, Relational Databases, Report Servers, and SQL Knowledge/Experience – particularly with the MS SQL Server platform (SQL 2008/2012); Writing queries and SQL; Writing Stored Procedures and Functions in SQL
  • Programming:  Familiarity with VBA programming environment and logic helpful
  • Data Extraction, Transformation and Loading (ETL):  Data Movement Experience (Extract, Transform & Load) – i.e., from transactional application data to a Data Warehouse; Using Microsoft Data Transformation Services (DTS) and/or SQL Server Integration Services (SSIS)
  • Data Warehousing:  Using Data Warehousing design techniques such as dimensional schemas, dimensions/facts, methods such as Kimble Toolkits; Knowledge of different loading techniques such as incremental vs full refresh, dimensional changes, snapshots, and historical archiving
  • Financial experience would be helpful


Other Skills:

  • A sincere appreciation for people and how they are each uniquely motivated.
  • Poised and engaging, empathetic communications style based on natural warmth and enthusiasm.
  • Fast paced and results oriented with the ability to work in a timely manner with multiple deadlines and competing requirements.
  • Strong written, presentation, verbal, organizational, and interpersonal skills; demonstrated ability to relate well to individuals from diverse backgrounds.
  • Demonstration of good judgement, professionalism, and the highest standards of ethical conduct.


Additional Technical Requirements(continued)

Additional Technical Requirements(continued)


  • Knowledge of non-profit business and processes
  • Analytical and problem-solving abilities
  • Supervisory experience of a technical team
  • Comfortable with numbers and logic
  • Experience working with project teams and to deadlines
  • Documentation and report writing skills
  • Presentation and communication skills 
  • Must be comfortable moving between the worlds of technology and fundraising, and able to communicate with staff in both

To carry out its mission, CHOP is committed to supporting the health of our patients, families, workforce, and global community.  As a condition of employment, professionals working onsite—at any CHOP location, for any portion of time—must be vaccinated for COVID-19. Learn more. 

CHOP also requires employees who work in patient care buildings to receive an annual influenza vaccine. Employees may request exemptions for valid religious and medical reasons.  Start dates may be delayed until candidates are immunized or exemption requests are reviewed.  

EEO / VEVRAA Federal Contractor        |              Tobacco Statement 


Nearest Major Market: Philadelphia

Job Segment: Data Warehouse, Business Intelligence, Data Mining, Database, SQL, Technology