Business Intelligence Architect

The BI Architect will be responsible for designing, architecting, and overseeing enterprise BI solutions that enable actionable insights, data-driven decision-making, and scalable analytics platforms. The role demands strong expertise in BI platforms, data modelling, data integration, and performance optimisation, along with the ability to lead design discussions and collaborate with business and IT stakeholders.

The candidate will have responsibilities across the following functions:

Architecture and Solution Design:

• Define end-to-end BI architecture, standards, and best practices.
• Design enterprise BI/analytics platforms, semantic models, and reporting frameworks.
• Architect scalable solutions across Data Warehouse, Data Lake, and Semantic Layers.
• Ensure architecture alignment with enterprise roadmap and cloud strategy.
• Evaluate tools, define technology stack, and govern design patterns.

Data Modelling and Engineering:

• Lead Dimensional Modelling, Star/Snowflake schemas, semantic model design.
• Define data ingestion, transformation, aggregation strategies.
• Optimise data pipelines for performance, scalability, and reliability.
• Establish metadata management and data lineage standards.

Platform and Tool Expertise:

• Architect and implement BI platforms (Power BI / Tableau / Qlik / Looker).
• Establish governance models, workspace strategies, access control, and security frameworks.
• Define self-service BI strategy and enablement.

Performance, Quality and Governance:

• Ensure high availability, performance optimisation, and query tuning.
• Define security, access control, row-level and object-level security.
• Govern solution quality through standards and best practices.
• Ensure compliance with data governance and security policies.

Stakeholder and Leadership:

• Work with business stakeholders to translate analytical needs into systems.
• Collaborate with Data Engineering, Cloud, and Application teams.
• Lead BI technical teams, review designs, mentor developers.
• Participate in estimation, planning, and roadmap development.

Requirements:

• 10+ years in Data/Analytics with 5+ years in BI architecture.
• Strong experience with o Power BI / Tableau / Qlik / Looker o Enterprise Data Warehousing o Semantic Models / Tabular Models.
• Expertise in Dimensional Modelling, Kimball/Inmon methodologies, Data & Integration.
• SQL expertise.
• Experience with ETL / ELT tools (ADF, SSIS, Informatica, Talend, etc. )
• Knowledge of Cloud Data Platforms: o Azure Synapse / Fabric o AWS Redshift o GCP BigQuery.
• Experience with Data Lakes & Lakehouse concepts, Platform & Governance.
• BI performance tuning.
• Security implementation.
• Data governance alignment.
• Dashboard & reporting standards.

Nice to Have:

• Cloud certifications (Azure / AWS / GCP).
• Experience with advanced analytics enablement.
• Experience in enterprise-scale global environments.
• Experience with GenAI-driven analytics insights (optional).

Skills Summary - BI Architect Technical Skills:

• BI Platforms: Power BI / Tableau / Qlik / Looker
• Data Platforms: Azure Synapse / Fabric / Redshift / BigQuery / Snowflake
• Modelling: Star/Snowflake, Semantic models, Tabular
• ETL/ELT: ADF, SSIS, Informatica, Talend
• SQL, DAX (if Power BI)
• Performance Optimization
• Security Architecture
• Data Governance integration Domain & Delivery
• Enterprise BI implementation experience
• Requirement to architecture translation
• Large-scale BI rollout governance
• Multi-stakeholder program delivery Behavioural
• Ownership mindset
• Executive communication
• Analytical & design thinking
• Collaboration & leadership

Skills

data warehouse, data warehousing, dwh, looker, power bi, qlik, sql, tableau