Boston Medical Center (BMC) · 18 hours ago
Development Data Solutions Analyst II
Boston, MA
Full-time
Onsite
Mid Level
$66K/yr - $96K/yr
3+ years expBoston Medical Center (BMC) is focused on enhancing their fundraising and stewardship strategy through data analytics. The Development Data Solutions Analyst II plays a crucial role in transforming donor and fund data into actionable insights and reports, supporting decision-making across the Development structure.
Health CareHospitalMedicalNon Profit
Responsibilities
Collaborate with data users, leadership, and the Development Analytics & Reporting team to define the data model and processes to create, maintain and administer the Development data mart
Write and run SQL queries to extract, clean, and join RENXT and related data
Build standardized data extracts and templates (gifts, pledges, funds, constituents) that support recurring reporting needs
Create and maintain reports and dashboards in Tableau or Power BI
Respond to ad-hoc reporting requests, providing accurate, timely data outputs
Oversee data integrations between RENXT and other platforms using Omatic
Use Microsoft Power Automate to simplify recurring tasks such as report refreshes, file transfers, or distribution
Reduce manual data handling by turning common processes into standardized or automated outputs. Proactively seek and address other aspects of data management/data use that would benefit from increased efficiency or process improvement
Run validation checks and flag inconsistencies for follow-up by Development Services team, providing guidance and support to team as needed
Document queries, logic, and reporting processes in clear, user-friendly formats
Develop and maintain a basic data dictionary, instructions, and user support materials so colleagues can use standard outputs confidently
Closely monitor performance, identify problems and implement solutions. Ensure the database is running at optimum speed and efficiency
Qualification
Required
Bachelor's degree in information systems/technology, computer science, data science
3+ years of experience working with relational databases, SQL development, database administration, and/or BI development at a hospital or health care institution
or equivalent combination of education and experience
Thorough understanding relational database concepts and SQL programming for designing, troubleshooting, and validating queries to ensure accurate reporting
Advanced Microsoft Excel skills (lookups, pivot tables, formulas, Power Query) and strong proficiency across Microsoft 365 applications, including Outlook, Teams, SharePoint, and Power Automate
Highly organized and detail-oriented, with exceptional documentation skills and ability to ensure accuracy under tight deadlines
Ability to manage and prioritize multiple projects and requests simultaneously
Understanding of fundraising data structures (gifts, funds, pledges, constituents)
Ability to maintain donor confidentiality
Preferred
Experience with Omatic or similar ETL/middleware & processes
Hands-on experience with fundraising CRMs (RENXT strongly preferred)
Experience with database administration and management tools
Experience with reporting and reporting tools such as Power BI or Tableau
Blackbaud Raiser's Edge NXT Certification (Professional or Fundamentals)
Tableau Desktop Specialist or similar data visualization certification
Exposure to scripting languages (Python, R) or automation concepts
Benefits
Medical
Dental
Vision
Pharmacy
Discretionary annual bonuses
Merit increases
Flexible Spending Accounts
403(b) savings matches
Paid time off
Career advancement opportunities
Resources to support employee and family well-being
Company
Boston Medical Center (BMC)
Boston Medical Center (BMC) is a 511-bed, equity-led academic medical center and a proud member of the Boston Medical Center Health System.
5001-10000 employees
H1B Sponsorship
Boston Medical Center (BMC) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (53)
2024 (51)
2023 (51)
2022 (38)
2021 (26)
2020 (32)
Funding
Current Stage
Late StageTotal Funding
$342.49MKey Investors
AmeriCorps Public AlliesNational Institute on Drug Abuse (NIDA)The Boston Foundation
2024-07-09Grant· $0.06M
2023-02-23Debt Financing· $232M
2019-04-23Grant· $89M
Leadership Team
David Beck
Senior Vice President & Chief Legal Counsel
Recent News
2025-11-11
2025-11-10
Company data provided by crunchbase