Senior Business Data Analyst

Job ID: 298049
Location: Kennesaw, Georgia
Full/Part Time: Full Time
Regular/Temporary: Regular

Department Specific Tasks and Responsibilities

1. Develops queries, exports, reports and data deliverables using Blackbaud RENXT or current CRM, Power BI, MS Access, SQL, and MS Office tools
2. Assist with data integrity across all advancement and affiliated systems, including Raiser's Edge NXT, Fundraiser Performance Manager, Salesforce Marketing Cloud, Give Smart, Give Campus and other software programs or spreadsheets
3. Analyze and transform data to conform in order to run global uploads of data to our donor and alumni database from other software programs or spreadsheets
4. Provides administrative maintenance and support for online giving pages, online transactions, and crowdfunding solutions
5. Assists in the development of dashboards, analytics, reports, and visualizations to provide actionable insights on fundraising progress, forecasting, alumni engagement success, and respective analyses related to these areas (using Power BI, Power Query, Power Pivot and Data Analysis Expressions (DAX))
6. Serves as the primary back up for gift entry processing, batch posting, producing acknowledgements and receipts

Department Specific Knowledge, Skills, and Abilities

• Experience with business intelligence and analysis tools such as Power BI, Power Query, and DAX
• Strong understanding of industry terms, definitions, and information processing as they pertain to fundraising, gift recording, prospect development, and alumni engagement especially in a higher-education environment
• Understanding of higher-educational foundation operational needs, especially those associated with charitable donations, gift processing, fiscal reconciliation, fund balances, and revenue forecasting
• Good understanding of CRMs, data frameworks, and platforms which support non-profits
• Ability to understand and retain regulations and guidelines as they pertain to charitable giving
• Ability to maintain high attention to detail, capacity for retaining a large set of instructions and procedural steps

Job Summary

Leads and guides the business data analyst team, data analysis and reporting for all assigned departments. Coordinates with departments and other University stakeholders to gather data, analyze trends, develop graphs and generate operational and financial reports, including but not limited to daily sales reports, report interpretation and trend analysis. Coordinates proactive problem identification and resolution through data collection, upgrade reports and interpretation. Collaborates with others to create, analyze and interpret reports to make data driven recommendations to leadership for quantitative business decisions.

Key Responsibilities

1. Compiles standard and ad hoc reports per established guidelines and frequency
2. Provides reports, analysis and data interpretation for all assigned departments
3. Provides leadership and development to data analysts
4. Identifies areas of opportunity and presents findings and recommendations to leadership and stakeholders
5. Provides productivity, labor and occupancy analysis reports
6. Develops and maintains reports to measure activity, sales and/or service utilization
7. Prepares annual reports required of association affiliations and/or oversight requirements
8. Compiles monthly operational review that includes trend analysis
9. Assists with assigned inventory reporting and analysis
10. Provides event reporting that assists with measuring performance and effectiveness
11. Collaborate with a variety of stakeholders across campus, including working closely with the Office of University Data Strategy to maintain alignment with overall university data strategy

Required Qualifications

Educational Requirements: Bachelor's degree from an accredited institution of higher education in related field
Required Experience: Three (3) years of related work experience

Preferred Qualifications

Additional Preferred Qualifications: Certificate in Data Analytics
Preferred Educational Qualifications: An advanced degree from an accredited institution of higher education in a related field

Knowledge, Skills, & Abilities

ABILITIES:
Able to utilize multiple SQL based software modules
Able to handle multiple tasks or projects at one time meeting assigned deadlines

KNOWLEDGE:
Knowledge of SAS and/or other data management software

SKILLS:
Excellent interpersonal, initiative, teamwork, problem solving, independent judgment, organization, communication (verbal and written), time management, project management and presentation skills
Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite)
Proficient with the use of Excel pivot tables and data manipulation
Strong data visualization skills
Strong attention to detail and follow up skills
Strong customer service skills and phone and e-mail etiquette

Primary Location: 1000 Chastain Road NW, Kennesaw, GA 30144

This is not a supervisory position. This position does not have any financial responsibilities. This position will not be required to drive. This role is not considered a position of trust. This position does not require a purchasing card (P-Card). This position may travel 1% - 24% of the time.