Senior BI Analyst

Minimum Education

Bachelor's Degree (Required)

Master's Degree (Preferred)

Minimum Work Experience

8 years professional experience with a proven track record of strategic planning and execution of emerging technologies in the non-profit industry. (Required)

6 years related, progressive experience with Crystal Reports or similar SQL-based reporting platform preferably in a development or fundraising environment (Required)

Required Skills/Knowledge

Knowledge of Microsoft SQL Reporting Services (SSRS) preferred

Proficiency in Microsoft Word, Excel, and relational database software including a working knowledge of querying and reporting from databases.

Strong with help-desk functions and excellent customer support.

Proficiency with web-based reporting.

Attention to detail and strong interpersonal, communication, training, and organizational skills required, as is the ability to work effectively in a team Microsoft SQL Server Management Studio

Functional Accountabilities

Ensures Optimal Functionality and Usage of Data Warehouse and BI Stack

Contributes to the strategic planning for the expansion and long term use of the Foundation’s data warehouse.

Facilitates data cohesiveness between the data warehouse and our various other data systems including our database of record, The Raisers Edge, and Luminate.

Leads the data transformation process to convert the RE production database to a reporting database.

Performs database administration/programming functions such as building and updating stored procedures, virtual fields, subroutines, application customizations, database structures and report generation under the supervision of the Director, Data Services and Business Analytics.

Creates processes within the data warehouse to measure and monitor data integrity and provide regular feedback to the data services team.

Maintains clear, complete and up to date documentation on reporting processes. Services Fundraising Efforts

Partners with various teams, including fundraisers, events, philanthropic communications, and operations to develop and implement reporting, dashboards, and business intelligence tools.

Works with teams to gather intelligence needs and criteria, design and oversee the creation of business intelligence tools and visualizations, and manage the rollout and implementation to various departmental teams.

Develops and publishes reports from the Foundation’s data warehouse that will provide information as required by Foundation staff in the cultivation, solicitation and stewardship of donors.

Generates and analyzes data and creating dashboard visualizations and reporting that is easily understood, modifiable and replicated to enable our senior staff and leadership team to determine best strategies, segmentations, applications, and approaches.

Executes query and reporting requests and data overlays within established deadlines.

Consistently monitors and evaluates reporting services for efficiency and effectiveness and makes adjustments as needed. Performance Improvement/Problem-solving

Serves as liaison with database vendors, third party consultants for technical problems associated with the data warehouse and server environment, and coordinate contact and corrective actions.

Proactively assists users in determining more efficient ways to obtain and interpret Foundation Raiser’s Edge data.

Troubleshoots data system problems and resolve system related problems.

Establishes intra-department training in order to create department-wide reporting skills.

Maintains documentation on all customizations with special attention to reducing the impact of database patches and new release loads.

Organizational Accountabilities

Organizational Accountabilities (Staff)

Organizational Commitment/Identification

Anticipate and responds to customer needs; follows up until needs are met

Teamwork/Communication

Demonstrate collaborative and respectful behavior

Partner with all team members to achieve goals

Receptive to others’ ideas and opinions

Performance Improvement/Problem-solving

Contribute to a positive work environment

Demonstrate flexibility and willingness to change

Identify opportunities to improve clinical and administrative processes

Make appropriate decisions, using sound judgment

Cost Management/Financial Responsibility

Use resources efficiently

Search for less costly ways of doing things

Safety

Speak up when team members appear to exhibit unsafe behavior or performance

Continuously validate and verify information needed for decision making or documentation

Stop in the face of uncertainty and takes time to resolve the situation

Demonstrate accurate, clear and timely verbal and written communication

Actively promote safety for patients, families, visitors and co-workers

Attend carefully to important details - practicing Stop, Think, Act and Review in order to self-check behavior and performance