BI Data Architect

Job description

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. Department: Business Intelligence 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. PRIMARY RESPONSIBILITIES & DUTIES: Data Architecture & Governance ◦ 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. • Integration & API Management ◦ Manage API governance to deliver reliable integrations. ◦ 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. • Innovation & Continuous Improvement ◦ 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: • Education & Experience ◦ 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 ◦ Programming skills in Python (and optionally JavaScript and C#) for data engineering and automation. ◦ 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.