Business Intelligence Analyst

Great Futures Start Here

The mission of Boys & Girls Clubs of Central (BGCCO) is to enable young people to reach their full potential. We unlock brighter futures through safe spaces, strong relationships, and impactful experiences. Our vision is for all young people regardless of their zip code or circumstances to have the opportunity to achieve a great future.

Boys & Girls Clubs of Central Ohio, an Affiliate of Boys & Girls Clubs of America, empowers the young people who need us most to reach their full potential as productive, caring, and responsible citizens by providing high-quality and impactful out-of-school time programming for youth in grades K-12. BGCCO serves 4,000 youth per year throughout Central Ohio.

Boys & Girls Clubs of Central Ohio operate Clubs in Columbus, Newark, and Marion. https://www.bgccentralohio.org/

Position Summary

The Business Intelligence Analyst is responsible for collecting, validating, analyzing, and reporting organizational data that supports informed decision-making across Boys & Girls Clubs of Central Ohio. Serving as the organization's primary reporting and analytics resource, this role helps maintain a reliable “single source of truth” by ensuring data integrity, consistency, and accessibility across operational, programmatic, financial, and development reporting.

Reporting to the Chief Financial & Administrative Officer, this position partners with Finance, Development, Programs, Operations, and Executive Leadership to develop dashboards, automate reporting, identify trends, and improve organizational visibility into key performance indicators.

Primary Responsibilities

Business Intelligence & Reporting

Develop, maintain, and enhance dashboards and reports using Power BI, Excel, and other reporting tools.
Produce recurring operational, financial, programmatic, and fundraising reports for organizational leaders.
Respond to ad hoc reporting requests and provide timely analysis to support decision-making.
Translate data into clear visualizations and summaries that are easily understood by non-technical audiences.

Data Quality & Governance

Maintain the organization's reporting standards and support a consistent “single source of truth” across enterprise data.
Monitor data quality, identify discrepancies, and work with departments to improve data accuracy and completeness.
Document reporting definitions, KPI calculations, and data standards to promote consistency across the organization.
Assist with data validation and reconciliation across systems.

Operational Analytics

Develop dashboards tracking key operational metrics, including membership, attendance, staffing, finance, program participation, and facility utilization.
Monitor trends and provide routine analysis highlighting opportunities, risks, and emerging patterns.
Support leadership by preparing monthly and quarterly performance reports.

Development Analytics

Produce fundraising dashboards tracking campaign performance, donor activity, grant reporting, donor retention, and giving trends.
Support prospect management through portfolio reporting and donor segmentation lists.
Assist the Development team by maintaining accurate fundraising performance reports and campaign analytics.

Systems & Reporting Support

Partner with system owners to ensure reporting data is accurate and complete across finance, development, HR, and program management systems.
Assist with report development following system implementations or enhancements.
Recommend process improvements that increase reporting efficiency and reduce manual effort.

Cross-Functional Collaboration

Work collaboratively with departments to understand reporting needs and develop practical reporting solutions.
Train staff on available dashboards and reporting tools.
Support organization-wide initiatives through data collection, analysis, and reporting.

Required Qualifications

Bachelor's degree in Business Analytics, Information Systems, Finance, Statistics, Business Administration, or related field.
Two to five years of experience in business intelligence, reporting, analytics, or data management.
Experience developing dashboards using Power BI or similar business intelligence tools.
Advanced proficiency with Microsoft Excel.
Experience working with data from multiple systems.
Strong analytical, organizational, and communication skills.

Preferred Qualifications

Experience in a nonprofit, education, healthcare, or mission-driven organization.
Familiarity with donor CRM systems and fundraising reporting.
Experience with SQL or database querying.
Knowledge of financial and operational reporting.

Key Competencies

Data Analysis
Business Intelligence
Dashboard Development
Data Integrity
Attention to Detail
Critical Thinking
Collaboration
Problem Solving
Communication
Continuous Improvement

Success Measures

Within the first 12 months, this individual will:

Maintain reliable executive dashboards that serve as the organization's primary reporting resource.
Improve consistency and accuracy of organizational reporting.
Establish standardized reporting definitions supporting a trusted single source of truth.
Reduce manual reporting through automation and dashboard enhancements.
Deliver timely operational and fundraising reports that support leadership decisions.
Strengthen organizational confidence in the quality and accessibility of enterprise data.

Disclaimer

This job description is intended to describe the general nature and level of work performed by individuals assigned to this role. It is not intended to be an exhaustive list of all responsibilities, duties, or skills required, nor does it limit the right of management to assign or reassign work as needed.

Equal Employment Opportunity

Boys & Girls Clubs of Central Ohio is an equal opportunity employer. Employment decisions are based on merit, qualifications, and abilities. Boys & Girls Clubs of Central Ohio does not discriminate based on race, color, religion, sex, sexual orientation, gender identity, age, marital status, national origin, physical or mental ability, status as a disabled veteran or any other classification protected by law.

Civil Rights

In accordance with federal civil rights law and U.S. Department of Agriculture (USDA) civil rights regulations and policies, this institution is prohibited from discriminating on the basis of race, color, national origin, sex (including gender identity and sexual orientation), disability, age, or reprisal or retaliation for prior civil rights activity.

Monday - Friday 8:00 AM - 5:00 PM

Learn more about this Employer on their Career Site