BI Data Architect

Carnegie Hall, 881 7th Avenue, New York, New York, United States of America

Posted Friday, February 6, 2026 at 5:00 AM

Since 1891, New York's Carnegie Hall has set the international standard for excellence in performance, presenting exceptional concerts by the world’s finest artists on its three iconic stages, from orchestral concerts, chamber music, contemporary offerings, and recitals to jazz, world, and popular music. Complementing its performance activities, Carnegie Hall’s Weill Music Institute creates extensive music education and social impact programs that annually serve more than 800,000 people worldwide, playing a central role in fulfilling Carnegie Hall's commitment to making great music accessible to as many people as possible.

Title of Position: BI Data Architect

Reports to Position: Director, BI & Web Development

The BI Data Architect is a strategic leadership role responsible for architecting and advancing Carnegie Hall’s data ecosystem. This position ensures that data is a trusted, governed asset for decision‑making across the organization, driving innovation and empowering business users.

The role oversees the design, deployment, and management of the department’s data infrastructure and integrations to support current and future initiatives. It requires exceptional technical expertise, analytical thinking, and experience navigating complex organizational structures, combined with strong communication skills to foster collaboration across stakeholder groups.

• Design, deploy, and manage the department’s data architecture, including data inventories, ingestion, ETL/ELT processes, and warehouse/data lake design.
• Establish and enforce robust data governance standards for storage, consumption, integration, and management; translate these principles into scalable, functional data models aligned with organizational objectives.
• Implement systems and monitoring to ensure data quality, accuracy, performance, and security
  .
• Develop data governance schema, documentation and policies that meet business standards.

• Champion the use of Microsoft Fabric and Power BI for unified analytics, reporting, and self‑service BI.
• Focus on designing, building, and managing data pipelines and lake houses using Microsoft Fabric's tools (Pipelines, Dataflows, Notebooks) to move data through Bronze (raw ingestion), Silver (cleaned/enriched), and Gold (curated for BI/analytics) layers.
• Collaborate with analysts to translate data architecture into end‑user dashboards and provide technical oversight to ensure adherence to governance standards.
• Drive adoption of API‑first architecture to support scalability and modernization.

• Contribute to the roadmap for architecture changes and future initiatives, aligning with organizational goals.
• Evaluate existing data and analytics stack for best practices, security, and performance; recommend improvements.
• Provide mentorship and technical leadership to staff on data architecture, integration, and pipelines.
• Explore emerging tools and technologies to enhance data visualization, integration, and analytics capabilities.
• Support reactive stakeholder incidents and ensure timely resolution.
• Promote self‑service enablement for business users.
• Knowledge and curiosity around AI enablement, including an understanding of how data architecture, governance, and data quality directly support machine learning and generative AI use cases.

• Bachelor’s degree or equivalent work experience.
• 5–10 years of experience in data architecture
  .

• Experience with Azure Data Factory
  , Azure Data Lake Storage
  , and Azure Storage Explorer for orchestration and data management.
• Knowledge of Azure API Management for API lifecycle governance, security, and versioning during migrations.
• Expertise in Power BI for enterprise reporting and integration with governed data models.
• Expertise with Microsoft Fabric for unified analytics and orchestration of data pipelines.
• Advanced knowledge of T‑SQL and Azure
  .
• Expertise with SSRS
  , Power BI
  , and modern data reporting tools.

• Strong understanding of data…