Senior BI Analyst

Children's National Medical Center
United States, Maryland, Silver Spring
801 Roeder Rd #300 (Show on map)
Apr 30, 2025
Description The CNHF Sr Business Intelligence (BI) Analyst will report to the Director of Data Science and is responsible for ensuring the optimal functionality and usage of the Foundation's data warehouse and business intelligence stack. This position services fundraising efforts across the Foundation by generating and analyzing data and creating dashboard visualizations and reporting to enable our senior staff and leadership team to determine best strategies, segmentations, applications, and approaches. Partners with various teams, including fundraisers, events, philanthropic communications, and operations to develop and implement reporting, dashboards, and business intelligence tools. This position requires a combination of technical, project management, and fundraising expertise. 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 our various teams. In addition to ensuring accuracy of our intelligence tools, the Sr BI Analyst is also responsible to facilitate data cohesiveness between the data warehouse and our various other data systems including our database of record, The Raiser's Edge, and Luminate. Ideally possesses expertise in Microsoft SQL Server, Tableau, and Excel, understand non-profit fundraising best practices, and have excellent communication and project management skills. Qualifications 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 Primary Location : Maryland-Silver Spring Work Locations : Inventa Towers 1 Inventa Place Silver Spring 20910 Job : Non-Clinical Professional Organization : Childrens Hospital Foundation Position Status : R (Regular) - FT - Full-Time Shift : Day Work Schedule : 9-5 Job Posting : Apr 30, 2025, 7:53:40 PM Full-Time Salary Range : 93329.6 - 155563.2