Development BI Analyst: Donor Analytics & Dashboards

The Children's Museum of Indianapolis; Indianapolis (IN); On-site; USD 70,000 - 110,000; Full time

Job summary

The Children’s Museum of Indianapolis is seeking a Development Business Analyst to partner with the Advancement team, design and maintain dashboards, and transform CRM and enterprise data into actionable insights for planning and decision-making.

The role focuses on predictive analytics, machine learning models, and scalable analytics solutions while ensuring data governance and documentation across museum systems.

Qualifications

• Bachelor’s degree preferred or equivalent work experience.
• Three years of experience in business intelligence, reporting, data analysis, analytics, or a related field. Experience with nonprofit fundraising or membership data is preferred.
• Strong SQL skills and experience working with relational databases; experience with data warehouses and integrated enterprise data is preferred.
• Demonstrated ability designing and building dashboards and reports using Power BI, Tableau, or similar tools, including data modeling, metric definition, visualization, and quality assurance.
• Experience with Python, R, or similar analytical tools and practical experience building, validating, or maintaining predictive analytics or machine learning models.
• Experience with CRM systems and a working knowledge of fundraising, membership, marketing, or constituent data. Experience with Tessitura or another nonprofit-specific CRM is preferred.
• Strong analytical and problem-solving skills, with the ability to translate business questions into technical requirements and explain results, assumptions, and limitations to non-technical audiences.
• Demonstrated ability to use generative AI and large language model (LLM) tools effectively and responsibly to support analytics, coding, research, documentation, and other work processes, with appropriate attention to data privacy, accuracy, validation, and organizational policies.
• Proven commitment to data quality, documentation, governance, privacy, and responsible handling of highly sensitive confidential information.
• Ability to work collaboratively with diverse individuals across the museum and community, manage multiple priorities, and work independently while knowing when to seek additional information or guidance.
• Strong proficiency with Excel and standard Microsoft Office applications; experience with version control, APIs, ETL/data integration, or other modern data tools is a plus.

Responsibilities

• Designs, builds, maintains, and enhances reports, dashboards, and self-service analytics for Advancement and other museum departments using CRM, data warehouse, and related enterprise data sources.
• Translates business questions into analytical requirements, measures, data definitions, and technical solutions; develops ad-hoc queries and analyses to answer complex operational and strategic questions.
• Develops, validates, and maintains predictive analytics and machine learning models for use cases such as donor propensity, segmentation, retention, upgrades, campaign response, forecasting, and other museum priorities.
• Builds projections, forecasts, and scenario analyses using historical and current data, and partners with Advancement leaders and analytics staff to ensure outputs are understood and usable for planning and decision-making.
• Develops working knowledge and assists with integration between Development and Finance systems to ensure records are reconciled accurately.
• Performs quality assurance on analytical products, investigates anomalies and data issues, and maintains documentation for business logic, calculations, data definitions, model assumptions, and reporting processes.
• Collaborates with IIT, the Data team, and museum departments to incorporate data from CRM, finance, web, marketing, retail, and other platforms into integrated reporting and analytics solutions.
• Serves as an active member of the Data and CRM governance teams, helping establish and maintain shared definitions, data standards, documentation, access practices, and policies that support trusted museum-wide reporting.
• Partners with CRM stakeholders to improve data capture and business processes that affect reporting and analytics, and provides technical guidance and training on the effective use of analytical tools.
• Maintains strong working relationships with colleagues in advancement and other stakeholders, prioritizes analytical requests in coordination with the Data team, and communicates technical findings, limitations, and recommendations clearly to technical and non-technical audiences.

Skills

Analytical thinking

Communication

Collaboration

Generative AI proficiency

Education

Bachelor’s degree or equivalent

Tools

Power BI

Tableau

Excel

Python

R

Tessitura

SQL

Job description

The Children’s Museum of Indianapolis is seeking a Development Business Analyst to partner with the Advancement team, design and maintain dashboards, and transform CRM and enterprise data into actionable insights for planning and decision-making.

The role focuses on predictive analytics, machine learning models, and scalable analytics solutions while ensuring data governance and documentation across museum systems.