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, plays a crucial role in providing analytics insights and developing data solutions to support clinical and business operations at Mass General Brigham. 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 creating visually appealing data presentations and mentoring team members.

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

• 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
• 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.

Benefits

• Competitive salary
• Comprehensive health insurance
• Retirement savings plan
• Paid time off
• Professional development opportunities
• Flexible work arrangements
• Employee wellness programs