The Senior Data Analyst will provide, in a timely manner, data files and reports to meet the ongoing management, program planning, and communication needs of the Development and Alumni Relations teams as well as other campus partners who have a desire to engage with alumni, donors, and other data managed by University Advancement.
The selected candidate will design, develop, maintain, and enhance systems to improve operations to meet the current and future needs of the division. Such support will be in the form of fully automated solutions, ad hoc reporting, and database integrations. They will develop procedures and solutions to ensure the quality of the data in these information systems; partner with senior management to determine organizational information and reporting needs; generate and/or maintain reports or data dashboards illustrating overall as well as unit specific results; and develop and produce performance reports for constituent engagement and fundraising operations.
This position will also study data and employ data mining, predictive modeling, forecasting, and/or statistical analysis techniques to provide information, knowledge, and tools that support the university in achieving its private fundraising goals, as well as provide assessments of program effectiveness. Conducts regular review and analysis of existing reports and tools. The Senior Data Analyst will serve as technical liaison to the University System of Maryland Advancement Services team relative to the implementation and maintenance of the alumni and donor management solution, which is currently Ellucian Advance Web in addition to serving as technical representative on behalf of University Advancement in discussions with vendors, TU Office of Technology Services, and other departments on issues relating to business needs.
Bachelor's degree with four years of database management, project management, programming and data analysis experience, preferably in a fundraising environment; knowledge of computer programming, system analysis and design, data exchange methodologies; ability to communicate effectively and collaboratively in writing and speaking, with technical and non-technical staff; experience in reporting and analytics, and ability to analyze, forecast, and present data in a meaningful way for operational and business planning; familiarity with complex relational databases and ability to design reports from databases; strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop effective solutions; demonstrated experience and ability to produce high-quality reports and documentation; and strong management skills and the ability to manage, motivate, and evaluate staff.
The selected candidate must be adept at managing time and organizing competing priorities with the ability to maintain accuracy and focus with attention to detail in fast-paced environment with constantly changing priorities; be able to learn quickly, prioritize workload, meet deadlines, and perform well with minimal direct supervision; possess high degree of professionalism, ethical sensitivity, and discretion, and have the ability to maintain a commitment to confidentiality. Advanced knowledge of Oracle SQL, PL-SQL, Crystal Reports, HTML, ASP, and .Net are required.
Experience working with major fundraising products/platforms such as Ellucian Advance, Raisers Edge,Salesforce, or similar constituent database.
An understanding of the advancement process and fundraising terminology.
Data transformation (ETL) experience.
Knowledge of Data Warehouse Concepts.
A Criminal Background Investigation is required for the hired candidate and the results may impact employment.