Role: BI Architect

Experience - 8 - 13 years

Location: Bangalore, Chennai, Kolkata, Pune, Hyderabad, Gurgaon

Mode: Hybrid

Notice period: Immediate to 30 days

Key Responsibilities –

Architecture & Strategy
Design, build, and maintain end-to-end BI solutions, including dimensional data models and enterprise semantic layers (Power BI, Tableau, Looker)
Define KPIs, reporting standards, taxonomy, and dashboard design frameworks
Evaluate and integrate contemporary BI tools, cloud technologies, and analytics trends to ensure scalability and cost efficiency

Data Modeling & Engineering Collaboration
Develop robust dimensional models (Fact & Dimension tables, Star Schema)
Partner with Data Engineering teams to align ETL/ELT pipelines and data warehouse platforms (Snowflake, BigQuery, Redshift, Synapse)
Ensure high performance via query optimization, indexing, and partitioning strategies
Optimize data refresh strategies (incremental load, direct query, composite models).

Performance & Optimization
Identify and resolve report performance issues.
Optimize queries,



data models, and visuals.
Implement productive data refresh and caching mechanisms.

Governance, Security & Compliance
Implement enterprise-grade security frameworks including RLS, OLS, and RBAC
Establish data governance policies, metadata management, and business glossaries
Ensure data accuracy, lineage, and single source of truth across BI systems
Manage Power BI Service administration, capacity planning, and licensing.

Leadership & Enablement
Provide architectural leadership and technical guidance to BI teams
Mentor developers and promote best practices in modeling, DAX, and visualization
Drive adoption of BI best practices across the organization.

Technical Skills
Solid hands-on experience with:
Power BI (Desktop, Service, Gateway)
DAX, Power Query (M language)
SQL (advanced querying and optimization)
Experience with data platforms:
Azure (ADF, Synapse) OR GCP (BigQ

📌 Power Bi Architect Bengaluru
🏢 Tredence
📍 Bengaluru