Senior Business Intelligence Developer

Site : Mass General Brigham Incorporated

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.

Job Summary

At Mass General Brigham Digital, we pride ourselves on our ability to create maximum strategic, clinical, and operational value from established and emergent technologies for our patients, care teams, researchers, and employees. Digital health will not only enhance the equity and efficiency of healthcare delivery, but it will also help make medicine more personalized and precise. We recognize that increasing value and continually improving quality while maintaining an inclusive focus are essential to organizational excellence, and we invite you to join us on this journey. The work we do in Digital is a strategic imperative, and there is a strong and growing understanding of how together we will transform Mass General Brigham in innovative and impactful ways.

As a Senior BI Analyst / Developer certified in Epic Cogito, you will play a pivotal role in providing analytics insights and developing data solutions to support clinical and business operations. Collaborating closely with various stakeholders, your responsibilities span from gathering requirements and performing qualitative and quantitative analyses to designing, developing, and maintaining complex reports and databases.

You'll serve as an Epic subject matter expert, leveraging tools like Clarity, Caboodle, and Snowflake, among others, to create visually appealing and digestible data presentations. Additionally, you'll mentor team members, contribute to process improvement, and stay abreast of emerging technologies to ensure optimal performance. Your expertise in Epic Cogito and associated technologies, coupled with strong communication and problem-solving skills, will drive the success of multiple projects and initiatives.

The Senior BI Analyst / Developer, Epic Cogito Certified will report to the Cogito Analytics Manager.

Principal Duties and Responsibilities :

• Collaborate with stakeholders to understand and address analytic and reporting needs across clinical and business operations.
• Gather user requirements and translate them into well-designed and validated BI solutions using tools such as Cogito SQL, Clarity, Caboodle, and SlicerDicer.
• Develop, test, and implement reports, dashboards, and analytics solutions primarily utilizing Epic Cogito Data and Analytic Platform, Snowflake, and SQL Server.
• Create and edit Stored Procedures, Views, Functions and Queries on SQL Server to pull require data for reporting purposes using SQL Server Management Studio.
• Develops dynamic reports enabling the end users to define numerous parameters that allow users to filter and aggregate as required. Also creates custom reports that allow end users to drill down for more detail.
• Configure and create packages for report distribution using Microsoft SQL Server Business Intelligence Development Studios Integration Services.
• Serve as a resource and mentor for Analyst / Developers, sharing best practices, providing training, and fostering a culture of continuous learning.
• Maintain and improve processes related to data gathering, analysis, and reporting, ensuring accuracy, reliability, and data quality.
• Work with end-users to provide technical support, troubleshoot issues, and optimize software performance.
• Stay current with emerging software technologies and industry trends to recommend enhancements and innovations.
• Coordinate with internal and external stakeholders throughout the project lifecycle to ensure timely and successful delivery of analytics solutions.
• Provide expertise in relational databases, report writing tools, and Epic data models, contributing to the development and maintenance of complex reports and databases.
• Document detailed specifications, conduct unit testing, and provide end-user support for analytics solutions.
• Participate in on-call coverage
• Maintain confidentiality with regard to sensitive data.
• Adhere to organizational standards and apply communication, analytical, and problem-solving skills to identify and resolve system issues.

Qualifications

Bachelor's degree in Computer Science or related field. Equivalent experience may be accepted in lieu of degree.

Certification in Epic Cogito Fundamentals and relevant data models.

5+ years of experience required in healthcare data analytics or SQL reporting, preferably with electronic medical records systems.

Skills, Abilities and Competencies

Proficiency in SQL, relational database concepts, and report writing tools such as Crystal Reports, Business Objects, or Tableau.

Strong interpersonal, communication, and critical thinking skills.

Ability to work independently, manage multiple projects, and adapt to a changing environment.

Commitment to continuous improvement, personal growth, and collaboration.

Proficiency in Microsoft Office applications

Understanding of clinical and business operations workflows and system configurations

Excellent written and verbal communication skills

Strong project management and organizational skills

Detail oriented and experienced in leading projects from initiation to completion

Attentive and intellectually curious, possessing the will and perseverance to aid and resolve issues

Comfortable organizing and leading discussions with a broad range of end-users and / or leadership

Experience with ITIL service desk functionality

Proficiency in SQL, Windows and MS Office 365, familiarity with ServiceNow, Microsoft ADO, Workfront or similar tools

Uses critical thinking to develop content

Ability to work effectively in a complex and agile environment while remaining flexible and adaptable

High-energy, high-impact, team-oriented professional that builds strong working relationships

Demonstrates fiscal responsibility by effectively using Mass General Brigham resources

Working Conditions :

This position is hybrid : 1-3x a week onsite, M-F Eastern Business Hours, with planned onsite workshops or meetings at Assembly Row offices. Local travel to MGB sites, vendors, or conferences.

Additional Job Details (if applicable)

Remote Type

Hybrid

Work Location

399 Revolution Drive

Scheduled Weekly Hours

40

Employee Type

Regular

Work Shift

Day (United States of America)

Pay Range

$92,102.40 - $134,056.00 / Annual

Grade

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 :

Mass General Brigham Incorporated is an Equal Opportunity Employer. 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. To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veteran’s Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants who require accommodation in the job application process may contact Human Resources at (857)-282-7642.

Mass General Brigham Competency Framework

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.