BI Data Architect

Carnegie Hall Corporation; New York (NY); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Carnegie Hall Corporation in New York, NY, is seeking a BI Data Architect to lead and enhance its data architecture. This strategic role involves managing data governance and utilizing advanced tools like Microsoft Fabric and Power BI for analytics.

The ideal candidate will have 5–10 years of experience in data architecture, a bachelor’s degree, and strong communication skills. This position is in-office with a potential for hybrid scheduling after the initial three months.

Qualifications

• 5–10 years of experience in data architecture.
• Strong understanding of data governance and compliance frameworks.
• Ability to mentor technical teams while driving strategic initiatives.

Responsibilities

• Architect and manage Carnegie Hall’s data ecosystem.
• Design and deploy department’s data architecture.
• Champion Microsoft Fabric and Power BI for analytics.
• Provide mentorship on data architecture and pipelines.

Skills

Data architecture

Data governance

Power BI

Azure Data Factory

Microsoft Fabric

T-SQL

Communication skills

Education

Bachelor’s degree or equivalent work experience

Tools

Azure Data Lake Storage

Azure Storage Explorer

API Management

SSRS

Job description

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

Job Description

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

SUMMARY OF ROLE

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.

Analytics & Visualization

• 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 lakehouses 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.

Strategic Leadership

• 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.

REQUIREMENTS & QUALIFICATIONS

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

Technical Expertise

• 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.

Additional Skills

• Strong understanding of data governance, security, and compliance frameworks.
• Excellent communication and stakeholder engagement skills.
• Ability to mentor technical teams while driving strategic initiatives.

This is not a remote position. The role requires an in‑office start, with eligibility for a hybrid schedule at the manager’s discretion after the first three months.

To apply please submit a COVER LETTER with your resume.

Carnegie Hall is an equal opportunity employer, committed to diversity and inclusion in the workplace. Decisions concerning employment are made on the basis of an individual’s qualifications to contribute to meeting Carnegie Hall’s needs, and Carnegie Hall is committed not to discriminate against individuals on the basis of race, color, national origin, citizenship, religion, sex (including gender identity, gender expression or status of being transgender), sexual orientation, marital status, familial status, status as a caregiver, status as a victim of domestic violence or sex offenses or stalking, criminal convictions (except where otherwise permitted by law), arrest record, credit history, pregnancy, age, mental or physical disability, veteran or military status, reproductive health decisions, or any other characteristic protected by law.

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