SAP & Portfolio Data Analyst

Cubane Solutions AB; Malmö kommun; On-site; SEK 800,000 - 1,100,000; Full time

Job summary

Cubane Solutions AB in Malmö is seeking an experienced Portfolio Planner to lead data-driven portfolio improvements, roadmap updates, and KPI visualization. You will drive cross-functional collaboration, ensure data transparency, and implement automation to streamline governance and reporting processes.

The role emphasizes advanced Power BI development, SAP/PlanView data integration, and data preparation for strategic decision-making; collaboration with stakeholders is essential.

Qualifications

• Bachelor’s or Master’s degree in Business, Engineering, Finance, or related field.
• 3-5+ years of experience in portfolio planning, project management, or strategic planning.
• Knowledge of Waterfall and Agile, PlanView, SAP and data flows.

Responsibilities

• Proactively identify gaps and drive improvements from gap identification through solution design and full implementation readiness.
• Maintain and update the integrated portfolio roadmap aligned with business needs and other organisations.
• Ensure transparency of data through clear visualization (Portfolio views, programmes views, project views, org workload, KPIs, Decisions, Financial views).
• Design and develop Power BI dashboards for portfolio reporting and KPIs; create automation workflows using Power Automate and VBA scripts.
• Optimize data flows between SAP, PlanView, and other portfolio systems; oversee data preparation and integration.

Skills

Portfolio planning

Data analysis

Power BI

Power Automate

VBA

SAP

PlanView

Data integration

Stakeholder management

Education

Bachelor/Master degree

Tools

SAP

PlanView

Power Automate

VBA

Power BI

Job description

Responsibilities

Portfolio Planning

• Proactively identify gaps and underperforming processes, analyze bottlenecks, and drive improvements independently (from gap identification through solution design and full implementation readiness) working closely with stakeholders to ensure alignment with organizational objectives.
• Maintain and update the integrated portfolio roadmap aligned with business needs and other organisations.
• Ensure transparency of data through clear visualization (Portfolio views, programmes views, project views, org workload, KPIs, Decisions, Financial views, etc.).
• Benchmark outside the organization to identify possible improvement opportunities.

Governance & Reporting

• Support governance forums with data-driven insights and recommendations.
• Ensure data accuracy of portfolio dashboards, KPIs, and status reports for better-informed strategic and operational decisions.

Data Collection & Preparation

• Gathering data from primary and secondary sources. Ensuring data accuracy and consistency by organizing and preparing it for analysis.
• Optimizing data management to fit consumption purposes.

Tool Development & Automation

• Design and develop Power BI dashboards for portfolio reporting and KPIs.
• Create automation workflows using Power Automate and VBA scripts to streamline processes.
• Integrate new tools into existing infrastructure with minimal disruption.

Data Management & Integration

• Optimize data flows between SAP, PlanView, and other portfolio systems.
• Prepare and organize data for consumption and decision-making.
• Oversee the implementation process of new systems/tools and integrate them into existing infrastructure with minimal disruption.

Required Skills

• Procedures, processes and needs: Knowledge of organizational processes, procedures, systems, tools and existing data/information (Waterfall, Agile, PlanView, SAP, Early management, etc.).
• Familiarity with financial planning and budgeting processes.
• Deep knowledge of computer science, IT infrastructure, and systems.
• Advanced Power Automate skill.
• Deep understanding of SAP transactions and dataflows.
• Advanced PowerBI development skills.
• Able to create VBA scripts to improve Excel files usage.

Requirements

• Bachelor’s or Master’s degree in Business, Engineering, Finance, or related field.
• 3-5+ years of experience in portfolio planning, project management, or strategic planning.