Business Intelligence Engineer at Mass General Brigham Health Plan

Posted in Other 15 days ago.

Location: Somerville, Massachusetts

Job Description:

About Us:

As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.

Our employees use the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

General Summary/ Overview:

Mass General Brigham Health Plan is an exciting place to be within the healthcare industry. As a member of Mass General Brigham, we are on the forefront of transformation with one of the world's leading integrated healthcare systems. Together, we are providing our members with innovative solutions centered on their health needs to expand access to seamless and affordable care and coverage.

Our work centers on creating an exceptional member experience - a commitment that starts with our employees. Working with some of the most accomplished professionals in healthcare today, our employees have opportunities to learn and contribute expertise within a consciously inclusive environment where diversity is celebrated.

We are pleased to offer competitive salaries, and a benefits package with flexible work options, career growth opportunities, and much more.

Reporting to the Manager of BI and Analytics, this position is responsible for supporting the organization and end user community in the use of data analytics and business intelligence tools.

Principal Duties and Responsibilities:

• Work directly with users to map business needs to DW/BI solutions centered on Microsoft, Big Data and Data Science technologies.

• Assess existing DW/BI solutions and strategies, incl. ETL framework, and recommend optimizations.

• Rapidly prototype and prove solutions using conceptual models, relational, OLAP, and NoSQL databases and help implement new enterprise apps.

• Analyze performance bottlenecks and recommend optimizations.

• Collaborate with a team of data architects and developers to implement the solutions.

• Mentor development teams on reporting architecture and best practices in report development.

• Maintain and apply technical knowledge and subject matter expertise in all Health Plan data stores and BI capabilities (incl. BI, data warehouse, reporting and analysis areas) to the business needs of customers.

• In partnership with the business units, design, prepare and execute test plans for BI and data mart implementations.

• Support the use and adoption of industry standard BI tools such as SSIS, SSRS, SSAS, SQL Server and stored procedures, Excel, PowerBI and Azure.

• Produce data sets for end users based on standard adopted data definitions and/or regulatory requirements and adhering to IT developments standards and best practices.

• Review and revise queries, SSIS packages & SSAS cubes, Dashboards, and Big Data solutions for performance issues.

• Recommend and implement effective data analysis strategies and solutions for data storage, data exploration, and data mining, documenting, and presenting solutions to data architects and management.

• Design and develop BI solutions for Health Plan's medical, pharmacy, and behavioral health plans, Clinical healthcare systems, and financial systems, working with the PMO to support large projects that include data mapping, conversions, and development.


• Bachelor's degree in computer science or in the equivalent field is required

• 5+ years of related experience in Business Intelligence, decision support, reporting and analysis experience is required.

• Experience with AI/Machine Learning and cloud technologies such as Python, Snowflake, Databricks and Azure is a plus.

• Healthcare and/or Insurance industry experience is preferred.

• Microsoft or relevant certification in Data Analytics or Business Intelligence is a plus.


• Perform ad hoc analytical requests and research projects.

• Possessing expertise in process and data modeling, IT planning methodologies and extensive knowledge of the enterprise's business and decision-making processes.

• Demonstrating skills in process and data modeling, knowledge of architectural development methodologies and IT planning methodologies

• Working collaboratively with other IT groups to ensure solid cross-functional decisions are made as a team.

• Providing support to large IT projects that include data mapping, conversions, and development.

• Assume lead responsibility and/or technical support for department development activities as requested, possessing expertise in system development life cycle (incl. both Waterfall and Agile methodologies).

• Develop collaborative working relationships with all business partners/departments, demonstrating effective communication and team building skills, and effectively translate business requirements into technical requirements.

• Work jointly with internal and external staff to achieve Health Plan's strategic goals and to develop approaches in support of the business unit's information needs.

• Coordinate with technical operations team to ensure smooth operations and business results.

• Represent Information Architecture & BI at change control and ensure that all scheduled releases have gone through an adequate test process and are documented before going to change control.

• Meet regularly with Manager of Information Architecture & BI to escalate issues, report status of requests, and identify opportunities for improvements.

• Build relationships with the business customers by spending time with them to understand their business and their challenges.

• Consider short-term and long-term goals and identify patterns that require a more holistic solution.

• Review BI/Data functional and technical requirements specifications for completeness and accuracy.

• Evaluate and clarify requests, offering alternative solutions where applicable, incl. self-service methods for retrieving requested information.

• Ensure completeness of the solution through testing and validation with the customer.

• Identify and overcome roadblocks and root causes, recommending and executing solutions.

• Coordinating the documentation of data definitions with business owners and ensuring the proper use of data when fulfilling information needs.

• Assisting customers in use of OLAP tools, extracting and collecting data for performing queries and writing reports. Reviewing queries for performance issues, making changes as needed.

• Participating in the requirements, design, and development of the reports as well as creation of user documentation.

• Making recommendations of reproducible OLAP models to support the end user community, providing requirements and scope documentation.

Fiscal Responsibility:

• No direct budgetary responsibility

• Demonstrates fiscal responsibility by effectively using Mass General Brigham Health Plan resources

Working Conditions:

• Normal office working conditions.

• Remote or Hybrid

EEO Statement

Mass General Brigham is an Equal Opportunity Employer. By embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.

More jobs in Somerville, Massachusetts

Massachusetts General Hospital(MGH)

Massachusetts General Hospital(MGH)

Mass General Brigham
More jobs in Other

Thomas & Hutton

Meharry Medical College

Ferrara Pan Candy Co., Inc.