Massachusetts School Building Authority (MSBA)

Business Intelligence Developer

• 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

SQL Database Developer II, Business Intelligence