Power BI Architect
Tredence · Kolkata · onsite · Posted 65d ago
Undisclosed8–13 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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 efficient 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 (BigQuery) OR Snowflake
- Solid understanding of:
- Data warehousing concepts
- Data modeling (dimensional modeling)
- ETL/ELT processes
Advanced Knowledge
- Composite models, DirectQuery, Import mode optimization
- Incremental refresh and large dataset management
- Power BI REST APIs and deployment pipelines
- Integration with tools like Azure DevOps / Git
Sourced from naukri
Skills
power querydaxArchitectCapacity PlanningFabriccloud platformArchitectural Designpower Bi adminPower BiSQLETLData ModelingSemantic Model
About Tredence
Tredence
IT Services & Consulting
2.3k+
employees
2013
13 years old
Bangalore / Bengaluru, Karnataka
India
About
Tredence is a data science solutions and AI solution provider, focuses on bridging the gap between insight creation to deliver business impact with scalable AI engineering and analytics solutions.
Industries
IT Services & ConsultingConsulting
Employee ratings
709 reviews
3.3/ 5
Culture
3.4
Career growth
2.8
Work-life
2.9
Employees rate it well for
Work Life Balance149Learning121Senior Management75Salary75Work Culture69
Find them on