Senior Business Intelligence Developer, Epic Cogito Certified

Mass General Brigham - Somerville, MA

Full-time - Senior

Hybrid - Somerville, MA

Ambulatory Health Care Services

About the position

The Senior Business Intelligence Developer, Epic Cogito Certified 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 also includes mentoring team members and contributing to process improvements while leveraging technologies such as Epic Cogito, SQL, and Snowflake.

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 that allow filtering and aggregation as required.
• 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, 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.

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

• Comprehensive health insurance coverage.
• 401k retirement savings plan with matching contributions.
• Paid time off and holidays.
• Professional development opportunities and training programs.
• Flexible scheduling options for work-life balance.