Mass General Brigham relies on a wide range of professionals, including doctors, nurses, business people, tech experts, researchers, and systems analysts to advance our mission. As a not-for-profit, we support patient care, research, teaching, and community service, striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham.
The ideal candidate for this role can act as a backup to our SSAS developer but will be doing day to day work developing in Python and SQL to support Data Science/AI initiatives.
Job Summary
The OpportunityThe Sr Business Intelligence Developer Analytics Engineer will use Microsoft Business Intelligence tools, primarily Microsoft SSMS, SSAS, and SSIS to maintain BI data structures in support of operational, clinical, and financial analysis. Support Data Scientists on the team with Microsoft SQL queries, ETL processes and Python.
What You'll Do
- Supports BI Development and works with the data scientists to support and learn what they are doing
-Works with end users, analysts, technical staff, and team members to plan, designs, develops, implements, and enhances business intelligence capabilities using Microsoft Business Intelligence tools.
-Assists with maintaining and troubleshooting issues with existing cubes, queries and processes.
-Develops efficient Microsoft SQL queries and data processes for Data Scientists on the team in support of Machine Learning and Artificial Intelligence.
-Assists end users, as a subject matter expert on existing company data, processes and business intelligence tools.
-Create clear documentation for users and technical staff.
-Follows established change control and versioning policies as pursuant with company standards and best practices.
-Serves as project manager for relevant analytics projects, including meeting facilitation, resource management, and stakeholder expectation setting.
-Provide training and mentorship to team, and end users on key analytic and reporting systems and databases when necessary.
Qualifications
- Bachelor's Degree Computer Science required or Bachelor's Degree Information Systems required
- MGB can review and consider experience in lieu of a degree
- Experience as a business intelligence developer or a similar role 5-7 years required
- Python experience and SSIS highly preferred
- BI SSAS cube development experience
Skills for Success
- Proficiency in SQL and experience with relational databases (e.g., SQL Server, Oracle, MySQL).
- Exposure to Azure. The newer BI tools require some Python, like Azure Data Engineering certs require you to use python for data manipulation.
- Expertise in Microsoft Business Intelligence data engineering tools (SSMS, SSAS and SSIS) Expertise in business intelligence and data visualization tools such as Microsoft PowerBI or similar.
- Solid understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
- Knowledge of programming languages (e.g., Python, R) and statistical analysis techniques is a plus.
- Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
- Strong communication skills to effectively collaborate with stakeholders and present complex data insights in a clear and concise manner.
- Health Insurance industry experience is a plus.
Additional Job Details (if applicable)
Working Model
- M-F Eastern Business Hours Required
- A quiet, stable, secure, compliant work station is required
Remote Type
Work Location
Scheduled Weekly Hours
Employee Type
Work Shift
Pay Range
$92,102.40 - $134,056.00/AnnualGrade
7At Mass General Brigham, we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive, and any offer extended will take into account your skills, relevant experience if applicable, education, certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however, it does not encompass all elements contributing to your total compensation package. In addition to competitive base pay, we offer comprehensive benefits, career advancement opportunities, differentials, premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply, and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.
EEO Statement:
At Mass General Brigham, our competency framework defines what effective leadership “looks like” by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.
Top Skills
What We Do
Mass General Brigham is an integrated academic health care system, uniting great minds to solve the hardest problems in medicine for our communities and the world. Mass General Brigham connects a full continuum of care across a system of academic medical centers, community and specialty hospitals, a health insurance plan, physician networks, community health centers, home care, and long-term care services. Mass General Brigham is a nonprofit organization that is committed to patient care, research, teaching, and service to the community. In addition, Mass General Brigham is one of the nation’s leading biomedical research organizations and a principal teaching affiliate of Harvard Medical School.
