JOB DESCRIPTION
Power BI Developer Finance Data and Analytics | Assistant Manager
Position Name
Asst. Manager - Power BI Developer (End-to-End Finance Analytics)
Division / Function
Digital COE / PMO IT
Location
Navi Mumbai- Seawoods
Reports To
AGM / Digital COE Leadership
Experience
4-5 years
No. of Positions
1
Purpose - Why does this role exist?
To independently lead finance data and analytics across GBS processes, from ERP/SAP data extraction through development of data pipelines and transformation layers from base/raw data to Power BI, including data modelling, DAX, visualization, deployment and support. The role will own AP, AR, Treasury and related GBS process data, ensuring source-to-report integrity while constructively challenging existing process logic, data transformations and analytics pipelines to improve automation, accuracy and business insights.
Key Result Areas (KRAs / KPIs)
KRAExpected Outcome / MeasureEnd-to-end deliveryAccurate and timely ERP/SAP-to-Power BI solutions covering extraction, transformation, modelling, visualization and deployment.Data quality & reconciliationReconciled source-to-report outputs with controlled transformation logic and timely resolution of data-quality issues.Visualization & insightRelevant KPIs, clear visual storytelling, exception analysis and actionable insights.Performance & reliabilityOptimized models, DAX and refresh performance with stable production support.Process ownership & challengeIndependent ownership of finance analytics with evidence-based challenge to current process owners.
Critical Tasks - Mandatory Key Activities
- Own the complete ERP/SAP-to-Power BI lifecycle: extraction, loading, transformation, validation, modelling, visualization, deployment and support.
- Lead AP, AR, Treasury and related finance analytics independently, translating business requirements into KPIs and management insights.
- Clean, consolidate and reconcile data using Power Query/M and SQL; resolve duplicates, missing values, mapping issues and source-to-report breaks.
- Build efficient star-schema models and advanced DAX measures for aging, SLA, variance, trends, exceptions and productivity analysis.
- Manage Power BI Service, gateways, scheduled refresh, workspaces, permissions and Row-Level Security.
- Challenge process owners on data pipelines, business logic, controls, performance and automation opportunities.
- Maintain data lineage, KPI definitions, transformation logic, access controls and solution documentation.
Decision-Making Authority / Ownership Expected
- Own solution design, data validation, modelling, visualization and performance decisions within agreed timelines.
- Challenge incomplete requirements and expedite material data, access, security or source-system risks.
Required Technical Skills
- Strong Power BI Desktop and Service, DAX, Power Query/M, data modelling and dashboard UX skills.
- Working knowledge of SQL, ETL/ELT, ERP/SAP extraction, source-to-target mapping, reconciliation, incremental loads and data lineage.
- Experience with gateways, refresh monitoring, workspaces, permissions and Row-Level Security.
- Understanding of AP, AR and Treasury data, including open items, aging, payment/collection status, bank positions and control exceptions.
Good to Have
- SAP S/4HANA or comparable ERP experience; SharePoint/OneDrive, Microsoft Fabric, Azure or Databricks and Data Lake exposure.
- Finance analytics experience in AP, AR, R2R, Taxation or Treasury within a Shared Services/GBS environment.
Educational Background & Work Experience
- Bachelor's degree in a relevant discipline with 4-5 years of hands-on, end-to-end Power BI development experience.
- PL-300 or relevant Microsoft Fabric certification is an advantage.
Competencies
- Independent ownership, analytical thinking, problem-solving and strong reconciliation discipline.
- Stakeholder management, constructive challenge and clear communication with operational and senior-management users.
Working Relationships - Stakeholders
Internal: Finance process teams, Digital COE / PMO, Group Analytics and other GBS functions. External: Business stakeholders, technology partners and vendors, as required.
Key Success Factors / Challenges
- Ability to independently convert ERP/SAP finance data and business objectives into accurate, scalable and actionable Power BI solutions.
- Comfort with incomplete requirements and imperfect data without compromising controls, performance or governance.
Sign-off
Position HolderImmediate SuperiorHead of DepartmentHR
Sign:
Name:
Date:
Sign:
Name:
Date:
Sign:
Name:
Date:
Sign:
Name:
Date:
Sign:
Name:
Date:
JSW GBS Limited | Job Description - Power BI Developer