Power BI Lead

Weekday AI (YC W21); Gurugram District; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

Weekday AI (YC W21) seeks an experienced BI Analytics engineer to design, develop, and optimize Power BI reports, dashboards, and KPI scorecards. The role focuses on building SSAS models, data warehouse alignment, and complex DAX calculations.

The candidate will connect to diverse sources, implement data integration, and ensure robust row-level security, governance, and scalable analytics for stakeholders and clients.

Qualifications

• Experience designing and maintaining Power BI reports, dashboards and KPI scorecards.
• Experience building Analysis Services models and optimizing data warehouses.
• Ability to connect to diverse data sources, transform data and implement DAX calculations.
• Ability to architect reporting solutions and translate requirements into analytics.
• Knowledge of row-level security and data governance in BI platforms.
• Ability to optimize dashboards and queries for large datasets.
• Collaboration with UX/UI teams to create impactful visuals.
• Ability to engage stakeholders and deliver client-focused analytics outputs.

Responsibilities

• Design, develop and maintain Power BI reports and dashboards.
• Build and optimize Analysis Services models for data warehouses.
• Connect to and transform data from multiple sources using DAX and M.
• Architect reporting solutions from client requirements.
• Implement row-level security and ensure data governance.
• Optimize performance for large datasets and multiple reports.
• Collaborate with UX/UI to craft impactful visualizations.
• Engage stakeholders to deliver tailored analytics outputs.

Skills

Power BI

SQL performance

DAX calculations

SSAS/SSRS/SSIS

Data modeling

Row-level security

Data integration

Database design

PowerApps

Education

Bachelors in CS/IT

Power BI Certification

Azure Data Engineer

Tools

SSAS

SSRS

SSIS

Power BI Service

Job description

Job Description:

This role is for one of Weekday’s clients

Min Experience: 7+ years
Location: Bengaluru, Karnataka, India, Pune, Gurgaon, Haryana, India
JobType: full-time

Experience Range: 7 to 10 years of hands‑on experience in Power BI, SQL, and PowerApps, including practical exposure to BI engineering projects

Key Responsibilities:

• 1. Design, develop, and maintain Power BI reports, dashboards, and KPI scorecards to deliver actionable insights for business stakeholders
• 2. Build and optimize Analysis Services reporting models, ensuring compatibility with data warehouse standards and supporting both tabular and multidimensional models
• 3. Connect to diverse data sources, import and transform data for business intelligence, and implement advanced calculations using DAX to enhance reporting accuracy
• 4. Architect reporting solutions based on client requirements, translating wireframes and requirement documents into scalable analytics solutions
• 5. Implement and manage row-level security, integrating analytics with data governance, quality, and security platforms to ensure compliance and data protection
• 6. Optimize dashboard and query performance to efficiently handle large and multiple datasets, ensuring timely delivery of analytics outputs
• 7. Collaborate with UX/UI teams to design impactful visualizations, leveraging Power BI product capabilities for enhanced user experience
• 8. Engage with internal and external stakeholders to understand business challenges, deliver tailored analytics solutions, and ensure high-quality client outputs

Required Skills:

• 1. Power BI Desktop, Power BI Premium, Power BI Server, and Power BI Services
• 2. SQL and query performance tuning
• 3. DAX for advanced calculations
• 4. Microsoft Business Intelligence Stack (SSAS, SSRS, SSIS)
• 5. Data modeling for BI and ETL development
• 6. Row-level security implementation in Power BI
• 7. Connecting, importing, and transforming data from multiple sources
• 8. Multidimensional and relational database design
• 9. PowerApps and Power Automate

Preferred Skills:

• 1. Experience in supply chain domain analytics
• 2. Azure Synapse and MS SQL DB
• 3. Data extraction, ingestion, and processing of large distributed datasets
• 4. Leading large-scale data warehousing and analytics projects
• 5. Python for data analysis and exploratory data analysis

Desired Qualifications:

• 1. Bachelors degree in Computer Science, Information Technology, Data Analytics, or a related discipline
• 2. Microsoft Certified: Data Analyst Associate (Power BI)
• 3. Microsoft Certified: Azure Data Engineer Associate or equivalent certification in SQL/Business Intelligence

Must-have skills

• PBI, SQL, SSIS

Good-to-have skills

• Power App, Data Modeling, Python