Business Intelligence Analyst Lead

Johns Hopkins Medicine; Baltimore (MD); On-site; USD 90,000 - 120,000; Full time

Job summary

Johns Hopkins Medicine in Baltimore seeks a data analytics professional to generate insights and perform root cause analyses. The role builds and maintains dashboards and provider-facing reports to inform decision-making, using SQL Server, ADF/Databricks, and Power BI modeling and reporting tools.

Reports to a Data Trust Analytic Team Leader or equivalent. Candidates bring a bachelor's degree and at least five years in healthcare analytics or related fields, with strong communication, data

Qualifications

• Bachelor's Degree in computer science, informatics, information systems, data science, business, supply chain, engineering, or related field (Required)
• One year of relevant education may substitute one year of work experience or vice versa
• Minimum 5 years of experience in healthcare technology, analytics, software development, or data management (Required)
• Navigate rapidly changing situations by remaining flexible and learning continuously
• Excellent written and verbal communication with confidentiality and diplomacy
• Work assignments involve moderately complex issues
• Strong attention to detail and data integrity
• Uphold confidentiality and informed consent in decisions
• Collaborate across diverse teams for patient-centered care
• Assist colleagues in following compliance procedures
• Identify and mitigate low-level compliance risks
• Decide with general guidance and may influence department strategy
• Address varied problems using observation and general knowledge
• Apply in-depth IT knowledge to complex tasks
• Broad IT knowledge and large-scope assignments
• Contribute to departmental cost-saving initiatives
• Proficiency with Microsoft Office (Excel, PowerPoint, Word, Outlook)
• Expertise in designing and optimizing SQL, ETL, and data pipelines
• Architect reusable BI solutions with semantic models and versioned code
• Advanced knowledge of EHR/EMR data structures and clinical informatics
• Expertise in data governance and HIPAA compliance
• Transform large data and reconcile source systems with reports
• Lead root cause analyses and drive improvement initiatives
• Design and maintain advanced dashboards and visualizations
• Influence cross-functional stakeholders to gather requirements and adoption
• Translate analytical findings into executive recommendations

Responsibilities

• Generate insights and perform root cause analyses.
• Build and maintain dashboards and provider-facing reports to inform decision-making.
• Work with SQL Server, ADF/Databricks, and Power BI modeling and reporting tools.
• Collaborate with clinical, operational, finance, and population health teams to gather requirements and drive adoption.
• Translate complex findings into clear executive recommendations.

Skills

Advanced SQL

ETL development

Data modeling

Data governance

Root cause analysis

HIPAA compliance

Cross-functional collaboration

Analytical thinking

Communication skills

Data quality assurance

Education

Bachelor's degree in a related field

Tools

Power BI

SQL Server

Databricks

ADF

Excel

Job description

JOB SUMMARY:

This role is responsible for generating insights and conducting root cause analyses. This role also builds and maintains dashboards and provider-facing reports to inform decision-making. Work is performed using SQL Server, ADF/Databricks, and Power BI modeling and reporting tools. Works under the direct or indirect supervision of a Data Trust Analytic Team Leader or other data governance or analytic leadership appropriate for the scope of work.

QUALIFICATIONS:

• Bachelor's Degree in computer science, informatics, management of information systems, data science, business, supply chain, engineering, or a related field (Required)


• One year of relevant education may be substituted for one year of required work experience or one year of relevant professional-level work experience may be substituted for one year of required education.


• Minimum 5 Years of Experience in healthcare technology, analytics, software development, or data management (Required)


• Navigate rapidly changing situations, from evolving patient needs to technological advancements, by remaining flexible, continuously learning, embracing new challenges, and quickly recovering from setbacks.


• Excellent written and verbal communication skills with an emphasis on confidentiality, tact, and diplomacy.


• Work assignments involve moderately complex issues.


• Strong attention to detail and self-directed to consistently ensure data integrity and accuracy.


• Uphold ethical principles by maintaining confidentiality, ensuring informed consent, and making decisions that prioritize the well-being of both patients and staff.


• Work seamlessly within diverse teams, bringing together professionals from various disciplines to provide patient-centered care and achieve collective goals.


• Assists colleagues in understanding and adhering to compliance procedures.


• Proactively identifies and mitigates low-level compliance risks within their area of responsibility.


• Makes decisions that are guided by general instructions and practices requiring some interpretation; may make recommendations for solving problems of moderate complexity and importance.


• May begin to influence department strategy.


• Addresses problems that are varied, requiring analysis or interpretation of the situation using direct observation, knowledge, and skills based on general precedents.


• Applies in-depth and/or broad knowledge, skills, and practices to perform a variety of difficult assignments in Information Technology.


• Comprehensive, in-depth or broad knowledge of Information Technology.


• Works on assignments of large scope, impact, and/or importance.


• Participates in and contributes to departmental cost-saving initiatives.


• Intermediate proficiency and experience using Microsoft Office Package (Excel, PowerPoint, Word, Outlook).


• Expertise in designing and optimizing complex SQL, ETL processes, and data pipelines; proficiency with BI tools to build and maintain enterprise data warehouses.


• Expertise in architecting reusable BI solutions and semantic models, including metric definitions, versioncontrolled code, and documentation standards.


• Advanced knowledge of EHR/EMR data structures, clinical informatics, and medical terminology to define, validate, and interpret performance measures (numerators/denominators/exclusions, value sets).


• Expertise in data governance and regulatory compliance (HIPAA), including developing and enforcing enterprise processes for metric certification, secure data access, and standardized reporting definitions.


• Ability to perform complex data transformation, large-scale validation, and reconciliation between source systems and reports.


• Ability to lead root cause analyses and integrate continuous improvement methods (e.g., run charts, PDSA) to translate analytics into prioritized operational and clinical interventions.


• Proficiency in designing, implementing, and maintaining advanced dashboards and visualizations that clearly communicate key metrics and trends.


• Ability to influence and collaborate with cross-functional stakeholders (clinical, operations, finance, population health) to gather requirements, align definitions, and drive adoption.


• Ability to translate complex analytical findings into clear executive recommendations