Power BI Data Modeler/Developer

Senior Power BI Data Modeler/Developer (Finance Domain)

6+ Months Contract

Mumbai (Hybrid)

3-4 years of experience

Immediate Joiner

80K per month salary

Key Responsibilities:

- Design and optimize data models for large financial datasets (transactions, valuations, cashflows).

- Implement advanced star schema concepts: fact grain definition, surrogate keys, handling SCDs, managing high cardinality.

- Architect complex relationships: bridge tables, role-playing dimensions, inactive/active relationships, bi-directional filtering control.

- Apply large dataset optimization techniques: aggregation tables, composite models, DirectQuery vs Import trade-offs, incremental refresh, partitioning.

- Develop advanced DAX measures: context transition mastery, iterators, virtual tables, calculation groups, time intelligence for custom fiscal calendars.

- Build finance-specific dashboards: portfolio returns, IRR/XIRR, benchmark comparisons, rolling performance, risk metrics, fund-level RLS.

- Conduct performance tuning using DAX Studio, Performance Analyzer, VertiPaq Analyzer, and query plan analysis.

Required Skills:

- Advanced Data Modeling: fact grain, bridge tables, surrogate keys, SCD, incremental refresh, composite models.

- Advanced DAX: row vs filter context, CALCULATE, iterators, virtual tables, time intelligence, dynamic ranking, variance/budget analysis.

- Finance Domain Expertise: portfolio modeling, multi-fact integration, benchmark comparison, risk metrics, reconciliation.

- Optimization Tools: DAX Studio, Performance Analyzer, VertiPaq Analyzer.

Candidate Profile:

- Strong conceptual clarity in data modeling and DAX (not just syntax).

- Ability to explain why design choices are made (e.g., grain of fact table, bridge table necessity).

- Experience in asset management or financial reporting preferred.

- Demonstrated ability to balance modeling accuracy with performance efficiency.