Power BI Solution Architect

Polestar Analytics; Dadri; On-site; INR 1,200,000 - 1,500,000; Full time

Job summary

A leading analytics firm is seeking an experienced Power BI Architect to design and implement enterprise-level Power BI architecture. The role involves leading the BI solution lifecycle and collaborating with various stakeholders to develop robust reporting solutions. The ideal candidate should have over 7 years of experience, with expert-level proficiency in Power BI and strong SQL skills. This is a full-time position primarily based in Uttar Pradesh, India.

Qualifications

• Proven expertise in SQL and data warehouse design.
• Experience with Power BI administration and tenant setup.
• Strong communication and stakeholder management skills.

Responsibilities

• Design and implement Power BI architecture that meets business needs.
• Lead BI solution lifecycle, including data modeling and report design.
• Ensure data security, compliance, and effective mentoring of teams.

Skills

Power BI Desktop

DAX

Power Query (M)

SQL (T-SQL or PL/SQL)

Data governance

Cloud platforms (Azure)

Data modeling

CI/CD pipelines

Education

7+ years of experience in Business Intelligence

Expert-level proficiency in Power BI

Tools

Azure Data Factory

Azure Synapse

SQL Server

Job description

Job Title

Power BI Architect

Location

Noida

Job Type

Full-time

Experience

7+ years

Job Description

• Design and implement enterprise-level Power BI architecture that aligns with business intelligence strategy and data governance standards.
• Lead the end-to-end BI solution lifecycle including requirements gathering, data modeling, ETL, report design, deployment, and support.
• Define and enforce Power BI architecture standards, best practices, and governance models (naming conventions, folder structures, RLS/OLS, refresh strategies, etc.).
• Collaborate with business leaders, data engineers, data scientists, and analysts to design scalable reporting solutions and analytical frameworks.
• Architect robust, scalable data models and datasets optimized for performance, scalability, and maintainability.
• Design and oversee data integration pipelines using tools like Azure Data Factory, Synapse Analytics, SQL Server, or other ETL platforms.
• Manage Power BI tenant administration, including workspace strategy, licensing, gateway configuration, and capacity planning.
• Guide and mentor development teams on DAX optimization, Power Query (M), and Power BI service features.
• Ensure data security and compliance, including implementation of Row-Level Security (RLS), Object-Level Security (OLS), and data classification.
• Stay ahead of emerging technologies like Microsoft Fabric, AI integrations, and real-time analytics, and identify opportunities for adoption.

Required Technical and Professional Expertise

• 7+ years of experience in Business Intelligence, with at least 5 years in Power BI development and architecture.
• Expert-level proficiency in Power BI Desktop, Power BI Service, DAX, Power Query (M), and advanced visualization techniques.
• Strong knowledge of enterprise data modeling (star/snowflake schema, normalized/denormalized models).
• Proven expertise in SQL (T-SQL or PL/SQL), data warehouse design, and ETL tools.
• Experience with cloud platforms (especially Azure) including Azure Synapse, Data Factory, Azure SQL, ADLS, etc.
• Deep understanding of Power BI administration, including workspace governance, tenant setup, capacity management, and usage monitoring.
• Familiarity with CI/CD pipelines, source control (Git), and DevOps practices for BI solutions.
• Demonstrated experience with data governance, security, compliance, and metadata management.
• Strong communication and stakeholder management skills, with experience presenting to C-level executives.

Professional Skills

• Expertise in engaging with stakeholders across the organization to gather detailed requirements and translate them into scalable, robust BI solutions.
• Ability to understand the strategic needs of the business and recommend data-driven solutions that align with organizational goals.
• Proven ability to lead and mentor junior Power BI developers, providing guidance on best practices, troubleshooting, and optimization techniques.
• Strong leadership skills to manage end-to-end BI project lifecycle and ensure timely delivery of projects.
• Strong communication skills to effectively present complex data findings and insights to non-technical stakeholders, including executives and business leaders.
• Ability to create clear, compelling presentations and reports that drive business decision-making.
• Advanced problem-solving skills to troubleshoot complex data issues, optimize reporting processes, and improve user experience.
• Ability to think critically about the business impact of data and recommend actionable insights.
• A proactive attitude toward staying current with the latest Power BI features, industry trends, and advancements in data analytics.
• Provide innovative ideas and contribute in Organization’s products or assets.
• Preferred Skills Experience integrating Power BI with Power Platform (Power Automate, Power Apps).
• Working knowledge of Microsoft Fabric and Real-Time Streaming in Power BI.
• Hands-on experience with Big Data technologies and cloud-based data lakes.
• Experience implementing Self-Service BI frameworks within large enterprises.
• Microsoft certifications such as PL-600 (Power Platform Solution Architect) or DP-500 (Azure Enterprise Data Analyst) are highly desirable.
• Leadership experience managing BI teams, solution architects, or data engineering squads.
• Knowledge of data storytelling, UX design principles, and executive dashboarding.

Seniority Level

Mid-Senior level

Employment Type

Full-time

Job Function

Information Technology

Industries

IT Services and IT Consulting