Polestar Solutions - Power BI Solution Architect - ETL Platforms

Description :

Job Title : Power BI Architect

Location : Noida

Job Type : Full-time

Experience : 7+ years

Industry : IT Services & Analytics

Job Description :

Roles & Responsibilities :

- 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 :

- 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 :

- 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 Organizations products or assets.

Preferred Skills :

- 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.