Mass General Brigham - Winter Hill, MA
posted 3 months ago
Full-time - Mid Level
Hybrid - Winter Hill, MA
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 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 that allow filtering and aggregation as required.
- 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.
- Flexible scheduling options.
- Professional development opportunities.
- Employee discounts on various services.
