Senior Business Intelligence Developer

The Opportunity

We are seeking a Senior Business Intelligence Developer to join our team at Mass General Brigham. This position will be responsible for designing and maintaining solutions that support revenue cycle operations. The ideal candidate will have experience with Epic data model, SQL, and Tableau. This is an exciting opportunity to work closely with the revenue cycle team and play a key role in improving operational efficiency and financial performance.

The successful candidate will form relationships with leadership by becoming the go-to guide for data within their designated areas of expertise. The developer will collaborate their team members and more junior developers to ensure that appropriate technical and analytical solutions are provided to understand key business drivers including patient volume and reimbursement trends tied to financial performance through comprehensive reports, interactive dashboards, and ad hoc reporting tools

Role Duties

• Develop business intelligence solutions including financial analysis, revenue cycle reporting, and visually appealing dashboards.

• Gather requirements and provide technical guidance and support throughout the development process.

• Mentor and support junior-level developers with reporting, analysis, ad-hoc reporting and good methodology for development, design, and architecture.

• Takes initiative on optimally leading/driving team projects from start to finish as assigned

• Provide technical and business knowledge support to the team and external groups. Assume role of a domain expert in specific financial reporting areas and Epic workflows. Provide consultation and act as team lead on large scale projects.

• Develop SQL queries and data models to extract data from Epic and other sources and transform it into relevant insights and analytics.

• Create and maintain Tableau dashboards that deliver useful insights.

• Develop and maintain data pipelines that automate the data extraction, transformation, and loading (ETL) process.

• Test and validate the accuracy, completeness, and consistency of the data and reports.

• Document the design, development, and testing of the solutions.

• Provide technical support by identifying and solving technical and data issues and providing user training.

• Coordinates IT related activities (software upgrade, downtime) between the business office and external application teams (Cognos, Epic, central data analytics organization).

• Use/s the Mass General Brigham values to govern decisions, actions, and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

• Other duties and responsibilities as assigned

Qualifications

Education

• Bachelor's degree in computer science, information systems, or a related field

Work Experience

• Minimum of 5 years of experience in BI development, data analytics, and data modeling.

• Experience with Epic data models and Clarity data warehouse preferred.

• Experience with Tableau, including creating reports and dashboards, developing data sources, and administering Tableau Server is strongly preferred.

• Familiarity with ETL tools such as SSIS or Informatica.

• Experience with the healthcare revenue cycle, including patient access, billing, coding, and reimbursement

Skills And Abilities

• Deep technical skills in SQL and Tableau development.

• Strong SQL skills, including writing sophisticated queries, optimizing performance, and solving data challenges.

• Strong analytical skills.

• Excellent written and verbal communication skills.

• Ability to work independently and collaboratively in a fast-paced environment.

• Ability to translate business requirements into technical specifications.

• Strong analytical and problem-solving skills.

• Superb communication and interpersonal skills.

• Ability to learn quickly and adapt to new technologies and processes.

• Attention to detail and ability to deliver high-quality solutions.

• Strong organizational and time-management skills

• Supports and demonstrates the values of the organization by conducting activities in an ethical manner with integrity, honesty, and confidentiality.

• Shows a positive, open-minded, and can-do attitude.

• Demonstrates a team orientation and passion to collaborate

• Follows through on commitments and achieves desired results.

• Demonstrates fiscal responsibility by effectively using Mass General Brigham resources.