Sr. Business Intelligence Architect

About the role

We are looking for an experienced Sr. Business Intelligence Architect to shape and advance enterprise reporting and analytics capabilities for a higher education environment in Philadelphia, Pennsylvania. This role will guide the design of secure, scalable data solutions, partner closely with technical and business stakeholders, and help establish strong standards for business intelligence delivery. The ideal candidate brings deep expertise in Microsoft BI technologies, a strategic mindset for architecture, and a proven background leading business intelligence excellence across an organization.

Responsibilities

• Architect enterprise-scale BI and analytics solutions using Microsoft Fabric technologies, including OneLake, Data Factory, Synapse, and Power BI.
• Build, refine, and support data models, ingestion workflows, and semantic structures that enable reliable analysis and reporting.
• Direct major data platform enhancement efforts, including initiatives involving modernization and migration to Microsoft Fabric.
• Work closely with analysts, engineers, and business partners to convert reporting goals into practical data architecture designs.
• Establish governance, design standards, and best practices to improve the quality, security, and scalability of BI solutions.
• Lead and mentor business intelligence teams or center-of-excellence functions to strengthen delivery consistency and technical capability.
• Develop reporting frameworks and dashboard strategies that provide stakeholders with clear, actionable insights.
• Evaluate existing BI environments and recommend architectural improvements that increase performance and long-term maintainability.

Requirements

• At least 7 years of experience in business intelligence, data architecture, or related analytics-focused roles.
• Bachelor’s degree in a technical field, data science, or a closely related discipline.
• Demonstrated experience leading and managing a Business Intelligence Center of Excellence within a current or previous organization.
• Strong hands-on expertise with Microsoft Power BI and broader business intelligence technologies.
• Proven ability to design secure and scalable data platforms using Microsoft Fabric components.
• Experience creating and maintaining data models, pipelines, and semantic layers for enterprise analytics.
• Solid knowledge of DAX and its application in advanced reporting and performance optimization.

Qualifications

• Proven leadership skills in guiding business intelligence initiatives.
• Strategic thinking and ability to translate business needs into effective data solutions.
• Experience with data warehousing, ETL processes, and data integration tools.
• Knowledge of SQL and other database management systems.
• Ability to communicate complex technical concepts to non-technical stakeholders.

Skills

• Microsoft Fabric technologies (OneLake, Data Factory, Synapse, Power BI).
• Data modeling and semantic layer development.
• Data governance and best practices implementation.
• BI tool proficiency (Power BI, Tableau, etc.).
• Modernization and migration strategies for data platforms.
• Project management and team leadership.
• Reporting framework and dashboard strategy development.
• Performance optimization and long-term maintainability considerations.

Benefits

Technology Doesn't Change the World, People Do.®

Pay

$100,000 - $150,000 USD Per Year

Schedule

Ongoing

Location

Philadelphia, PA