Senior Business Intelligence Analyst - Decision Support - FT - Days - MSS

Memorial Healthcare•Rockville, MD

44d

About The Position

At Memorial, we are dedicated to improving the health, well-being and, most of all, quality of life for the people entrusted to our care. An unwavering commitment to our service vision is what makes the difference. It is the foundation of The Memorial Experience. Summary: This position is responsible for analyzing complex business intelligence data to inform business decisions by evaluating datasets, creating reports, dashboards and extracts for a variety of needs. This position is responsible for all aspects of the Business Intelligence (BI) development lifecycle, including the integration of new data sources, extraction and visualization of data, along with quality assurance of data.

Requirements

Bachelors: Computer Science (Required)
The role requires excellent oral and written communication skills.
The incumbent must have expertise building complex SQL queries with or without the use of reporting and/or dashboard tools.
The incumbent must be proficient with MHS analytics tools and applications including SSRS, Tableau and/or Pyramid.
This role requires critical thinking skills, effective communication, decisive judgment, and the ability to work with minimal supervision. The incumbent must be able to work in a stressful environment and take appropriate action when required.
Prior experience with business intelligence / reporting tools like Tableau, Microsoft SSRS, Epic Cogito Tools, etc.
Ability to write SQL queries for reporting and data profiling, including an understanding of database design concepts and table joins.
Intermediate to advanced use of Microsoft Excel or Microsoft Access to analyze large data sets.
Translating reporting requirements of clinicians, administrators, support staff into technical specifications for IT developers.
Extreme attention to detail, especially when producing analyses or validating complex healthcare datasets.
Strong organizational skills juggling multiple tasks simultaneously, flexibility to adapt to rapidly changing priorities, diligently follow up on action items for self and others.
Ability to test and validate reports and dashboards, especially against the source data in the database.
Must be able to build and foster positive relationships and lead others.
Three (3) years of progressive work experience in providing analytics, SQL queries, reports, dashboards, and communicating findings/recommendations.
Experience with SSRS, Tableau, or Pyramid.
Bachelor's degree in Computer Science, Accounting, Finance, Business or a healthcare related field.
Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Information Systems, or a closely related field plus three (3) years of work experience in job offered or as Data Analyst.

Nice To Haves

Experience using EHR and/or payer claims data.

Responsibilities

Responsible for proactive monitoring of all reports, analysis, recommendations, dashboards and data extracts for the department.
Leverages expertise to troubleshoot more challenging issues, performs root cause analysis, and takes preventive actions.
Creates and maintains test scripts, analytics and algorithms for validation and integrated testing.
Responsible for testing efforts, including making sure that existing reports and extracts continue to work well after workflow changes or software upgrades.
Maintains expertise with Memorial Healthcare System (MHS) and industry standards for reporting, analysis, dashboards, and data extracting.
Plays leading role in enforcing BI standards, policies and procedures within the department. Assists with maintenance of these standards.
Documents mappings for automated data extracts for the department following applicable standards, governance, documentation, policies and procedures.
Designs and develops templates for reports and dashboards that share consistent branding, look and feel. Promotes use of these templates and ensures compliance.
Ensures sensitive data is displayed, delivered and secured properly.
Provides analysis, insights and recommendations to leaders throughout the company. Mentors Analysts in content presentation and delivery.
Maintains expertise with analytics for assigned departments, including associated centralized data models, applications, tools, workflows, customers, competitors, professional organizations, and regulations.
Maintains regular communication with teams to stay up-to-date with upcoming regulations, value-based programs, workflow changes or software upgrades that may impact reports, analysis, dashboards or centralized data models.
Collects BI data from available industry reports, public information, field reports, or purchased sources; when needed, documents specifications and works closely with BI Developers to add data to centralized data models.
Serves as subject matter expert for all reports and dashboards.
Plays leading role in creating reports and dashboards and completing analytics and recommendations using established tools and centralized data models while creating and/or following applicable standards, policies and procedures.
Performs analytics. Responsible for overall quality of the department's reports, analysis and dashboards.
Plays leading role in developing documentation related to the analytics assets of the department, including data catalogs, data dictionaries, troubleshooting guides, knowledge base articles, and data model diagrams. Helps promote and shares available information and resources throughout MHS through training and workshops. Actively participates in local user groups or meetings.
Responsible data steward driving data and reporting governance, standardization, management and documentation.