Senior Data Analyst

SalVentureTech; Nagpur City; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

SalVentureTech in Nagpur seeks a Power BI Analyst to design, develop, and maintain dashboards and reports for business and operational analytics. You will build scalable data models, semantic layers, and perform complex calculations.

The role requires strong SQL skills, mastery of DAX and Power Query, and the ability to translate requirements from stakeholders into actionable analytics. You will mentor junior team members and ensure performant, secure data delivery.

Qualifications

• 2+ years of experience in BI or data analytics.
• Power BI Desktop and Power BI Service proficiency.
• Advanced DAX and Power Query (M).
• Data modeling and dimensional modeling knowledge.
• SQL proficiency with data warehouses and marts.

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports.
• Build scalable data models, schemas, and semantic layers.
• Develop calculations using DAX, Power Query, and M.
• Work with SQL databases, data warehouses, and APIs.
• Write and optimize SQL queries, procedures, views, transformations.
• Translate requirements into reliable reporting datasets.
• Develop ETL/ELT pipelines with data engineering teams.
• Ensure dashboard performance, data accuracy, and scalability.
• Implement Row-Level Security and data-access controls.
• Troubleshoot data discrepancies and root-cause analysis.
• Define development standards and deployment practices.
• Lead architecture reviews and mentor junior BI developers.
• Collaborate with stakeholders to map KPIs to analytics.

Skills

Power BI

DAX

Analytical thinking

Communication skills

Problem-solving

Tools

Power BI Desktop

Power BI Service

SQL

Azure SQL

Databricks

Azure Data Factory

APIs

Job description

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.

• 2+ 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
• 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.

What We're Looking For

We need someone who is more than a dashboard developer. The candidate should understand how data is structured and generated at the backend and be capable of designing the complete analytical data flow.

The ideal candidate should be able to look at a complex database, understand the schema and relationships, determine how the information should be modeled, and then build an intuitive and high-performance Power BI solution on top of it.

Strong analytical thinking, problem-solving ability, ownership, and communication skills are essential.

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 or Fabric certifications are 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.