Senior Business Analyst

Msi Services; Bengaluru; In loco; INR 1.200.000 - 2.400.000; Tempo pieno

Descrizione del lavoro

MSI Services in Bengaluru seeks a senior BI Analyst to design and maintain Power BI dashboards and semantic models, translating business requirements into actionable analytics.

You'll write SQL queries, develop data stories, profile data, and ensure data quality across multiple sources. Collaboration with stakeholders and mentoring junior analysts are key parts of the role. The position emphasizes independent work and team collaboration in a dynamic analytics environment.

Competenze

• Experience in business analysis, BI, data analytics, or reporting.
• Proficient with Power BI dashboard development and DAX.
• Strong SQL skills for joins, subqueries, data validation.
• Advanced Excel skills including Power Query and PivotTables.
• Knowledge of dimensional modeling, data warehousing, and ETL processes.
• Experience sourcing data from public and licensed sources.
• Strong analytical, problem-solving, and stakeholder management.
• Ability to manage projects from requirements to adoption.

Mansioni

• Partner with business stakeholders to understand objectives and translate needs into reporting solutions.
• Design, develop, and maintain Power BI dashboards, reports, and semantic models.
• Create meaningful visualizations highlighting trends, root causes, and actions.
• Write and optimize SQL queries for data extraction and analysis.
• Profile data, perform cleansing, ETL validation, and data-quality checks.

Conoscenze

Power BI

SQL

Excel

Data Modeling

DAX

Stakeholder Management

Formazione

Masters in Analytics

Bachelor's in CS/IT

Strumenti

Power BI

SQL Server

Power Query

Excel

Python

Descrizione del lavoro

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.
• 5. Perform data profiling, cleansing, transformation, ETL validation, and quality checks across multiple data sources.
• 6. 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.
• 7. Investigate data discrepancies, identify root causes, maintain KPI and data definitions, and coordinate corrective actions with technical and business teams.
• 8. 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.
• 9. Support the migration of Excel-based reports and manual processes to governed Power BI solutions while improving report usability, performance, consistency, and adoption.
• 10. Lead requirement discussions, user acceptance testing, solution walkthroughs, and stakeholder presentations. Communicate complex technical and analytical topics clearly to non-technical audiences.
• 11. Prepare and maintain requirements documents, technical specifications, data dictionaries, test cases, user manuals, and process documentation. Mentor junior analysts and promote consistent analytical practices.

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 environment