Senior Data & Business Intelligence Analyst

University Of California San Diego , CA 92140

Posted 1 week ago

UCSD Layoff from Career Appointment: Apply by 3/15/2019 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor.

Special Selection Applicants: Apply by 3/26/2019. Eligible Special Selection clients should contact their Disability Counselor for assistance.


Under the general direction of the Director of Advancement Business Intelligence (Dir-ABI), the Senior Data and Business Intelligence Analyst provides reliable and timely high-level qualitative and quantitative data and trend analysis that supports the strategic planning and operational effectiveness of key fundraising programs, including annual, major, principal, and planned giving. Specifically, the incumbent studies internal and external data and employs data mining, predictive modeling, forecasting, and/or statistical analysis techniques to provide information, knowledge, coordination, and tools that support the campus in achieving its private fundraising goals, as well as to provide assessments of Advancement program effectiveness.

More specifically, responsibilities include, but are not limited to:

Fundraising Reporting

In consultation with the Director, generate and maintain reports illustrating overall, and unit specific results. Develop and produce performance reports for fundraising operations including YTD progress toward goals, comparison with prior period, and annual reporting. Develop and produce campaign progress reports in terms of dollars raised, pipeline, portfolio capacity and development officer activity. Implement self-serve results delivery system. Partner with Senior Management, Director, and Prospect Management Liaisons to determine organizational information and reporting needs.

Fundraising Analysis

Assess and provide concise, actionable and accurate analysis of fundraising operations. Utilizing available data, respond to management analysis needs by developing strategic plans, forecasts, business cases, cost benefit analysis, ROI calculations, and any other analysis required in support of fundraising operations.

Prospect Identification

Utilizing appropriate quantitative techniques which may include statistical modeling, provide targeted prospect lists to Development Officers to balance and or augment portfolio mix. In partnership with senior management, prospect management liaisons and front line fundraisers, determine appropriate characteristics to associate with top prospects. Develop and implement appropriate tracking and metrics in support of modeling efficacy.

  • Occasional evenings and weekends may be required.

  • Must have access to reliable transportation.


  • Thorough knowledge of business intelligence functions, analytics, industry standards and best practices.

  • Demonstrated experience in business analytics. Proven ability to understand complex relational data structures.

  • Thorough knowledge of relevant internal databases, BI applications and tools. Demonstrated experience and ability to produce high-quality reports and documentation.

  • Advanced knowledge of analytical techniques, advanced knowledge of SQL or other structured language, advanced knowledge of Excel required.

  • Demonstrated experience in querying, cleansing and manipulating large data sets.

  • Proven track record in analyzing, developing and proposing business process improvements using quantitative and qualitative analytical techniques.

  • Proven ability to serve as a technical resource providing advice and counsel on business intelligence issues.

  • Working knowledge of the principles and practices of philanthropy, sales or marketing.

  • Proven ability to leverage knowledge of data needs, data sources and data solution technologies to provide clients with accurate and timely (often real-time) prospects, results and analytical reports.

  • Demonstrated ability to analyze information, situations, problems, policies and procedures; separate problems from symptoms; identify potential solutions; apply solutions and formulate logical and objective conclusions from data and observations; communicate conclusions to a variety of personnel at various levels.

  • Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions.

  • Detail oriented, with ability to manage time and organize competing priorities. Ability to maintain accuracy and focus with attention to detail in fast-paced environment with constantly changing priorities.

  • Adept in ability to learn quickly, apply creativity, understand complex processes and procedures, prioritize workload, set and meet deadlines, and perform well with a minimum of direct supervision.

  • Professional, highly-developed interpersonal skills including tact, diplomacy, flexibility and skills in dealing with politically sensitive situations required. Proven ability to effectively collaborate with a broad range of professional and technical staff.

  • Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner and explain analytical result sets to both internal and external audiences at all levels.

  • Demonstrated skill in understanding of quality service and group process with proven ability to work as part of a team and build consensus and collaboration. Ability to lead, mentor, and train others; willingness to share skills and techniques with peers and colleagues.

  • High degree of professionalism, ethical sensitivity and discretion; ability to maintain a commitment to confidentiality.


  • Job offer is contingent on a clear Background Check.

