SQL Database and Business Intelligence Developer II

{
  "content_hash": "766c21981c00f6e20663cf7046789536f4c34b9d92a39a030f8a4cc15a760281",
  "source_hash": "2ba9243a73aaf19e1ef19b48f8b8d05130ee6470d7b5c27f550902b650481d12",
  "last_changed_at": "2026-06-18T07:56:21.050Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "Boston, Massachusetts",
    "city": "Boston",
    "region": "MA",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.85
  },
  "salary_max": 105569,
  "salary_min": 94893,
  "inferred_at": "2026-06-20T07:56:09.400Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Boston, Massachusetts",
      "city": "Boston",
      "region": "MA",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.85
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "hybrid",
  "salary_period": "year",
  "workplace_type": "hybrid",
  "salary_currency": "USD"
}

{}

{
  "lists": [
    {
      "text": "Essential Functions and Responsibilities",
      "content": "<div>\n\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Design, develop, test, and implement changes and enhancements to SQL Databases as required</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">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</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Maintain and implement database objects, including tables, views, keys, indexes, constraints, defined types, functions, stored procedures, etc.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Code stored procedures of high complexity to meet product requirements</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various issues as they arise</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Maintain and manage database schemas, SQL agent jobs and user’s roles with proper permissions.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Troubleshoot database performance issues to ensure optimizations in system designs.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Manage code migration to various environments according to software development life cycle.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Maintain and write comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Support the operational strategies and priorities of the Authority.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Able to independently work with internal stakeholders to identify, gather business requirements, propose analytical report solutions and implement the proposed solutions.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Troubleshoot and resolve outages from existing applications.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Maintain quality service through IT policies and standards.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; benchmarking state-of-the-art practices; participating in professional societies.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Perform other duties as assigned</li>\n\n</div>"
    },
    {
      "text": "Required Knowledge and Skills",
      "content": "<div>\n\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Strong SQL Server 2016(and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Strong knowledge of relational and dimensional data modeling</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">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.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience in code migration, database change management and data management through the various stages of the development lifecycle</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">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</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Work with our team members and in-house QA to resolve bugs and issues.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience with versioning control environments including Azure DevOps and/or GIT</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Strong communication skills and the ability to work both independently and as part of a team</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Professional interpersonal style; ability to work and build trust with a diverse range of people</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Ability to work in an Agile environment.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Ability to work creatively, learn quickly and solve complex problems in high-pressure situations</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Exhibit a professional ‘can-do’ attitude and flexible work style approach</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Ability and willingness to proactively research and/or resolve issues</li>\n\n</div>"
    },
    {
      "text": "Preferred Knowledge and Skills",
      "content": "<div>\n\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Relevant Microsoft Certifications</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Masters in technical discipline</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience in Database Design and administration.</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience with cloud-based solutions</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience with VB.Net, ASP.Net and C#</li>\n<li style=\"font-size: 12pt; font-family: 'Times New Roman', serif;\">Experience with network/storage architecture</li>\n\n</div>"
    }
  ],
  "country": "US",
  "createdAt": 1781722492985,
  "updatedAt": null,
  "categories": {
    "team": "IT",
    "location": "Boston, Massachusetts",
    "commitment": "Full-Time Hybrid",
    "department": "Administration and Operations",
    "allLocations": [
      "Boston, Massachusetts"
    ]
  },
  "salaryRange": {
    "max": 105569,
    "min": 94893,
    "currency": "USD",
    "interval": "per-year-salary"
  },
  "workplaceType": "hybrid"
}