Power BI Developer
- MSCI Services
- 2 - 3 years
- Mumbai
- 3 months ago
- Email to a friend
- Report this job
Job Description
Project Portfolio Financial Governance- Oversee project creation, updates, and closure within CA-PPM/Clarity.
- Manage CapEx/OpEx classification and ensure compliance with accounting policies.
- Facilitate submission, validation, and approval of capitalization forms .
- Track financial performance (forecast vs. actuals, CapEx variance, etc.).
- Collect and validate monthly resource allocation data from TPMs and Leads.
- Ensure alignment of allocations across CA-PPM, Jira, and financial reporting systems.
- Manage monthly time booking process , including automation of intake forms and reminders.
- Adjust for non-billable hours (vacations, training, etc.) to ensure accurate time postings.
- Develop and maintain dashboards for:
- Resource utilization allocations
- CapEx/OpEx variance
- Project financials and prioritization
- Provide executive-level summaries and insights for leadership decision-making.
- Drive adoption of standardized reporting frameworks (e.g., PRDT-level allocations, ProdFocus mapping).
- Automate repetitive processes (e.g., allocation file generation, intake form follow-ups).
- Enhance efficiency in data collection, validation, and reporting cycles.
- Partner with Technology/PPM teams to align systems (CA-PPM/Clarity Jira).
- Identify risks in allocation, reporting, and governance processes.
- Provide timely escalations and mitigation plans (e.g., resource gaps, delayed sign-offs).
- Ensure transparency and accountability in financial project reporting.
- Act as the bridge between Finance, TPMs, Accounting, and Technology teams .
- Support TPMs and business leads with allocation, reporting, and governance queries.
- Align with leadership on priorities, open issues, and process changes.
- Dashboard Report Development
- Design, build, and maintain interactive dashboards and reports in Power BI to support FPMO, Finance, and leadership.
- Develop visualizations for project allocations, CapEx/OpEx variance, non-billable tracking, and monthly time booking.
-
- Data Integration Modeling
- Connect, clean, and transform data from multiple systems (e.g., CA-PPM/Clarity, Jira, Excel intake forms).
- Build robust data models that ensure accuracy and consistency across reporting.
-
- Automation Process Improvement
- Develop automated solutions for recurring processes (e.g., intake form reminders, allocation file generation).
- Reduce manual intervention by leveraging Power BI, DAX, Power Query, and related tools.
-
- Collaboration Stakeholder Management
- Partner with TPMs, Finance, and business leads to gather requirements and refine reporting outputs.
- Ensure alignment of dashboards with evolving business processes (e.g., PRDT-level allocations, ProdFocus mapping).
- Provide training and guidance to users on dashboard interpretation and usage.
-
- Governance Risk Management
- Ensure compliance with reporting standards and data governance practices.
- Validate and troubleshoot data inconsistencies to maintain high-quality reporting outputs.
-
- Proven experience as a Power BI Developer or similar role (3 5+ years).
- Strong proficiency in Power BI, DAX, Power Query, and SQL .
- Experience with data modeling, ETL processes, and integrating multiple data sources (Excel, Jira, Clarity, etc.).
- Understanding of financial reporting, project governance, and resource allocation is highly desirable.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently while collaborating effectively with cross-functional teams.
Job Classification
Industry: Financial ServicesFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: BI DeveloperEmployement Type: Full timeContact Details:
Company: MSCI ServicesLocation(s): Mumbai
Keyskills: project governance bi power bi problem solving ppm dashboards sql report development power query excel resource allocation automation data modeling financial reporting dax etl data integration reporting communication skills jira etl process
Similar positions
MSCI Services
MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data and technology, we enable clients to understand and analyze key drivers of risk and return and confidently build more effective portfol...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in