Business Intelligence (BI) Architect (Remote)

Beth Israel Lahey Health

5d•Remote

About The Position

The Business Intelligence (BI) Architect is a member of Beth Israel Lahey Health’s (BILH) Enterprise Data and Analytics team. This role uses HealthCare Domain knowledge to assist and work closely with the leadership team in designing, architecting, and developing Business Intelligence solutions catering to the current landscape across multiple Epic hospitals and bringing the BI solutions together to serve the Enterprise. The Business Intelligence (BI) Architect is responsible for designing and optimizing the enterprise data and analytics ecosystem, with a focus on healthcare clinical and financial data sourced from Epic systems and others. This role blends deep expertise in data modeling, data warehousing, data integrity, data quality, and enterprise reporting using tools such as Power BI. The BI Architect will serve as a technical leader in building scalable, governed, and high quality data solutions that support financial, clinical, operational, and strategic decision making. When you add AI experience into the mix, the role expands into modern, advance intelligent analytics - leveraging machine learning, automation, and advanced data modeling to elevate BI capabilities. The BI Architect collaborates with Analytics Business Partners, Data Architects, Technology Leads, Developers, and stakeholders, while also guiding analysts, engineers, and report writers. Success in this role requires strong business, architectural, and technical skills to deliver solutions that balance both business needs and technology capabilities.

Requirements

Bachelor’s degree is required.
10+ years of related work experience is required in Business Intelligence, Analytics Frameworks and Data Architecture.
Minimum of 5 years of experience in EPIC analytics products.
Proficiency in SQL and ETL/ELT tools.
Experience designing and supporting Power BI or similar BI platforms
Experience working in a healthcare or clinical analytics environment

Nice To Haves

Experience in Advanced Analytics, Data Science, AI/ML is a plus.

Responsibilities

Design and maintain conceptual, logical, and physical data models supporting clinical, operational, and financial analytics.
Lead the design and development of enterprise data warehouses, data marts, dimensional models, and analytic semantic layers optimized for reporting and self‑service analytics.
Architect and support data solutions built on Epic Clarity and Caboodle, and related data sources.
Partner with Epic analysts, clinical informatics, and data engineering teams to understand data structures, workflows, and integration points.
Support the development of financial, clinical, quality reporting, and operational reporting and dashboards.
Ensure accurate extraction, transformation, and mapping of Epic clinical system data into enterprise data warehouses and reporting environments.
Prepare and manage data for AI/ML training, inference, and automation.
Oversee ETL/ELT pipelines to ensure efficient, reliable, and well‑documented data movement.
Design and implement modern data warehousing technologies (cloud or on‑prem).
Establish and maintain data quality frameworks, validation rules, and monitoring processes.
Ensure data accuracy, completeness, consistency, and timeliness across clinical and operational domains.
Translate business and clinical requirements into scalable data structures aligned with industry best practices.
Collaborate with data governance teams to define metadata, lineage, and master data standards.
Architect and support enterprise reporting solutions using Power BI and other BI tools.
Provide guidance to analysts and business users on best practices for dashboard design and data consumption.
Collaborate with clinical, operational, and technical teams to deliver end‑to‑end analytics solutions.