Job Description

Business Analyst with Power BI

n

Role Summary

n

Drive data-informed decision making by translating business needs into transparent requirements and scalable Power BI solutions. You will own the end-to-end analytics lifecycle—from discovery and requirement gathering to data modeling, dashboard development, governance, and user adoption.

n

Key Responsibilities

n

n
- Requirements & Analysis
n
- Lead workshops, interviews, and process mapping (BPMN) to capture business goals, KPIs, and pain points.
n
- Produce BRDs/FRDs, user stories, acceptance criteria, and process/data flow diagrams.
n
- Perform gap, feasibility, and cost–benefit analyses; conduct root-cause analysis using data.
n
- Data & BI Delivery
n
- Define metrics and data contracts; translate KPIs into semantic models and datasets.
n
- Build Power BI dashboards and paginated reports with robust DAX measures and Power Query (M).
n
- Design star/snowflake models; optimize relationships, aggregations, and query performance.
n
- Implement row-level security (RLS), certified datasets, and deployment pipelines in Power BI Service.
n
- Manage workspaces, gateways, refresh schedules, and versioning; coordinate releases and UAT.
n
- Governance & Quality
n
- Establish data definitions, dictionaries, and lineage documentation.
n
- Partner with data engineering on ETL/ELT, ensuring data integrity, security, and compliance.
n
- Define test plans, validate results, and maintain runbooks and support SOPs.
n
- Stakeholder Management & Adoption
n
- Act as a bridge between business, product, and engineering; prioritize backlogs (Jira/Azure DevOps).
n
- Deliver training, usage guidance,



and change management to drive self-service analytics.
n
- Present insights and recommendations with clear storytelling.
n

n

Required Qualifications

n

n
- 4–7 years as a Business/Systems Analyst, including 2+ years hands-on with Power BI.
n
- Strong Power BI skills: DAX, Power Query (M), data modeling (star schema), performance tuning, RLS.
n
- Proficient SQL (joins, CTEs, window functions) and data profiling.
n
- Experience with BI lifecycle in Agile/Scrum environments (Jira/Azure DevOps/Confluence).
n
- Excellent communication, facilitation, and stakeholder management skills.
n

n

Preferred Qualifications

n

n
- Exposure to Azure analytics stack (Azure SQL, Synapse, Data Lake, Data Factory) or equivalent.
n
- Knowledge of APIs/REST/JSON, ETL/ELT concepts; familiarity with Git-based workflows.
n
- Tools: DAX Studio, Tabular Editor, ALM Toolkit; experience with Power BI Premium features.
n
- Certifications: Microsoft PL-300 (Power BI Data Analyst), PSM/CSPO, IIBA CCBA/CBAP.
n
- Nice-to-have: Python/R for analytics, statistics, Power Automate/Power Apps, embedded analytics.
n
- Domain experience in [BFSI/Healthcare/Retail/Manufacturing/etc.].
n

n

Success Metrics (KPIs)

n

n
- Report adoption and satisfaction (usage growth, NPS).
n
- Cycle time from request to deployment; backlog throughput.
n
- Data quality and refresh reliability; reduction in manual reporting hours.
n
- Performance benchmarks (e.g., <3s median visual/DAX query time).
n
- Self-service enablement (share of certified datasets, reuse rate).
n

n

Education

n

n
- Bachelor's degree in Information Systems, Computer Science, Engineering, or related field; MBA a plus.
n

📌 Business Analyst with Power BI Developer (Chennai)
🏢 Kumaran Systems
📍 Chennai