Power BI and Data Management Analyst (6 month fixed term contract)

Barry Callebaut is seeking an experienced individual with a background in workforce analytics and financial reporting to design and build an interactive Employment Cost Dashboard. The successful candidate will consolidate workforce cost data from multiple sources and develop automated reports that provide monthly visibility into employee-related expenses across countries, business units, and employee populations.

About the role:

• Collect, analyze and interpret payroll data gathered from the different markets and sources across the Asia Pacific Markets.
• Prepare and normalize the data in readiness for conversion into a system readable format.
• Develop end – to – end an interactive Power BI tool which utilizes the normalized data gathered to provide information and insights on the Total Cost of Employment broken down by Region, Countries, departments and individuals.
• Develop individual dashboards for different pay components e.g. Base Salary, Short Term Incentives, Sales Incentives, Benefits etc broken down by Region, Countries, departments and individuals.
• Develop and design robust data models as required by the stakeholders using Power Query. These data models include but not limited to Personal Cost Efficiency model, Overhead Efficiency models, Monthly employment cost trends, Actual vs budget variance, Year-on-year comparison, Merit increase impact etc
• Develop and embed an interactive scenario modeling “what-if” output to aid simulation of future scenarios using the Total Cost of Employment data
• Build executive ready visualizations easily exported from the Power BI and for utilization for decision-making.
• Embed access management rights, correctly, to the Power BI Tool.

About You:

• Bachelor’s degree in computer science, IT, Information Systems or a related field.
• Previous experience in data analysis, business indicator analytics is preferred
• Prior hands-on experience in Power BI development.
• Preferred candidates with experience building workforce, HR, payroll, finance, or labor cost dashboards
• Solid knowledge of analytical tools, such as Excel, and data visualization platforms.
• Experience handling large datasets and multiple data sources
• Proven experience designing executive-level dashboards
• Proficient in English.
• Interpersonal skills to collaborate effectively with teams across the APAC Region.
• Clear and concise communication abilities, both verbally and in writing.