SQL Database Developer II, Business Intelligence

Massachusetts School Building Authority (MSBA)

SQL Database and BI Developer responsible for development, testing, and support of SQL databases for Authority’s applications. Ensuring scalability and availability of databases for all users.

Posted 4/14/2026full-timeBoston • Massachusetts • 🇺🇸 United StatesMid-LevelSenior💰 $94,893 - $105,569 per yearWebsite

Tech Stack

Tools & technologies

AzureMS SQL ServerSDLCSQLSSISTableau

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

🌐 Worldwide Post a Job Affiliates ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs Account Massachusetts School Building Authority (MSBA) Website LinkedIn All Job Openings 51 - 200 employees The Massachusetts School Building Authority (“MSBA”) is a quasi-independent government authority created to reform the process of funding capital improvement projects in the Commonwealth’s public schools. Our mission is to partner with Massachusetts communities to support the design and construction of educationally-appropriate, flexible, sustainable, and cost-effective public school facilities. SQL Database Developer II, Business Intelligence 🔥 58 minutes ago 🏢🏡 Boston – Hybrid 💵 $94.9k - $105.6k / year ⏰ Full Time 🟡 Mid-level 🟠 Senior 📊 Business Intelligence Developer Apply Now Find Hiring Managers Customize resume for this job ☆ Save ☑️ Mark as applied ❌ Hide Report problem 📋 Description
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 🎯 Requirements
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 Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Power BI Developer 🕒 March 6 CGS Federal (Contact Government Services) 51 - 200 🤝 B2B 🔒 Cybersecurity Website LinkedIn All Job Openings Power BI Developer responsible for creating data models and analytics for a Federal agency. Collaborating with IT team and utilizing Microsoft cloud technologies for government innovation. 🏢🏡 Boston – Hybrid 💵 $104.8k - $142.3k / year ⏰ Full Time 🟢 Junior 🟡 Mid-level 📊 Business Intelligence Developer View More Business Intelligence Developer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLSQL Server 2016SSISSSRSOLAPdata modelingdatabase scriptsstored proceduresBI reportingdata management

Soft Skills

communicationanalyticalproblem solvingproject managementinterpersonalteamworkindependenceflexibilitycreativityadaptability