Massachusetts School Building Authority (MSBA)

Director

• Partner with the Director of Capital Planning to set, monitor, and achieve department goals and priorities with concentration in long-term initiatives.
• Assist the Director of Capital Planning to support the development of potential initiatives, new or expanded programs, policy updates, and department budgets. Assist in the development and processing of associated memorandums.
• Oversee the management of the Accelerated Repair Program, particularly the long-term outlook for programming and budget. Support timely processing of reviews including material for Board approvals. Manage the development of additional or expanded aspects of the Program.
• Oversee the management of the annual Statement of Interest review processes and due diligence for Core Program and Accelerated Repair Program. Support Capital Planning’s research, review, analysis, and presentation of associated material.
• Assist in the oversight of vendor contracts including program coordination and long-term planning. Concentration areas may include Technical Services, Commissioning, Post Occupancy Evaluation, and School Survey.
• Assist the Director of Capital Planning in preparing, verifying, and issuing regular reports sharing key project information and critical program decisions for internal and external audiences as well as the MSBA Board of Directors.
• Collaborate and perform technical documents to ensure project conformance with MSBA guidelines and policies.
• Lead coordination of updates to internal and external manuals and other tools for use by staff and districts to inform and ensure consistent application of MSBA grant policy for districts.
• Participate as a member of the Owner’s Project Manager Review Panel, on a rotational basis, as an assigned MSBA staff member.
• Participate as a member of the Designer Selection Panel, on a rotational basis, as an assigned MSBA staff member.
• Represent the MSBA through public outreach presentations with various professional organizations.
• Track record of delivering superior results, commanding respect, and performing leadership roles while displaying strategic and visionary skills.

Deputy Director – Capital Planning

Backend Engineer

• Design, develop, test, and implement changes and enhancements to current and developing SQL Databases as required
• Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.
• Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various complex issues as they arise
• Work with Web development team to design and develop application business and data layers.
• Write and maintain comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.
• Maintain and optimize the databases, data sources and Query server performance, including migrating new changes from online databases to the query database server
• Design and implement new tables to store data and related performance monitoring
• Design appropriate indexes for new tables, and analyze existing indexes for improvement
• Code stored procedures of high complexity to meet business requirements
• Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
• Oversee database performance issues and guide optimizations in systems design
• Implement physical data model and data access layer
• Deliver work products that meet specifications, are free of defects, and have excellent performance
• Cultivate and maintain strong relationships with co-workers and project teams
• Support development and ongoing maintenance of MSBA Applications
• Keep up to date with database development best practices
• Support the operational strategies and priorities of the MSBA.
• Perform other duties as assigned

SQL Database Developer II

Analyst

• Conduct audits of participating school districts’ monthly reimbursement requests.
• Perform closeout audits of completed school construction projects.
• Provide training and support to internal and external users of the MSBA’s Progress Payment (Pro-Pay) system.
• Review reimbursement requests along with submitted invoices for construction projects.
• Identify essential invoice elements, cost attribution, classification, and purchasing merchandise.
• Proactively communicate with stakeholders regarding missing materials and/or clarification of identified issues.
• Organize invoices related to the ProPay System requests.
• Work closely with Capital Planning and Finance team members to ensure timely payment to school districts.
• Assist with tracking projects entering closeout and cataloging required documentation.
• Prepare audit reports for review in a timely manner for further review by Finance Audit manager.
• Create and maintain relevant reports as needed and requested by internal and external constituents.
• Assist with archiving final closeout audits.
• Maintain sufficient records to support an audit trail.

Deputy Director – Capital Planning

SQL Database Developer II

Audit Analyst I