---
title: 'SQL Database and Business Intelligence Developer II at Massachusetts School Building Authority'
canonical: 'https://feeny.ai/job/sql-database-and-business-intelligence-developer-ii-massachusetts-school-6cp0c5q70kye'
type: 'job'
last_seen: '2026-09-09'
---

# SQL Database and Business Intelligence Developer II at Massachusetts School Building Authority

- **Company:** Massachusetts School Building Authority
- **Location:** Boston, MA
- **Compensation:** $95k–$106k
- **Employment:** full-time
- **Work type:** hybrid
- **Posted:** 2026-06-17
- **Last confirmed live:** 2026-09-09
- **Apply:** https://jobs.lever.co/massschoolbuildings/f52fb20f-972a-4f5f-8996-114415c218f5

## Job description

Job Title:       SQL Database and Business Intelligence Developer II Department: Information Technology Reports To:   Senior SQL Database and Business Intelligence Developer FLSA:            Exempt Status:            Full-Time Grade:            12

## POSITION DESCRIPTION AND SCOPE

The SQL Database and Business Intelligence Developer II is responsible for the development, testing, implementation and support of Microsoft SQL-based relational databases. The databases are used to collect and analyze data gathered through the Authority’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting data sets and visualizations utilizing various business intelligence and reporting platforms.  This position will ensure the database is well maintained, scalable and available to all users. This position will also administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database and Business Intelligence Developer II will participate in the full development life cycle to meet the objectives of the MSBA.

Essential Functions and Responsibilities

- Design, develop, test, and implement changes and enhancements to SQL Databases as required
- Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and dashboards as assigned, using various BI reporting platforms including, but not limited to, Tableau and Power BI
- Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.
- Maintain and implement database objects, including tables, views, keys, indexes, constraints, defined types, functions, stored procedures, etc.
- Code stored procedures of high complexity to meet product requirements
- Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
- Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various issues as they arise
- Maintain and manage database schemas, SQL agent jobs and user’s roles with proper permissions.
- Troubleshoot database performance issues to ensure optimizations in system designs.
- Manage code migration to various environments according to software development life cycle.
- Maintain and write comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.
- Support the operational strategies and priorities of the Authority.
- Able to independently work with internal stakeholders to identify, gather business requirements, propose analytical report solutions and implement the proposed solutions.
- Troubleshoot and resolve outages from existing applications.
- Maintain quality service through IT policies and standards.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; benchmarking state-of-the-art practices; participating in professional societies.
- Perform other duties as assigned

Required Knowledge and Skills

- Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting
- Strong SQL Server 2016(and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment
- Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Strong knowledge of relational and dimensional data modeling
- Highly experienced in writing and optimizing database scripts, SQL stored procedures, functions and other SQL database objects that assist in the implementation and maintenance of business logic and data flows through MSBA data and application infrastructure.
- Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports.
- Experience in code migration, database change management and data management through the various stages of the development lifecycle
- Thorough understanding with hands-on skills of MS SQL Server 2016 (and above) and SSRS Server installation and configurations. Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
- Work with our team members and in-house QA to resolve bugs and issues.
- Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained
- Experience with versioning control environments including Azure DevOps and/or GIT
- Strong communication skills and the ability to work both independently and as part of a team
- Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines
- Professional interpersonal style; ability to work and build trust with a diverse range of people
- Ability to work in an Agile environment.
- Ability to work creatively, learn quickly and solve complex problems in high-pressure situations
- Exhibit a professional ‘can-do’ attitude and flexible work style approach
- Ability and willingness to proactively research and/or resolve issues

## Preferred Knowledge and Skills

- Relevant Microsoft Certifications
- Masters in technical discipline
- Experience in Database Design and administration.
- Experience with cloud-based solutions
- Experience with VB.Net, ASP.Net and C#
- Experience with network/storage architecture

This job description is intended to be general and will evolve over time.  The description is subject to periodic updating.  At management’s discretion, the employee may be assigned different or additional duties from time to time.

## About Massachusetts School Building Authority

## Company Overview
- **One-liner**: The MSBA is a quasi‑independent government authority that partners with Massachusetts communities to fund and oversee the design, construction, and renovation of sustainable, educationally appropriate public school facilities.
- **Entity Type**: Quasi‑public government agency (non‑profit, not publicly traded or venture‑backed)
- **Headquarters**: Boston, Massachusetts, USA
- **Founded**: 2004 (created by the Massachusetts Legislature to replace the former school building assistance program)
- **Founders**: Established by an act of the Massachusetts General Court; not attributable to individual founders

## Core Business
- **Primary industry**: Government – Public School Capital Funding and Construction Management
- **Target customers**: B2G – Cities, towns, and regional school districts across Massachusetts
- **Mission statement**: “To partner with Massachusetts communities to support the design and construction of educationally appropriate, flexible, sustainable, and cost‑effective public school facilities.”

## Products & Services
- **Core Program**: Supports large‑scale new construction, additions, and major renovations. The MSBA invites school districts into a competitive, multi‑phase due diligence process and reimburses eligible costs based on a formula that accounts for community income, property wealth, and low‑income student proportion.
- **Accelerated Repair Program (ARP)**: For limited‑scope projects such as roof, window, and door replacements, plus heat‑pump conversion of heating systems. Over 550 projects are active or completed across 166 districts.
- **Green Repair Program (historical)**: One‑time $300 million program launched in 2010 that funded 189 green‑oriented repair projects (now evolved into the ARP).
- **School Survey / Building Condition Assessment**: The MSBA periodically surveys all public school facilities (1,818 schools in 2025) to assess building condition, using the data to prioritize funding and evaluate program needs.

## Market Standing
- **Valuation/Market Cap**: Not applicable (government authority with no equity value)
- **Key Revenue/Funding**:
  - Dedicated revenue source: 1% of the state’s 6.25% sales tax (approx. $1.4 billion in FY2025)
  - Total reimbursements since inception: over $18.9 billion
  - FY2025 grant payments to municipalities: ~$755 million
  - Total expenses for FY2025: ~$971 million (including $384 million in debt service)
- **Notable Investors/Partners**:
  - Board of Directors chaired by the State Treasurer (currently Deborah B. Goldberg, with CEO Jim A. MacDonald)
  - Seven‑member board including the Secretary of Administration & Finance, the Commissioner of Education, and four appointees (architect, former school committee member, university capital projects executive, former town administrator)
- **Growth Signals**:
  - In 2025, the MSBA invited 93 of 99 Statements of Interest into the ARP and 15 of 27 into the Core Program – the highest invitation rates in years
  - The Core Program project cap was increased to $1.2 billion in FY2024, with annual escalations up to 6.5%
  - $100 million in COVID‑inflation supplemental awards distributed to 30 districts by January 2025
  - Launched heat‑pump conversion projects within the ARP to support Massachusetts’ net‑zero carbon goal by 2050
  - 10 schools completed in 2025, bringing total completed Core Program schools to 245

## Competitive Advantages
- **Dedicated revenue stream**: The MSBA is funded by a fixed portion of the state sales tax, providing predictable, stable funding that is not subject to annual legislative appropriations.
- **Specialized expertise**: The agency has 20 years of experience managing large‑scale public school capital projects, from initial assessment through construction completion and final audit.
- **Efficient reimbursement model**: Districts receive payments as costs are incurred (typically within 15 days via an online portal), rather than waiting years for reimbursement – a significant improvement over the previous system.
- **Scale and track record**: Over 1,200 projects invited into the pipeline, $18.9 billion disbursed, and 1,748 projects with completed final audits.

## Strategic Focus
- **Net‑zero carbon alignment**: Partnering with the Commonwealth’s goal to achieve net‑zero emissions by 2050 by funding heat‑pump conversions and high‑efficiency building systems.
- **Equitable funding**: Using a needs‑based formula (base rate + incentive points for regionalization, renovation, energy efficiency) to allocate resources fairly across communities.
- **Facility condition improvement**: Continuing the 2025 School Survey (1,818 schools) and using data to direct funds to the most critical needs – while 89% of schools rate at condition 1 or 2, the agency targets the 10.7% that need moderate or major attention.
- **Program expansion**: Increasing the Core Program cap and invitation numbers to meet the high demand from districts for new and renovated schools.

## Why Work Here
- **Mission‑driven culture**: Employees contribute directly to improving public education infrastructure across Massachusetts, working with communities to create safe, sustainable learning environments.
- **Work location & flexibility**: Based in Boston; roles are hybrid (e.g., the External Affairs Coordinator and Deputy Director of Capital Planning positions listed as “Hybrid – Full‑Time Hybrid Boston, Massachusetts”).
- **Public‑sector stability**: A quasi‑public entity with a dedicated revenue stream, offering predictable funding and long‑term career security.
- **Meaningful impact**: Staff see tangible results – schools completed, grants distributed, and communities supported – with projects bidding over $1 billion annually through 2027.
- **Professional growth**: Opportunities in capital planning, project management, external affairs, and finance within a recognized state agency.

## Sources
1. [massschoolbuildings.org](https://massschoolbuildings.org/about)
2. [MSBA 2025 Annual Report (PDF)](https://massschoolbuildings.org/sites/default/files/edit-contentfiles/News_Events/Publications/MSBA_Annual_Report_CY25.pdf)
3. [mass.gov – Audit Overview](https://www.mass.gov/info-details/audit-of-the-massachusetts-school-building-authority-overview-of-audited-entity-0)
4. [jobs.lever.co/massschoolbuildings](https://jobs.lever.co/massschoolbuildings)
5. [massschoolbuildings.org – Senior Staff](https://www.massschoolbuildings.org/about/senior_staff)

## Other roles at Massachusetts School Building Authority

- [Audit Analyst I](https://feeny.ai/job/audit-analyst-i-massachusetts-school-building-authority-boston-0tqm8axzzaze) — Boston, MA
- [Human Resources Coordinator](https://feeny.ai/job/human-resources-coordinator-massachusetts-school-building-authority-boston-w6eepvaaeggt) — Boston, MA
- [Director of District Audits](https://feeny.ai/job/director-of-district-audits-massachusetts-school-building-authority-boston-zm6q7fmeqw0e) — Boston, MA
- [Senior Project Manager, Construction Administration](https://feeny.ai/job/senior-project-manager-construction-administration-massachusetts-school-0d4gmsngfmmb) — Boston, MA
- [Assistant Project Manager, Construction Administration](https://feeny.ai/job/assistant-project-manager-construction-administration-massachusetts-school-3ezsckvzday8) — Boston, MA
- [Project Manager III - Construction Administration](https://feeny.ai/job/project-manager-iii-construction-administration-massachusetts-school-building-6qjkgxxd3rat) — Boston, MA