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 modern 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
- Strong 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