Business Analyst with Power BI Developer

Kumaran Systems; Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Kumaran Systems in Chennai seeks a Business Analyst with Power BI to translate business needs into scalable analytics, owning the end-to-end BI lifecycle from discovery to governance.

You will build Power BI dashboards with DAX, Power Query, and data modeling (star schema), and ensure performance with optimized relationships and RLS.

Collaborate with product and engineering in Agile/Scrum, manage backlogs in Jira/Azure DevOps/Confluence, and drive self-service analytics adoption.

Qualifications

• Minimum 2+ years hands-on Power BI experience.
• Strong Power BI, DAX, Power Query, data modeling skills.
• Proficiency in SQL and data profiling.

Responsibilities

• Lead requirements & analysis, including workshops and BRDs/FRDs.
• Build Power BI dashboards and paginated reports with robust DAX measures.
• Establish governance, data dictionaries, and lineage documentation.
• Collaborate with stakeholders to drive self-service analytics and adoption.

Skills

Power BI

DAX

Power Query (M)

Data modeling

Performance tuning

Row-Level Security (RLS)

SQL

Jira/Azure DevOps/Confluence

Agile/Scrum

Tools

Power BI Service

Star schema

Job description

Business Analyst with Power BI

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:

• Strong 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