Lead / Senior Power BI Data Analyst

Location:
Anywhere in India; Nagpur preferred

Experience:
5+ years Employment Type: Full-time We are looking for an experienced Lead / Senior Power BI Data Analyst with solid expertise in Power BI, data modeling, database schemas, and backend data systems. The ideal candidate should be comfortable owning BI solutions end-to-end—from understanding business requirements and designing data models to developing dashboards, optimizing queries, and working closely with backend/data engineering teams.

Key Responsibilities
• Design, develop, and maintain sophisticated Power BI dashboards and reports for business and operational analytics.
• Build scalable and well-structured data models, schemas, relationships, and semantic layers.
• Develop complex calculations using DAX, Power Query, and M.
• Work extensively with SQL databases, data warehouses, APIs, and backend data sources.
• Write and optimize complex SQL queries, stored procedures, views, and transformations.
• Understand source systems and translate raw data into reliable reporting datasets.
• Develop efficient ETL/ELT pipelines and collaborate with data engineering/backend teams.
• Ensure dashboard performance, data accuracy, consistency, and scalability.
• Implement appropriate Row-Level Security (RLS), user permissions, and data-access controls.
• Troubleshoot data discrepancies and perform root-cause analysis across frontend reports and backend systems.
• Define Power BI development standards, naming conventions, documentation, and deployment practices.
• Lead dashboard architecture and technical design reviews.




• Mentor junior analysts and Power BI developers.
• Work directly with business stakeholders to understand KPIs and translate requirements into actionable analytics.
• Manage deployment across development, test, and production environments. Required Skills Power BI expertise is mandatory. Candidates should have strong hands-on experience with:
• 5+ years of experience in BI, data analytics, or related roles
• Power BI Desktop and Power BI Service
• Advanced DAX
• Power Query / M
• Data modeling and dimensional modeling
• Excellent communicator and can take ownership to lead a team.
• Star and snowflake schemas
• SQL and relational databases
• Database design and backend data structures
• ETL/ELT concepts
• Data warehouses and data marts
• Performance optimization
• Power BI Gateway
• Row-Level Security
• Data validation and reconciliation
• APIs and multiple data-source integrations Experience with technologies such as SQL Server, Azure SQL, PostgreSQL, Snowflake, Databricks, Microsoft Fabric, Azure Data Factory, or similar platforms is preferred. Preferred Qualifications
• Experience leading Power BI or BI development projects
• Experience working with large datasets and enterprise applications
• Strong understanding of backend/database architecture
• Experience building executive and operational dashboards
• Microsoft Power BI a plus
• Experience mentoring or managing junior BI developers
• Ability to communicate directly with U.
S. or international stakeholders
• Candidates based in Nagpur are strongly preferred, although qualified candidates from anywhere in India are encouraged to apply.

📌 Lead Data Analyst (India)
🏢 SalVentureTech
📍 India