Data AnalystProgrammer
Data AnalystProgrammer
Posted on :
12-04-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
12-04-2025
Job Description
Position Summary
The Data Analyst/Programmer reports directly to the Director of Advancement Services and is responsible for the design implementation and maintenance of Institutional Advancements (IA) database and reporting systems. The position supports various departments within the divisions of Institutional Advancement College Relations and partners with STS and software vendors to meet data and reporting needs accurately and efficiently. The ability to provide fundraising reports retrieve data accurately and in a timely manner the maintenance of hardware and software and the ability to troubleshoot problems are of primary importance to this role. The Data Analyst/Programmer will lead the division in all major data projects included but not limited to database cleanup updates upgrades and conversions.
Essential Duties And Responsibilities
Develop test and provide reports in a timely manner in support of all programs within the divisions of Institutional Advancement and College Relations (and other areas as directed); Maintain and enhance the reporting tools used to extract data from the database. Perform database administration/programming functions such as; building and updating fields subroutines application customization database structures and report generation. Create and design custom reports dashboards visualizations and database programs. Design implement modify and maintain operational reports dashboards and data visualizations to track progress of fundraising programs toward fiscal year goals. Translate data into useful tools for development and alumnae affairs staff. Organize and maintain analyses and reports for regular and systematic dissemination. Design data structures and maintain integrity in databases based on a thorough understanding of the structure of current databases and of the divisions various fundraising programs. Serve as liaison with STS database vendors third party consultants for technical problems associated with the database application and server environment and coordinate contact and corrective actions. Represent Institutional Advancement regarding all matters pertaining to the campuswide enterprise system. Implement and manage the integration of all user interfaces with administrative applications coordinate disk space planning and management and monitor and tune the system to achieve optimum performance. Assist with the identification of and conversion to a new fundraising database including system definitions creation of business rules conversion timeline testing and . Maintain documentation on all customizations with special attention to reducing the impact of database patches and new release loads. Develop and validate statistical models for forecasting fiscal year end progress using historical trend data and information from industry peers. Analyze and interpret data to identify issues and recommend appropriate methods to resolve; develop and implement predictive models for identifying new prospects for the Colleges fundraising efforts. Work with Prospect Research team members to validate results and track success of proactive identification efforts. Develop a prospect scoring system through data modeling and research of engagement giving and external data. Collect data and maintain ongoing peer benchmarking studies on a variety of aspects in development; oversee the Colleges participation in various institutional surveys relevant to fundraising and alumnae affairs programs. Must be available for evening and weekend work.
Physical Demands
While performing the duties of this job the employee is regularly required to: talk hear sit and use hands to operate the computer and other office equipment. The employee frequently is required to: stand and walk. The employee is occasionally required to: reach with hands and arms and lift and/or move up to 15 pounds. Specific vision abilities required by this job include ability to adjust focus.
Required Qualifications
Bachelors Degree (B.A./B.S. and at least three years related experience required. Experience in higher education fundraising with major fundraising database systems such as Raisers Edge Ellucian Banner Salesforce etc. preferred. The work of this position requires expertise in a variety of analytical and database reporting software including Microsoft Excel Access software expertise in SQL report writing especially using Crystal Reports and Argos/Cognos Reporting Tableau software statistical analysis and forecasting programs (e.g. SPSS SAS Crystal Ball Forecast Pro) and presentation. Experience implementing results of electronic donor screening and segmenting initiatives preferred. The incumbent must have considerable working knowledge of and ability in coding Oracle and one or more database management systems such as MySQL MS SQL Server PL/ SQL and/or DB2 for efficient data retrieval in a complex scheme stored procedures triggers and server side scripting; knowledge of Oracle 10g/11g Oracle PL/ SQL Oracle Forms Oracle Developer and Oracle VPD facility; familiarity with relational databases and ability to design reports from databases. Demonstrated ability to interpret and present information and ideas clearly and accurately in writing verbally and by preparation of reports and other materials. Maintain a high level of professionalism and confidentiality in dealing with information and working with members of the Senior Team departments and divisions across campus along with external vendors. Incumbent will exemplify successful experience in developing directing and managing multiple projects and implementing strategic program goals.
Preferred Qualifications
Experience in higher education fundraising with major fundraising database systems such as Raisers Edge Ellucian Banner Salesforce etc. preferred. Experience implementing results of electronic donor screening and segmenting initiatives preferred.
The Data Analyst/Programmer reports directly to the Director of Advancement Services and is responsible for the design implementation and maintenance of Institutional Advancements (IA) database and reporting systems. The position supports various departments within the divisions of Institutional Advancement College Relations and partners with STS and software vendors to meet data and reporting needs accurately and efficiently. The ability to provide fundraising reports retrieve data accurately and in a timely manner the maintenance of hardware and software and the ability to troubleshoot problems are of primary importance to this role. The Data Analyst/Programmer will lead the division in all major data projects included but not limited to database cleanup updates upgrades and conversions.
Essential Duties And Responsibilities
Develop test and provide reports in a timely manner in support of all programs within the divisions of Institutional Advancement and College Relations (and other areas as directed); Maintain and enhance the reporting tools used to extract data from the database. Perform database administration/programming functions such as; building and updating fields subroutines application customization database structures and report generation. Create and design custom reports dashboards visualizations and database programs. Design implement modify and maintain operational reports dashboards and data visualizations to track progress of fundraising programs toward fiscal year goals. Translate data into useful tools for development and alumnae affairs staff. Organize and maintain analyses and reports for regular and systematic dissemination. Design data structures and maintain integrity in databases based on a thorough understanding of the structure of current databases and of the divisions various fundraising programs. Serve as liaison with STS database vendors third party consultants for technical problems associated with the database application and server environment and coordinate contact and corrective actions. Represent Institutional Advancement regarding all matters pertaining to the campuswide enterprise system. Implement and manage the integration of all user interfaces with administrative applications coordinate disk space planning and management and monitor and tune the system to achieve optimum performance. Assist with the identification of and conversion to a new fundraising database including system definitions creation of business rules conversion timeline testing and . Maintain documentation on all customizations with special attention to reducing the impact of database patches and new release loads. Develop and validate statistical models for forecasting fiscal year end progress using historical trend data and information from industry peers. Analyze and interpret data to identify issues and recommend appropriate methods to resolve; develop and implement predictive models for identifying new prospects for the Colleges fundraising efforts. Work with Prospect Research team members to validate results and track success of proactive identification efforts. Develop a prospect scoring system through data modeling and research of engagement giving and external data. Collect data and maintain ongoing peer benchmarking studies on a variety of aspects in development; oversee the Colleges participation in various institutional surveys relevant to fundraising and alumnae affairs programs. Must be available for evening and weekend work.
Physical Demands
While performing the duties of this job the employee is regularly required to: talk hear sit and use hands to operate the computer and other office equipment. The employee frequently is required to: stand and walk. The employee is occasionally required to: reach with hands and arms and lift and/or move up to 15 pounds. Specific vision abilities required by this job include ability to adjust focus.
Required Qualifications
Bachelors Degree (B.A./B.S. and at least three years related experience required. Experience in higher education fundraising with major fundraising database systems such as Raisers Edge Ellucian Banner Salesforce etc. preferred. The work of this position requires expertise in a variety of analytical and database reporting software including Microsoft Excel Access software expertise in SQL report writing especially using Crystal Reports and Argos/Cognos Reporting Tableau software statistical analysis and forecasting programs (e.g. SPSS SAS Crystal Ball Forecast Pro) and presentation. Experience implementing results of electronic donor screening and segmenting initiatives preferred. The incumbent must have considerable working knowledge of and ability in coding Oracle and one or more database management systems such as MySQL MS SQL Server PL/ SQL and/or DB2 for efficient data retrieval in a complex scheme stored procedures triggers and server side scripting; knowledge of Oracle 10g/11g Oracle PL/ SQL Oracle Forms Oracle Developer and Oracle VPD facility; familiarity with relational databases and ability to design reports from databases. Demonstrated ability to interpret and present information and ideas clearly and accurately in writing verbally and by preparation of reports and other materials. Maintain a high level of professionalism and confidentiality in dealing with information and working with members of the Senior Team departments and divisions across campus along with external vendors. Incumbent will exemplify successful experience in developing directing and managing multiple projects and implementing strategic program goals.
Preferred Qualifications
Experience in higher education fundraising with major fundraising database systems such as Raisers Edge Ellucian Banner Salesforce etc. preferred. Experience implementing results of electronic donor screening and segmenting initiatives preferred.
Required Experience:
IC
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
