Senior Business Intelligence Developer
@ Mass General Brigham

Somerville, MA
$120,000
On Site
Full Time
Posted 8 hours ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXXX XXXXXXXXXXXXX XXXXXX****** @massgeneralbrigham.org
Recommended after applying

Job Details

Overview

Mass General Brigham Health Plan Holding Company, Inc. is looking for a Senior Business Intelligence Developer. At Mass General Brigham, a diverse team including doctors, nurses, tech experts, researchers, and analysts come together to drive exceptional patient care, research, and community service.

Job Summary

Utilize Microsoft Business Intelligence tools such as SSMS, SSAS, SSIS and PowerBI to develop and support operational, clinical, and financial analysis. Work with Data Scientists by developing efficient SQL queries and data processes to support machine learning and AI initiatives.

Essential Functions

  • Collaborate with end users, analysts, and technical staff to design and enhance BI capabilities.
  • Troubleshoot and maintain existing cubes, queries and processes.
  • Develop efficient SQL queries to support data science projects.
  • Document business intelligence processes and provide subject matter expertise.
  • Manage relevant analytics projects including meeting facilitation and resource management.
  • Provide training and mentorship on analytic and reporting systems.

Qualifications

Requires a Bachelor’s Degree in Computer Science or Information Systems. Five to seven years experience in business intelligence development or a similar role is required. Proficiency in SQL, Microsoft BI tools (SSMS, SSAS, SSIS, PowerBI), and understanding data warehousing concepts, dimensional modeling, and ETL best practices is essential. Knowledge in Python, R and statistical analysis is a plus. Experience in the Health Insurance industry is also beneficial.

Additional Details

This is a remote position with a scheduled 40-hour work week. Work location is listed as 399 Revolution Drive. Compensation is competitive and based on experience, along with comprehensive benefits, career advancement opportunities, and recognition programs.

Key skills/competency

  • Business Intelligence
  • SQL
  • PowerBI
  • SSMS
  • SSAS
  • SSIS
  • Data Warehousing
  • ETL
  • Data Visualization
  • Analytical Thinking
Apply without a personalized resume

How to Get Hired at Mass General Brigham

🎯 Tips for Getting Hired

  • Customize your resume: Tailor skills to Microsoft BI tools and SQL.
  • Highlight project management: Show examples of analytics projects.
  • Emphasize technical expertise: Detail SSMS, SSAS, and PowerBI experience.
  • Prepare for behavioral queries: Reflect on teamwork and communication.

📝 Interview Preparation Advice

Technical Preparation

Review Microsoft SQL Server documentation.
Practice complex query optimization techniques.
Familiarize with SSMS, SSAS, and SSIS.
Study ETL best practices and data warehousing.

Behavioral Questions

Discuss a past project challenge.
Explain teamwork in high-pressure settings.
Describe conflict resolution with stakeholders.
Share experiences mentoring team members.

Frequently Asked Questions