Business Intelligence (BI) Architect (Remote)

Beth Israel Lahey Health

20h•$140,005 - $188,428•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 leverages HealthCare Domain knowledge to assist leadership in designing, architecting, and developing Business Intelligence solutions across multiple Epic hospitals and for the entire Enterprise. The BI Architect is responsible for designing and optimizing the enterprise data and analytics ecosystem, with a primary focus on healthcare clinical and financial data sourced from Epic systems and other platforms. This position requires 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, building scalable, governed, and high-quality data solutions that support financial, clinical, operational, and strategic decision-making. The role also encompasses modern, advanced intelligent analytics by leveraging AI experience, including machine learning, automation, and advanced data modeling. The BI Architect collaborates with Analytics Business Partners, Data Architects, Technology Leads, Developers, and stakeholders, while also providing guidance to analysts, engineers, and report writers. Success in this role demands strong business, architectural, and technical skills to deliver solutions that effectively balance business needs with 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.