Power BI Architect

Persistent

8–12 yrs Pune Full Time Hybrid (office + remote)
Persistent logo
Posted : today
Actively hiring

Job description

Join Persistent as an experienced Power BI Architect and lead the design and implementation of enterprise-scale Business Intelligence solutions. This role is pivotal in supporting a significant MicroStrategy to Power BI migration program. You'll leverage your extensive Power BI and SQL Server expertise, combined with strong solution architecture, technical leadership, and client-facing skills, to define BI architecture standards and drive migration initiatives.

Our AI-led, platform-driven approach empowers clients with unique competitive advantages. We collaborate with industry leaders across various sectors, including 18 Fortune 50 companies. Persistent is recognized for innovation and leadership, fostering a dynamic environment that sustains our growth. Our global team of over 29,500 professionals across 21 countries is instrumental in transforming industries.

Responsibilities

You will analyze existing MicroStrategy reports and metadata to craft effective Power BI migration strategies. Designing and owning end-to-end BI and Analytics architectures using Power BI and SQL Server will be key. Responsibilities include defining scalable semantic models, enterprise BI standards, and architecting advanced reports and dashboards.

Establishing architecture standards, governance frameworks, security models, and development best practices is crucial. You'll implement solutions using DAX, Power Query, and Row-Level Security, and lead migration planning, report rationalization, and effort estimation. Optimizing SQL Server databases and T-SQL queries for analytical workloads, along with defining performance strategies for reports and data refresh, are integral to this role.

Gathering requirements through workshops, conducting architecture reviews, and translating business needs into secure, scalable BI solutions are expected. You will provide technical leadership and mentoring to BI teams, acting as a liaison between offshore and onshore teams for seamless delivery execution. Managing technical risks and stakeholder expectations throughout the migration lifecycle is also part of your remit.

Qualifications

We seek candidates with 8 to 12 years of experience in Business Intelligence, Analytics, Reporting, or Data Warehousing solutions. Proven expertise as a Power BI Architect, BI Technical Lead, or Solution Architect is essential. Hands-on experience with Power BI Desktop, Power BI Service, Data Modeling, DAX, Power Query, Semantic Models, Dataflows, and Row-Level Security is required.

Extensive experience with SQL Server, T-SQL development, database design, and performance tuning is necessary. A strong grasp of enterprise BI architecture, reporting frameworks, governance models, and security implementation is vital. Experience in designing scalable data models and enterprise reporting solutions, coupled with a track record of leading BI migration and modernization programs (preferably MicroStrategy to Power BI), is highly valued.

Expertise in report optimization, performance tuning, and large-scale BI platform management is expected. Experience defining deployment standards, workspace strategies, security controls, and release management processes is important. A solid understanding of data warehousing concepts, dimensional modeling, and analytics architecture is beneficial. Excellent stakeholder management, client communication, presentation, and workshop facilitation skills, along with strong technical leadership and mentoring experience for distributed teams, are key attributes for success in this role.

Essential Skills

Power BISQL ServerDAXPower QueryRow-Level Security (RLS)DataflowsGatewaysDeployment PipelinesT-SQLDimensional ModelingAgileData WarehousingBusiness IntelligenceAnalyticsReportingData ModelingSemantic Models

Good to Have

MicroStrategyGitHub CopilotGenAI

Highlights

  • Actively hiring

More Details

RolePower BI Architect
IndustryFinancial Services, Healthcare
DepartmentData Science
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Persistent Systems logo

Persistent Systems

Financial Services

Power BI Architect at Persistent | SkillMX | SkillMX