Associate Director of Business Intelligence & Analytics.

UVA Health•Charlottesville, VA

10d•$90,000 - $95,000•Hybrid

About The Position

External Relations at the University of Virginia is hiring an Associate Director of Business Intelligence & Analytics for a senior individual-contributor role within University Advancement. The position translates complex data into actionable insights for Advancement leadership, prospect managers, and development officers. It focuses on prospect pipeline analysis, data warehouse and reporting infrastructure, and governance that keeps Advancement data accurate, secure, and usable. The role combines hands-on technical work—including data warehouse development, ETL design, and dashboard and report creation—with vendor and stakeholder engagement and strategic guidance on using data and analytics to advance fundraising performance. It has no direct reports, but provides technical support and mentorship to colleagues on the Business Intelligence team. The position is exempt and benefited, and is dependent on funding availability. UVA External Relations offers a flexible, hybrid workplace. The role can be worked remotely, with the expectation of being in Charlottesville, Virginia, at least four times per year at UVA’s expense. The employee must maintain a secure home office with high-speed internet and collaborate with colleagues using technology and tools. The anticipated hiring range is $90,000–$95,000 per year, commensurate with education and experience. Applicants must have a relevant master’s degree or foreign equivalent, at least five years of progressive experience in data science and/or business intelligence, and nonprofit or higher-education advancement experience. Background checks are conducted for new hires. Candidates requiring immigration sponsorship now or in the future will not be considered.

Requirements

Master’s degree or foreign equivalent in a relevant field, such as data science, business analytics, information systems, statistics, or a related discipline.
At least five years of progressive experience in data science and/or business intelligence.
Nonprofit or higher-education advancement experience.
Strong analytical and problem-solving skills, including the ability to turn complex data into clear, actionable recommendations for nontechnical audiences.
Excellent written and verbal communication skills, including the ability to present technical concepts to varied stakeholders.
Ability to manage multiple priorities, projects, and deadlines in a fast-paced environment.
Sound judgment regarding data privacy, security, and governance.
Collegial, service-oriented approach to internal partners and cross-functional teams.
Ability to informally mentor colleagues and share technical expertise without formal supervisory authority.
Ability to maintain a secure home office environment with high-speed internet and collaborate using a variety of technologies and tools.
Candidates must not require immigration sponsorship now or in the future.

Nice To Haves

Experience manipulating data and creating or refining data visualizations and dashboards.
Experience with a variety of databases and software tools, such as Snowflake, Oracle, SQL Server, or similar.
Snowflake data warehouse development, including dynamic tables, stored procedures, functions, and fact/dimension modeling.
Knowledge of source-to-target ETL processes and multi-layer database architecture.
Experience managing database permissions, roles, and access control.
Experience creating and configuring AWS AppFlow integrations.
Quantitative and qualitative analysis experience.
SQL, Tableau, and/or comparable business intelligence tools.
Tableau Server administration experience.
Salesforce administration experience.
Data conversion project experience.
Experience with version control tools such as Azure Git Repos.
Experience leading individual projects or initiatives, without staff supervision.
Experience designing, implementing, and maintaining data warehouses.
Knowledge of data governance principles and practices.
Experience partnering with key stakeholders to provide business analysis that drives organizational performance.

Responsibilities

Lead individual projects and contribute to team meetings, helping set technical direction and maintain consistent quality across Business Intelligence work.
Serve as a technical resource and mentor to colleagues on the Business Intelligence and Prospect Management & Research teams, and represent the department through presentations and training for organizational partners.
Liaise with university partners on data projects, practices, and procedures.
Review systems and processes and advise leadership on potential improvements and recommendations.
Evaluate reporting products and vendor-provided packages for their effectiveness in supporting Advancement’s business needs.
Analyze the university’s prospect pipeline to generate insights that drive fundraising activity and strategy.
Conduct strategic data review and analysis; produce reports and data extracts using SQL, Tableau, and other BI tools; and translate analysis into recommendations that inform business processes.
Support management of the prospect pool and pipeline using data manipulation and reporting skills across prospect and pipeline development.
Contribute to the design of unit-wide visualizations and reports assessing portfolios, pipelines, and development officer and unit progress against performance and campaign goals.
Review and monitor prospect and proposal pipeline data through custom report audits, extracts, analysis, and ongoing communication with University Advancement partners.
Provide reporting and analysis support for campaign progress, annual giving, and engagement.
Respond to ad hoc data and analytics requests.
Design, build, and maintain Snowflake data warehouse objects, including dynamic tables, stored procedures, and user-defined functions.
Develop and maintain fact and dimension models for the data warehouse and reporting architecture.
Apply source-to-target ETL processes and multi-layer database design to ensure data integrity across systems.
Manage database permissions and roles for data governance, security, and access control.
Create and modify AWS AppFlow configurations to integrate and transfer data between systems.
Administer Tableau Server, including sites, permissions, data sources, and publishing workflows.
Administer Salesforce users, permissions, and data configurations supporting Advancement business needs.
Lead data conversion efforts and ensure accuracy and integrity of migrated data.
Use Azure Git Repos collaboratively for version control of code, scripts, and database objects.
Pursue professional development that enhances job performance, including analysis and visualization skills, conference attendance, and networking within the university and with peer institutions.
Remain current on philanthropic trends affecting higher education.
Perform other duties within the scope of the position as assigned.