IT Data Analyst (SAP BPC)

Role & responsibilities :

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)application. In 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 organizations 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 Experienc:

• Bachelor's degree in Data Analytics, Computer Science, Finance, Accounting, Information Systems, or a related field.
• 24 years of experience in financial analysis, budgeting, or planning, preferably with 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.