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

Memorial Healthcare

4d•Onsite

About The Position

This position analyzes complex business intelligence data to inform business decisions by evaluating datasets and creating reports, dashboards, and data extracts. The role covers all aspects of the Business Intelligence development lifecycle, including integrating new data sources, extracting and visualizing data, and assuring data quality. The analyst monitors and validates reports, analyses, recommendations, dashboards, and extracts; troubleshoots complex issues; performs root cause analysis; and takes preventive action. The role establishes and supports BI standards, policies, documentation, consistent report and dashboard templates, and appropriate handling of sensitive data. It provides analysis and recommendations to leaders, serves as a subject matter expert for reports and dashboards, and mentors analysts in presenting and delivering content. The position maintains knowledge of assigned departments’ analytics, data models, applications, tools, workflows, customers, competitors, professional organizations, and regulations. It collaborates with teams to identify changes that may affect reporting and works with BI Developers when new data must be added to centralized models. The analyst also develops and promotes documentation and training resources and serves as a data steward for governance, standardization, management, and documentation.

Requirements

Bachelor’s degree in Computer Science is required; the posting also lists a bachelor’s degree in Computer Science, Accounting, Finance, Business, or a healthcare-related field as additional education information.
Three years of progressive work experience providing analytics, SQL queries, reports, and dashboards, and communicating findings and recommendations.
Experience with SSRS, Tableau, or Pyramid.
Expertise building complex SQL queries, with or without reporting or dashboard tools.
Ability to write SQL queries for reporting and data profiling, with an understanding of database design concepts and table joins.
Intermediate to advanced use of Microsoft Excel or Microsoft Access to analyze large datasets.
Ability to translate reporting requirements from clinicians, administrators, and support staff into technical specifications for IT developers.
Ability to test and validate reports and dashboards against source database data.
Excellent oral and written communication skills, critical thinking, effective communication, decisive judgment, and ability to work with minimal supervision.
Extreme attention to detail, particularly when producing analyses or validating complex healthcare datasets.
Strong organizational skills, ability to manage multiple tasks and changing priorities, and diligent follow-up on action items.
Ability to work in a stressful environment, take appropriate action when required, and build positive relationships and lead others.
Ability to work with MHS analytics tools and applications, including SSRS, Tableau, and/or Pyramid.

Nice To Haves

Experience using EHR and/or payer claims data.
Experience with business intelligence or reporting tools such as Tableau, Microsoft SSRS, or Epic Cogito Tools.
Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Information Systems, or a closely related field, plus three years of experience in the job offered or as a Data Analyst.

Responsibilities

Proactively monitor departmental reports, analyses, recommendations, dashboards, and data extracts; troubleshoot complex issues, perform root cause analysis, and take preventive action.
Create and maintain test scripts, analytics, and algorithms for validation and integrated testing; ensure reports and extracts continue to work after workflow changes or software upgrades.
Maintain expertise in Memorial Healthcare System and industry standards for reporting, analysis, dashboards, and data extraction; help enforce and maintain departmental BI standards, policies, and procedures.
Document mappings for automated data extracts in accordance with applicable standards, governance, policies, and procedures.
Design and develop consistent report and dashboard templates, promote their use, and ensure compliance; ensure sensitive data is properly displayed, delivered, and secured.
Provide analysis, insights, and recommendations to company leaders and mentor analysts in content presentation and delivery.
Maintain knowledge of analytics and related models, applications, tools, workflows, customers, competitors, professional organizations, and regulations for assigned departments.
Communicate with teams about upcoming regulations, value-based programs, workflow changes, and software upgrades that may affect reporting or centralized data models.
Collect BI data from industry reports, public information, field reports, or purchased sources; document specifications and work with BI Developers to add data to centralized models when needed.
Serve as a subject matter expert for reports and dashboards; lead their creation and perform analytics and recommendations using established tools and centralized data models.
Ensure the overall quality of departmental reports, analyses, and dashboards.
Develop documentation for analytics assets, including data catalogs, data dictionaries, troubleshooting guides, knowledge base articles, and data model diagrams.
Promote and share information and resources throughout MHS through training and workshops; participate in local user groups or meetings.
Act as a data steward, driving data and reporting governance, standardization, management, and documentation.