Business System Analyst - Power BI

Posted 10 Days Ago
Be an Early Applicant
Chennai, Tamil Nadu, IND
In-Office
Senior level
Information Technology • Consulting
The Role
Own the full Power BI analytics lifecycle, including requirements gathering, process mapping, data modeling, dashboard and paginated report development, governance, security, deployment, testing, and user adoption. Translate business KPIs into semantic models and datasets, optimize DAX and query performance, coordinate Agile delivery and UAT, document data lineage and quality processes, and train stakeholders in self-service analytics.
Summary Generated by Built In
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–7 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.


Skills Required

  • 4-7 years of experience as a Business or Systems Analyst
  • At least 2 years of hands-on Power BI experience
  • Strong Power BI skills, including DAX, Power Query M, star-schema data modeling, performance tuning, and row-level security
  • Proficiency in SQL, including joins, CTEs, window functions, and data profiling
  • Experience with BI lifecycle delivery in Agile or Scrum environments
  • Experience with Jira, Azure DevOps, or Confluence
  • Excellent communication, facilitation, and stakeholder management skills
  • Exposure to Azure analytics services such as Azure SQL, Synapse, Data Lake, or Data Factory
  • Knowledge of REST APIs, JSON, ETL or ELT concepts, and Git-based workflows
  • Experience with DAX Studio, Tabular Editor, ALM Toolkit, or Power BI Premium features
  • Microsoft PL-300, PSM/CSPO, or IIBA CCBA/CBAP certification
  • Python or R, statistics, Power Automate, Power Apps, or embedded analytics experience
  • Domain experience in BFSI, healthcare, retail, manufacturing, or a related industry
  • Bachelor's degree in Information Systems, Computer Science, Engineering, or a related field
  • MBA degree
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Toronto , ON
1,078 Employees
Year Founded: 1990

What We Do

Kumaran Systems is an IT Services Company with imprints in three countries. The past two decades has seen us provide our global clientele with high-end IT services that include migration support, system integration and infrastructure management solutions, providing one-stop-solution to all your IT demands. Our expertise and in-depth knowledge of businesses help us cater to a variety of industries. Our team strives to know your industry better, by observing current trends and the way it works, to tailor-make our solutions to your needs.With over 20 years of customer orientation, over 2000 engagements across Telecom, Education and Banking & Financial services spread across the globe, Kumaran stands as a key advisor to some of the largest Fortune 500 companies in their business driven technology enablement drive. Kumaran System's Customer Orientation is driven by a global delivery business model giving its customers to choose between an Onshore-Offshore mix. The delivery models enable multilevel touch points between the client, partner networks and Kumaran thereby enabling business driven customer sensitivity and agility. ENGAGE, EMERGE AND EXCEL Involving ourselves in a purposeful action, using our abilities to its maximum, helps us feel positive about ourselves. Such positivity gives raise to positive thinking and positive ideas. Ideas evolve into vision and set our aim! Our aspirations engage us with the incentive of sweet success! Every endeavor has its own pitfalls. Perseverance helps us emerge a successful entrepreneur after any deterrent. In our attempt to achieve our aim, we keep upgrading our knowledge and skill, to surface successful! A genius mind does not work to excel, but excels in work! We challenge ourselves with every next step! We change every deterrent to a stepping stone to success. We essentially, engage, emerge and excel

Similar Jobs

CSC Logo CSC

Associate Client Order Coordinator

Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Remote or Hybrid
2 Locations
8500 Employees

Capco Logo Capco

Regulatory Reporting BA - CRD6

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Zscaler Logo Zscaler

Senior SOC Analyst

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Remote or Hybrid
India
8697 Employees

SailPoint Logo SailPoint

Engineering Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
India
2461 Employees

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account