Development Data Solutions Analyst II

BMC Software • Arlington, MA

2d

About The Position

The Development Data Solutions Analyst II is a hands-on technical role that supports Boston Medical Center’s fundraising and stewardship strategy by transforming donor, gift, and fund data into reliable, reporting-ready outputs such as user-friendly dashboards, visualization products, and reports that enable decision making across the Development structure. Using SQL, RENXT, Omatic, Microsoft Excel, and Power Automate, the Analyst II builds and documents standardized extracts, analyzes data outputs, ensures data accuracy, and develops repeatable solutions that reduce manual work and improve reporting confidence. This role provides essential technical support to the Development Services and Analytics teams, enabling accurate, timely, and actionable reporting of philanthropic data and is responsible for the development, maintenance, and administration of the Development ETL/data mart. Position: Development Data Solutions Analyst II Department: Development Support Schedule: Full Time ESSENTIAL RESPONSIBILITIES / DUTIES: Data Development & Reporting 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. Integrations & Automation 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 Data Quality & Documentation 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. (The above statements in this job description are intended to depict the general nature and level of work assigned to the employee(s) in this job. The above is not intended to represent an exhaustive list of accountable duties and responsibilities required) JOB REQUIREMENTS REQUIRED EDUCATION AND EXPERIENCE: 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. PREFERRED EDUCATION AND EXPERIENCE: 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 CERTIFICATIONS, LICENSES, REGISTRATIONS PREFERRED: Blackbaud Raiser’s Edge NXT Certification (Professional or Fundamentals). Tableau Desktop Specialist or similar data visualization certification. KNOWLEDGE, SKILLS & ABILITIES (KSAs): 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. Familiarity with data visualization and reporting tools such as Tableau or Power BI. 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. Exposure to scripting languages (Python, R) or automation concepts. Compensation Range: $66,500.00- $96,500.00 This range offers an estimate based on the minimum job qualifications. However, our approach to determining base pay is comprehensive, and a broad range of factors is considered when making an offer. This includes education, experience, skills, and certifications/licensures as they directly relate to position requirements; as well as business/organizational needs, internal equity, and market-competitiveness. In addition, BMCHS offers generous total compensation that includes, but is not limited to, benefits (medical, dental, vision, pharmacy), discretionary annual bonuses and merit increases, Flexible Spending Accounts, 403(b) savings matches, paid time off, career advancement opportunities, and resources to support employee and family well-being. NOTE: This range is based on Boston-area data, and is subject to modification based on geographic location. Equal Opportunity Employer/Disabled/Veterans According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or “apps” job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment. Working at Boston Medical Center is more than a job. It’s a chance to make a difference as part of our mission to provide exceptional and equitable care to all. As a nationally-recognized leader in health equity, nursing, initiatives to combat climate change, and many other areas, BMC is dedicated to improving the health of our community in Boston and beyond. BMC’s mission to provide exceptional care without exception extends to our employees, and we have been recognized as a top employer and best place to work. A strong sense of teamwork and support for our staff are the bedrock of BMC, as we know that we can only provide exceptional care to patients when our staff are cared for too. Boston Medical Center is an equal employment/affirmative action employer. We ensure equal employment opportunities for all, without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity and/or expression or any other non-job-related characteristic. If you need accommodation for any part of the application process because of a medical condition or disability, please send an e-mail to [email protected] or call 617-638-8582 to let us know the nature of your request. Boston Medical Center participates in the Electronic Employment Verification Program. As an E-Verify employer, prospective employees of BMC must complete a background check before beginning their employment at the hospital. BMC requires all staff to be vaccinated against COVID-19 and flu, as well as receive a booster dose of the COVID-19 vaccine. According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or “apps” job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment. To avoid becoming a victim of an employment offer scam, please follow these tips from the FTC: FTC Tips

Requirements

• 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.
• Familiarity with data visualization and reporting tools such as Tableau or Power BI.
• 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.
• Exposure to scripting languages (Python, R) or automation concepts.

Nice To Haves

• 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.

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.

Benefits

• benefits (medical, dental, vision, pharmacy)
• discretionary annual bonuses and merit increases
• Flexible Spending Accounts
• 403(b) savings matches
• paid time off
• career advancement opportunities
• resources to support employee and family well-being

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees