BI Architect - R01561945 (FCB)

Primary Skills

• MSBI (SSIS, SSAS, SSRS), SQL, Advanced Excel, Power BI, Power App, Azure Analysis Services, Synapse, Data Factory, Databricks

Specialization

• Power BI Architecture: BI Architect

Job requirements

• Experience:
• 9–12 Years Cloud Exposure: Azure (Preferred)
• Additional BI Exposure: Qlik / Tableau / Looker (Good to Have)
• Role Summary
• We are seeking a seasoned Power BI Architect to lead the design and implementation of enterprise-grade Business Intelligence solutions.
• This role requires deep expertise in Power BI architecture, data modeling, performance engineering, governance, and secure deployment within large-scale data warehouse ecosystems.
• The ideal candidate will combine strong technical depth with architectural thinking, stakeholder engagement capability, and experience operating within regulated enterprise environments.
• Key Responsibilities
• Architecture & Design Define and implement scalable Power BI architecture across Development, UAT, and Production environments.
• Design robust semantic models aligned with enterprise data warehouse standards.
• Establish best practices for data modeling, naming conventions, workspace governance, and deployment pipelines.
• Provide high-level design and effort estimation for BI initiatives.
• Data Modeling & Engineering Develop advanced DAX measures and optimized calculated columns.
• Build complex transformations using Power Query (M language).
• Design and implement Power BI Dataflows for centralized transformation logic.
• Optimize query performance through aggregation strategies, incremental refresh, and query folding.
• Integration & Deployment Manage report migration across environments using deployment pipelines.
• Configure and maintain On-Premises Data Gateways.
• Implement and manage Power BI Embedded solutions where applicable.
• Integrate BI systems with enterprise data sources including OLAP cubes, SQL Server, and cloud data platforms.
• Security & Governance Architect and implement Row-Level Security (RLS) and role-based access controls.
• Define enterprise-wide security frameworks aligned with Azure AD. Ensure compliance with data governance, audit, and regulatory standards. Performance & Optimization Conduct performance diagnostics for dashboards and datasets. Optimize SQL queries and backend data models for large-volume datasets.
• Implement scalable solutions for high concurrency and enterprise adoption.
• Stakeholder Engagement Collaborate with business stakeholders to translate analytical requirements into scalable BI solutions.
• Provide technical leadership and mentoring to BI developers. Identify automation opportunities to improve reporting efficiency and operational performance.
• Required Technical Expertise Power BI (Core Requirement) Power BI Service (Workspaces, Deployment Pipelines, Admin capabilities)
• Advanced DAX and data modeling principles Power Query (M language) Dataflows (Service-based transformations) Performance tuning and dataset optimization RLS and enterprise security implementation Gateway configuration and management
• Power BI Embedded architecture (preferred) Data & Database Expertise
• Strong SQL with complex joins, indexing, and performance tuning
• Experience with SSRS and SSIS In-depth knowledge of OLAP concepts
• Solid understanding of ETL/ELT frameworks Data warehousing design (Star/Snowflake schemas) Azure (Preferred) Azure Data Factory Azure Synapse Analytics Azure SQL Database Azure Data Lake Storage Azure Active Directory integration
• Other BI Tools (Good to Have) QlikView / Qlik Sense Tableau GCP Looker
• Familiarity with GCP analytics ecosystem Preferred Background Experience within Financial Services, Banking, or Asset Management environments. Exposure to regulatory reporting and secured data environments.
• Experience leading BI teams or architecting enterprise BI programs. Strong communication skills with the ability to engage both technical and business stakeholders.