Senior Business Intelligence Developer - FT - Days - MHS

Memorial Healthcare

About The Position

This position analyzes complex business intelligence data to inform business decisions by evaluating datasets and creating reports, dashboards, and extracts using established tools and data sources. It is responsible for the Data Warehouse/Business Intelligence development lifecycle, including integrating new data sources, extracting and visualizing data, and performing data quality assurance. The role leverages expertise in EHR data, including Epic and other community EHR providers, to develop reports, dashboards, and extracts. It also develops models and algorithms to support contracting, required reporting, and innovation in healthcare data. The position provides analysis and reporting to decision-makers, supports end users and organizational leadership with meaningful analytics and insights, and contributes to improved business operations.

Requirements

Bachelor's degree in Information Technology is required; relevant work experience may substitute for the education requirement.
Four years of relevant work experience.
Progressive experience writing T-SQL queries and stored procedures.
Experience developing reports and extracts using BI tools, including SSMS, SSRS, and SSIS.
Advanced knowledge of database and data warehouse concepts and technologies, including data profiling and data modeling.
Working knowledge of data visualization tools such as Tableau, Pyramid Analytics, or Power BI.
Ability to think critically, exercise decisive judgment, work with minimal supervision, and take appropriate action in a stressful environment.
Specialized knowledge in a business line may be required.

Responsibilities

Create SQL stored procedures, views, and functions using best practices and efficient code.
Load data into the Data Warehouse by extracting complex data from multiple sources into business-centric Data Marts.
Validate and deliver high-quality data and BI solutions that enable user functionality with minimal ongoing maintenance and few production incidents.
Maintain and develop documentation for data sources and dashboards.
Provide quantitative and qualitative analysis and reporting on patterns, insights, and trends for decision-makers.
Communicate recommendations to end users on dashboard visualizations to optimize effective and efficient use of data, including recommendations beyond the original request when they enhance the utility of the data or dashboard.
Monitor and tune the performance of new and existing reporting and BI applications.
Support end users and organizational leadership in obtaining meaningful data, analytics, visualizations, and insights to assist decision-making and improve business operations.
Analyze and report on key information from EPIC Clarity data models, data warehouses, and other systems throughout the organization.
Integrate new data sources and perform data extraction, visualization, and quality assurance throughout the Data Warehouse/BI development lifecycle.
Develop EHR-based reports, dashboards, and extracts, as well as models and algorithms supporting contracting, required reporting, and healthcare data innovation.