Senior Business Intelligence Developer

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. You will collaborate closely with various stakeholders, gather requirements, perform qualitative and quantitative analyses, and design, develop, and maintain 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.

You’ll also 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.

• 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 Slicer Dicer.
• 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 required data for reporting purposes using SQL Server Management Studio.
• Develop dynamic reports enabling end users to define numerous parameters that allow filtering and aggregation as required, and create 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 Studio 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.

• 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,…