ROLES & RESPONSIBILITIES

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

document business rules, and translate business needs into effective reporting and analytical solutions.
- Design, develop, and maintain Power BI dashboards, reports, scorecards, semantic models,

datasets, and measures using Power BI, DAX, Power Query, and related tools.
- Create meaningful visualizations and data stories that highlight trends, exceptions, root causes,

opportunities, and recommended business actions.
- 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.
- 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.
- Investigate data discrepancies, identify root causes, maintain KPI and data definitions, and coordinate corrective actions with technical and business teams.
- 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.
- Support the migration of Excel-based reports and manual processes to governed Power BI solutions while improving report usability, performance, consistency, and adoption.
- Lead requirement discussions, user acceptance testing, solution walkthroughs, and stakeholder presentations.



Communicate complex technical and analytical topics clearly to non-technical audiences.
- Prepare and maintain requirements documents, technical specifications, data dictionaries, test cases, user manuals, and process documentation. Mentor junior analysts and promote consistent analytical practices.
- Evaluate practical applications of AI and generative AI to improve analysis, reporting,

documentation, automation, and business workflows.

Required Qualifications

- Bachelor’s or Master’s degree in business administration, Data Analytics, Computer Science,

Information Systems, Engineering, Statistics, Economics, Finance, or a related field.
- Minimum 5 years of experience in business analysis, business intelligence, data analytics,

reporting, or a related discipline.
- Strong hands-on experience with Power BI, including dashboard development, DAX, Power

Query, data modeling, semantic models, and Power BI Service.
- Strong SQL skills, including joins, subqueries, aggregations, reconciliation, and data validation.
- Advanced Excel skills, including Power Query, Power Pivot, PivotTables, complex formulas, and data analysis.
- Practical knowledge of dimensional modeling, star schemas, data warehousing, ETL processes,

data cleansing, and data-quality validation.
- Experience researching and validating business, market, competitor, customer, or industry data from public and licensed third-party sources.
- Solid analytical, problem-solving, root-cause-analysis, communication, presentation, and stakeholder-management skills.
- Ability to independently manage projects from requirements gathering through implementation, documentation, and user adoption.
- Ability to work independently and in a team environment

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