Business Analyst with Power BI

Role Summary

Drive data-informed decision making by translating business needs into clear 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.

Key Responsibilities

- Requirements & Analysis
- Lead workshops, interviews, and process mapping (BPMN) to capture business goals, KPIs, and pain points.
- Produce BRDs/FRDs, user stories, acceptance criteria, and process/data flow diagrams.
- Perform gap, feasibility, and costbenefit analyses; conduct root-cause analysis using data.

- Data & BI Delivery

- Define metrics and data contracts; translate KPIs into semantic models and datasets.
- Build Power BI dashboards and paginated reports with robust DAX measures and Power Query (M).
- Design star/snowflake models; optimize relationships, aggregations, and query performance.
- Implement row-level security (RLS), certified datasets, and deployment pipelines in Power BI Service.
- Manage workspaces, gateways, refresh schedules, and versioning; coordinate releases and UAT.





- Governance & Quality

- Establish data definitions, dictionaries, and lineage documentation.
- Partner with data engineering on ETL/ELT, ensuring data integrity, security, and compliance.
- Define test plans, validate results, and maintain runbooks and support SOPs.

- Stakeholder Management & Adoption

- Act as a bridge between business, product, and engineering; prioritize backlogs (Jira/Azure DevOps).
- Deliver training, usage guidance, and change management to drive self-service analytics.
- Present insights and recommendations with clear storytelling.

Experience Required:

- 47 years as a Business/Systems Analyst
- Minimum 2+ years of hands-on experience with Power BI

Key Skills:

- Solid Power BI skills:
- DAX
- Power Query (M)
- Data modeling (star schema)
- Performance tuning
- Row-Level Security (RLS)

- Proficient in SQL:

- Joins
- CTEs
- Window functions
- Data profiling

- Experience across the BI lifecycle in Agile/Scrum environments

- Jira / Azure DevOps / Confluence

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