Apply Now

The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age, protected veteran status, gender identity or sexual orientation. For the complete University of California nondiscrimination and affirmative action policy see:

UC San Diego is a smoke and tobacco free environment. Please visit for more information.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Business Intelligence Analyst


Posted 5 days ago

VIEW JOBS 3/17/2019 12:00:00 AM 2019-06-15T00:00 ORGANIZATION Our purpose at Vistage is to help business leaders make great decisions that benefits their companies, families and communities. We take this to heart when it comes to our workplace and culture. At Vistage, your work is valued, and it has impact. Become an integral member of our team, where your voice is heard and your initiatives become our collaborations. With more than 22,000 members, Vistage International is the world's foremost chief executive leadership-development organization, providing unparalleled access to issue-resolution and better performance through monthly peer-advisory groups, one-on-one business coaching, expert-speaker presentations, and extensive online connectivity via articles, best practices, podcasts and webinars. Join the world's most trusted resource to CEOs and key executives. Share your potential with the world's difference-makers. SUMMARY The primary role of this position is to empower our user community with access to the right information at the right time. This position is about more than just data, as data without interpretation is interesting but not actionable. This position is responsible for taking complex projects related to specific business problems (as defined by senior management) and synthesizing data, distilling findings, and recommending next steps. Carry out statistical analyses, construct computer models, and undertake data mining studies to (1) answer research questions put forward by the company's finance, marketing, sales and operations departments; (2) simulate probable outcomes from critical business decisions; and (4) summarize data regarding key factors affecting business operations and performance for interpretation and action by non-technical managers. RESPONSIBILITIES * Work closely with business leaders to understand their processes, gather and document reporting/analysis requirements, and translate those requirements into functional and non-functional specifications. * Identify impediments and obstacles which prevent the user community from accessing the information they require * Develop methods, training plans, and tools to overcome those obstacles * Work with Senior Business Data Analyst to enhance ETL, data marts, and stored procedures in support of user needs. * Provide application-level maintenance and support of our Cognos suite, to include configuration changes, patches and upgrades. * Create methodology for extracting data. Methodologies can include Access databases, Excel spreadsheets, data cubes, report models, or custom SQL queries * Develop models, reports, and graphs depicting historic data and forecasted trends. * Perform analyses across multiple dimensions, such as lead source, location, or product. * Understand and recommend action on key drivers of KPIs * Develop and maintain accurate system documentation including information about attributes and business rules. Assists with the maintenance of data dictionaries. * Maintain understanding of BI technology trends and uses this knowledge to bring solutions to business units and IT. * Consult with business leaders to ensure that analytical studies produce usable results. * Draft and update 5-year dynamic business models. * Communicate effectively and professionally, in both oral and written communications, with all levels of the organization. REQUIREMENTS § 5-10 years of experience in an analytical or planning position, or equivalent. § Proven experience writing SQL queries, views, and stored procedures § Proven experience creating visualizations with Tableau or similar tools such as Qlikview § Proven results using quantitative methods and probability models to inform business decision-making. § Detail oriented with strong organizational, technical, and problem solving skills. § Good judgment and decision making skills and the ability to communicate effectively to all levels of the organization is essential. § Experience modeling and analysis using advanced applications of Access, Excel, and SSAS cubes. § Experience building dimensional metadata models using Cognos Framework Manager required. § Experience in report/dashboard design and development using Cognos Report Studio. KEY PERFORMANCE INDICATORS Flexible; team member; organized; independent; strategic and analytical; detail-oriented; effective communicator; creative and lively intellect; appropriate sense of urgency; ability to learn new skills particularly technology. EDUCATION Undergraduate degree in Finance, Accounting, Business Management, or Information Systems required. Vistage San Diego CA

Senior Data & Business Intelligence Analyst

University Of California