Massachusetts School Building Authority (MSBA)

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.

SQL Database Developer II

Audit Analyst I