Job Title: Data Analyst – SAP BPC
Salary- As per Industry
Role Summary:
We are seeking a detail-oriented and technically skilled Data Analyst to join our team supporting the implementation and ongoing maintenance of our SAP BPC (Business Planning and Consolidation) this role you will work closely with cross-functional teams to develop maintain and optimize reports and input templates using BPC's EPM Add-in for Excel. Your technical expertise and understanding of business processes will play a crucial role in ensuring accurate reporting and efficient planning processes.
The role requires strong analytical skills proficiency in data visualization tools and the ability to communicate findings effectively. If you are passionate about transforming data into meaningful insights and contributing to data-driven strategies we would love to have you on board
Key Responsibilities:
• Support the BPC team to meet the organization’s financial planning budgeting and reporting needs.
• Develop test and maintain custom reports and input templates using SAP BPC EPM Add-in for Excel.
• Assist in data validation reconciliation and troubleshooting of reports to ensure accuracy and consistency.
• Troubleshoot issues in BPC processes and ensure timely resolution.
• Work closely with finance and business teams to gather requirements and deliver tailored data solutions. Support management in decision-making by providing actionable insights.
• Provide ongoing maintenance of the BPC application including updates to reporting templates and integration with financial systems.
• Write and maintain SQL queries and VB scripts to support custom reporting and automation needs.
• Perform basic scripting for automating data imports data transformations or other system tasks.
• Monitor data flows and troubleshoot integration issues between BPC and other systems.
• Deliver user training and support ensuring business teams can effectively utilize SAP BPC tools.
• Extract transform and load (ETL) data into SAP BPC from various sources.
• Collaborate with IT and business teams to improve data pipelines and workflows.
• Identify and implement process improvements in data analysis and reporting workflows.
• Automate repetitive tasks to improve efficiency and reduce manual effort.
• Assist in documenting business processes and technical workflows related to SAP BPC.
Qualifications:
Education and Experience:
• Bachelor's degree in Data Analytics Computer Science Finance Accounting Information Systems or a related field.
• 2–4 years of experience in financial analysis budgeting or planning preferably with SAP BPC or other enterprise planning and consolidation tools.
Technical Skills:
• Proficiency in SAP BPC EPM Add-in for Excel including report and input template design.
• Advanced skills in Microsoft Excel and data transformation including formulas pivot tables and data analysis tools.
• Hands-on experience with SQL and VB (Visual Basic) for developing queries and scripts.
• Identify and implement process improvements in data analysis and reporting workflows.
• Automate repetitive tasks to improve efficiency and reduce manual effort.
• Basic knowledge of scripting languages (e.g. Python or similar) is a plus.
• Familiarity with financial planning budgeting forecasting and financial close processes.
• Soft Skills:
• Excellent analytical and problem-solving skills
• Ability to understand and document business processes and requirements.
• Strong interpersonal and communication skills to collaborate with cross-functional teams.
• Self-motivated detail-oriented and capable of managing multiple tasks in a fast-paced environment.
Preferred Qualifications:
• Experience with SAP BPC Embedded or Standard models.
• Prior involvement in a BPC implementation project or system upgrade.
• Experience with scripting tools (e.g. Python PowerShell) for process automation.
Required Skills:
Cco Analytical Skill Clo Pivot Tables Cro Data Analytics Vat Consolidation Data Visualization Business Planning Education Erp Self-motivated Forecasting Data Analysis Powershell Technical Work Analytical And Problem-solving Skill Insight Financial Planning Accounting Microsoft Excel Problem-solving Skill Python Workflow Problem-solving Excel Communication Skill Visual Basic Detail-oriented Sap Scripting Languages Communication Skills Sql Budgeting Technical Skill Technical Skills Strong Analytical