Business System Analyst - Power BI

Kumaran Systems; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Kumaran Systems in India seeks a Business/Systems Analyst to translate business needs into Power BI solutions, from discovery to deployment. You will own the end-to-end analytics lifecycle, including data modeling, dashboard development, governance, and user adoption.

Ideal candidates have 4–4 years in analytics with 2+ years hands-on Power BI, strong SQL, and excellent communication to collaborate with product and engineering teams.

Qualifications

• 4–4 years of experience as a Business/Systems Analyst, with at least 2 years in Power BI.
• Strong Power BI skills: DAX, Power Query, data modeling, RLS.
• Proficient SQL and data profiling; experience in Agile/Scrum.
• Excellent communication and stakeholder management.

Responsibilities

• Lead workshops to capture goals, KPIs, and pain points.
• Create BRDs/FRDs, user stories, acceptance criteria, data flows.
• Define metrics, build Power BI dashboards and reports with DAX.
• Ensure data governance, security, and deployment pipelines.

Skills

Power BI

SQL

Agile/Scrum

Communication

Education

Bachelors in IS/CS/Eng

Tools

Jira

Azure DevOps

Confluence

Power BI Desktop

Job description

Job Description:

About Us

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what’s possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don’t just solve problems, we engineer future-ready transformations.

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 cost–benefit 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.

Required Qualifications

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

Preferred Qualifications

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

Success Metrics (KPIs)

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

Education

• Bachelor’s degree in Information Systems, Computer Science, Engineering, or related field; MBA a plus.