Business Systems Analyst, Business Intelligence, Duke Alumni Engagement and Development (AED)

Occupational Summary

The Business Systems Analyst is a member of the Analytics team in Business Intelligence in Duke Alumni Engagement and Development (AED). We’re a team that is excited about data and use it to drive strategy. We conduct analyses, develop forecasts, and provide strategic recommendations in support of the engagement and fundraising priorities of the University. Our crucial work on an innovative and collaborative team helps raise more money for Duke and activate the global network of alumni, parents, and friends. We use data to accomplish this.

The incumbent is responsible for collaborating with colleagues across Duke to provide timely and accurate business intelligence that lead to greater effectiveness and efficiency. Business Intelligence works with almost 50 years of biographical and transactional level data in an extremely complex data environment (700,000+ households, millions of transactions). The Business Systems Analyst creates processes, reports, analysis, reporting, and tools that allow fundraisers, engagement officers, communicators, managers, and leaders to have a thorough understanding of the impact of their work. BI nurtures partnerships and translates data into actionable business intelligence, thoughtfully using data to achieve ambitious fundraising and engagement goals.  The work of the Business Systems Analyst will utilize an alumni centric mindset when analyzing, utilizing, and presenting data in this role.

Work Performed

Strategy and Analysis

• Convert data into actionable business intelligence through a deeply developed understanding of the functional needs of users and program requirements of leaders. Maps business needs to functional system requirements and partners across alumni engagement and development to determine appropriate reports and systemization that improve business process.
• Lead team efforts for analytical reviews, process improvement, and systems generation. Recommend improvements that are thoroughly supported and researched and demonstrate an understanding of advancement and engagement work, systems, and practices. Act as a key advocate for the transformational power of applying business insights to change process.
• Design and lead the production of complex data analyses, forecasts, and predictive modeling projects in order to create strategic recommendations in support of the alumni engagement and fundraising efforts of the University.
• Develop and refine predictive analytic models to support the needs of engagement and fundraising teams in AED, schools/units, and health system.
• Create forecasts for leadership to monitor anticipated progress toward engagement and fundraising goals.
• Develop strategies and programs to grow the size and value of the managed prospect pool university-wide through the aggressive collection, maintenance, and analysis of information including developing predictive models and the use of APIs or other data collection techniques.
• Work closely with the Senior Director of Advancement Analytics to increase the scope and utility of data intelligence services offered to the DAED community including devising strategies to drive adoption of existing tools. Think strategically and listen actively while building consensus and advocating effectively in a complex decentralized organization.
• Working collaboratively with the Associate Vice President for Campaigns, help Duke prepare for an ambitious fundraising campaign including forecasting, modeling, data integration, and planning for consistent community reporting.
• Engage the community with data, ask questions, tell stories, and find the right sized data solution that answers the end-users programmatic questions in a timely and scalable solution. Working with leaders across advancement, create, monitor, and execute implementation plans that support recommended change.
• Collaborate across the organization to identify or anticipate opportunities and implement solutions that create development-wide reporting resources and solutions. Evaluate emergent trends in the broader analytics field for alumni engagement and development application.
• Create materials related to the work of Business Intelligence in an accessible and memorable format for all levels of professional, technical, and administrative staff primarily using interactive web based visualization tools such as Tableau, java, python, R, or other software packages focused on data visualization and analytical storytelling.
• Oversee ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation including highly accurate, replicable data reporting tools.  
• Identify and recommend opportunities to improve and consolidate reporting with an eye to efficiency and program outcomes. Determine the right data, the right question, the right tool, and the appropriate audience for work deliverable.

Reporting and visualization

• Identify opportunities to develop or enhance reporting tools for fundraisers, managers, and leaders within all areas of development. Advocate for successful implementation and utilization of new and existing tools.
• Identify and implement best practices for distributing information to a complex decentralized network of interested parties.
• Conduct complex modeling projects within Analytics in R, SAS, or other statistical packages; provide strategic leadership in identifying community needs, appropriate measures, and implementation plans that increase fundraising success and identify opportunities for improvement. Listen, translate, and act on recommendations from leadership. 
• Cultivate relationships with peer schools to identify best in industry practices that can be applied to or enhance the fundraising progress or culture of Duke.
• Participate in cross-departmental projects to improve understanding and strategic use of business intelligence tools and data. Optimize existing systems for efficiency and end-user experience.
• Develop and implement staff training regarding new Analytics tools or initiatives broadly. Collaborate across Business Intelligence to create best practices for the comprehensive monitoring and tracking of managed and engaged prospects through the solicitation cycle.  

Other

• Work in a collaborative team environment, sharing knowledge and newly identified sources with team and leading or participating in team projects.
• Other related duties incidental to the work described herein.

Preferred Qualifications

Master's or professional degree preferred.

A minimum of three years of experience gathering, analyzing, querying, and evaluating complex relational datasets or enterprise data management systems with a preference to institutions of higher education and development and alumni engagement.

Skills

• Excellent written and oral communication skills with the ability to synthesize and accurately present relevant information.
• Exceptional skills in translating complex data analytics to diverse audiences.
• A minimum of three years of experience developing creative data outputs including dashboards and highly visual end-user reports in Tableau, SAS, R, or Python.  
• Demonstrated track record of strategic and creative approaches to analytics (process mapping, and evaluation) with collaboration with constituent facing roles, system administrators, and senior level management.
• Advanced skills and proficiency with standard analytic tools including Tableau, SAS, SQL, Python, or R.
• Prior experience with university constituent database systems preferred.
• Ability to apply independent judgment and initiative required. Must be able to share success and integrate ideas.
• Strong commitment to maintaining the integrity and confidentiality of data.

Behavioral Competencies

• Self-Management
• Curiosity and Information Seeking
• Goal and Task Management
• Promotes Innovation and Creativity
• Organizational Awareness
• Ability to Influence
• Collaborating with Others
• Leadership

Duke University provides an annual base salary range for thisposition as USD $60,328.00 to USD $94,000.00. Duke University considers factors such as (but not limited to) scope and responsibilities of the position; candidate' s work experience, education/training, and key skills; internal peer equity; as well as market and organizational considerations when extending an offer.

Your total compensation goes beyond the dollars on your paycheck. Duke provides comprehensive and competitive medical and dental care programs, generous retirement benefits, and a wide array of family-friendly and cultural programs to eligible team members. Learn more a t:https://hr.duke.edu/benefits/

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/ or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.

Education

Work requires a Bachelor's degree.

Experience

3 years combined business/work analyst, software QA, or user support/training experience,OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE.

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essentialjob functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.