ROLES & RESPONSIBILITIES

1. Partner with business stakeholders to understand objectives, gather requirements, define KPIs,

document business rules, and translate business needs into effective reporting and analytical

solutions.

2. Design, develop, and maintain Power BI dashboards, reports, scorecards, semantic models,

datasets, and measures using Power BI, DAX, Power Query, and related tools.

3. Create meaningful visualizations and data stories that highlight trends, exceptions, root causes,

opportunities, and recommended business actions.

4. Write and optimize SQL queries for data extraction, validation, reconciliation, and analysis.

Perform data profiling, cleansing, transformation, ETL validation, and quality checks across

multiple data sources.

5. Conduct structured research using public web sources, industry publications, market intelligence

platforms, and approved third-party paid data sources. Validate source credibility, data

accuracy, and relevance before using the information for business analysis.

6. Investigate data discrepancies, identify root causes, maintain KPI and data definitions, and

coordinate corrective actions with technical and business teams.

7. Identify repetitive or error-prone processes and use Python, Power Query, Power Automate,

VBA, or other suitable tools to improve efficiency, accuracy, and turnaround time.

8. Support the migration of Excel-based reports and manual processes to governed Power BI

solutions while improving report usability, performance, consistency, and adoption.

9. Lead requirement discussions, user acceptance testing, solution walkthroughs, and stakeholder

presentations. Communicate complex technical and analytical topics clearly to non-technical





audiences.

10. Prepare and maintain requirements documents, technical specifications, data dictionaries, test

cases, user manuals, and process documentation. Mentor junior analysts and promote

consistent analytical practices.

11. Evaluate practical applications of AI and generative AI to improve analysis, reporting,

documentation, automation, and business workflows.

Required Qualifications

1. Bachelors or Master’s degree in business administration, Data Analytics, Computer Science,

Information Systems, Engineering, Statistics, Economics, Finance, or a related field.

2. Minimum 5 years of experience in business analysis, business intelligence, data analytics,

reporting, or a related discipline.

3. Strong hands-on experience with Power BI, including dashboard development, DAX, Power

Query, data modeling, semantic models, and Power BI Service.

4. Strong SQL skills, including joins, subqueries, aggregations, reconciliation, and data validation.

5. Advanced Excel skills, including Power Query, Power Pivot, PivotTables, complex formulas, and

data analysis.

6. Practical knowledge of dimensional modeling, star schemas, data warehousing, ETL processes,

data cleansing, and data-quality validation.

7. Experience researching and validating business, market, competitor, customer, or industry data

from public and licensed third-party sources.

8. Strong analytical, problem-solving, root-cause-analysis, communication, presentation, and

stakeholder-management skills.

9. Ability to independently manage projects from requirements gathering through

implementation, documentation, and user adoption.

10. Ability to work independently and in a team workplace

📌 Senior Business Analyst (Bengaluru)
🏢 MSI services
📍 Bengaluru