Business Intelligence Analyst Lead

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