Senior Business Intelligence Developer, Epic Cogito Certified

Mass General Brigham - Somerville, MA

Full-time - Mid Level

Hybrid - Somerville, MA

5,001-10,000 employees

Ambulatory Health Care Services

About the position

The Senior BI Analyst/Developer at Mass General Brigham plays a crucial role in providing analytics insights and developing data solutions to support clinical and business operations. This position involves collaborating with various stakeholders to gather requirements, perform analyses, and design, develop, and maintain complex reports and databases. The role requires expertise in Epic Cogito and associated technologies, with a focus on enhancing healthcare delivery through data-driven solutions.

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 required data for reporting purposes using SQL Server Management Studio.
• Develop dynamic reports enabling end users to define numerous parameters for filtering and aggregating data.
• 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 Studios Integration Services.
• Serve as a resource and mentor for Analyst/Developers, sharing best practices and providing training.
• 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.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Health Administration, Health Sciences, or equivalent experience.
• Certification in Epic Cogito Fundamentals and relevant data models.
• 8+ years of experience in healthcare data analytics or SQL reporting, preferably with electronic medical records systems.
• 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.

Nice-to-haves

• Experience with ITIL service desk functionality.
• Familiarity with ServiceNow, Microsoft ADO, Workfront or similar tools.

Benefits

• Competitive salary and benefits package.
• Opportunities for professional development and continuous learning.
• Supportive work environment focused on personal growth and collaboration.