Senior Business Intelligence Developer – Rev Cycle-Remote

Mayo Clinic•Rochester, MN

1d•Remote

About The Position

Uses advanced Business Intelligence tools, cloud technologies, and statistical software to assemble, manipulate, and format data for actionable insights. Maintains and optimizes Business Intelligence models to design, develop, and generate both standard and ad-hoc reports and dashboards for internal and external customers to support business performance monitoring and decision-making. Works within established controls to ensure the accuracy, timeliness, and confidentiality of all reports, views, dashboards, analyses, and user data. Adheres to development standards and protocols including change management, code review, documentation, and testing. Educates and advises internal customers on how to leverage available data for consumption. Develops, maintains, reviews, and explains data models while staying current with business operations and Business Intelligence processes. Builds relationships with Business Intelligence partners to understand data needs and execute with excellence on documented user requirements and prototypes. Demonstrates strong SQL skills with extensive experience in developing Business Intelligence solutions. Designs, develops, and troubleshoots extract, transform and load processes that implement complex programming logic. Extracts operational, performance, statistical, and other data from various information systems, but primarily Epic. Develops and delivers reports, dashboards, and visualizations that clearly communicate insights. Manages multiple tasks simultaneously and responds quickly to problems, translating concepts and directions into practical solutions. Possesses development experience with relational and multi-dimensional database structures, data warehouse design architecture, and modern cloud platforms. Performs data development and integration using Google Cloud services such as BigQuery, and Dataflow, as well as Microsoft Fabric technologies including OneLake, lakehouses, pipelines, and semantic models. Determines Business Intelligence and data warehousing solutions to meet business needs and identifies and resolves data reporting issues in a timely manner.

Requirements

Bachelor's degree and a minimum of 8 years' revenue cycle, system, or data delivery experience required.
Previous healthcare experience required.
Requires knowledge and experience in reporting and analytics delivery software, such as Business Objects, Crystal Reports, SQL Server Management Studio, Tableau or Epic Cogito reporting framework.
Requires knowledge of database and data structure in regard to reporting efficiencies.
Must be customer-service oriented, able to respond promptly to requests, manage multiple priorities, work independently, and demonstrate strong problem-solving and leadership skills.
Epic Certification is required within first year of job acceptance.

Nice To Haves

Master's degree preferred.
Epic Cogito Certification is preferred.
Healthcare Financial Management Association (HFMA) Certification Preferred.
Experience with cloud-based data development in Google Cloud (BigQuery, Cloud Storage, Dataflow), Microsoft Fabric (OneLake, lakehouses, pipelines) and AI technology is highly desirable.
Experience with AI-driven analytics or machine learning applications is a plus.
Preferred knowledge of physician and hospital billing systems for governmental, managed care, and commercial payers.

Responsibilities

Assemble, manipulate, and format data for actionable insights using advanced Business Intelligence tools, cloud technologies, and statistical software.
Maintain and optimize Business Intelligence models to design, develop, and generate both standard and ad-hoc reports and dashboards for internal and external customers to support business performance monitoring and decision-making.
Work within established controls to ensure the accuracy, timeliness, and confidentiality of all reports, views, dashboards, analyses, and user data.
Adhere to development standards and protocols including change management, code review, documentation, and testing.
Educate and advise internal customers on how to leverage available data for consumption.
Develop, maintain, review, and explain data models while staying current with business operations and Business Intelligence processes.
Build relationships with Business Intelligence partners to understand data needs and execute with excellence on documented user requirements and prototypes.
Demonstrate strong SQL skills with extensive experience in developing Business Intelligence solutions.
Design, develop, and troubleshoot extract, transform and load processes that implement complex programming logic.
Extract operational, performance, statistical, and other data from various information systems, but primarily Epic.
Develop and deliver reports, dashboards, and visualizations that clearly communicate insights.
Manage multiple tasks simultaneously and responds quickly to problems, translating concepts and directions into practical solutions.
Perform data development and integration using Google Cloud services such as BigQuery, and Dataflow, as well as Microsoft Fabric technologies including OneLake, lakehouses, pipelines, and semantic models.
Determine Business Intelligence and data warehousing solutions to meet business needs and identifies and resolves data reporting issues in a timely manner.