Power BI and Data Management Analyst

Barry Callebaut Chocolate Asia Pacific Pte Ltd; Singapore; On-site; SGD 90,000 - 120,000; Full time

Benefits offered by this job

null

Job summary

Barry Callebaut Chocolate Asia Pacific Pte Ltd is seeking an experienced Power BI and Data Management Analyst to design and build a scalable Employment Cost Dashboard across APAC, consolidating payroll data and providing monthly insights to support budgeting and workforce planning.

The role emphasizes end-to-end data modeling, interactive dashboards, scenario modeling, and executive-ready visuals, with strong governance and access controls across regions.

Qualifications

• BSc in computing or related field.
• Experience in data analysis and business indicators analytics.
• Hands-on Power BI development experience.
• Experience building workforce, HR, payroll, finance dashboards.
• Solid Excel skills and data visualization proficiency.
• Experience handling large datasets and multiple data sources.
• Proven ability to design executive dashboards.
• Proficient in English and clear communication.
• Collaborative across APAC region.

Responsibilities

• Collect and analyze payroll data from APAC markets.
• Normalize data for system readability.
• Develop end-to-end interactive Power BI dashboards for Total Cost of Employment.
• Create dashboards for Base Salary, incentives, benefits, etc.
• Design robust data models using Power Query.
• Embed scenario modeling for future cost scenarios.
• Build executive-ready visuals for decision-making.
• Implement access management for the Power BI tool.

Skills

Data analysis

Communication

Teamwork

Adaptability

Education

Bachelor’s degree in computer science

IT / Information Systems related field

Tools

Power BI

Excel

SQL

Data visualization tools

Job description

Job Description

The Power BI and Data Management Analyst will play a crucial role in creating a scalable reporting solution that supports workforce planning, budgeting, people cost management, and executive decision-making. Their expertise will contribute to strategic decision-making, ensuring operational effectiveness and the achievement of organizational objectives.

We are 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.

MAIN RESPONSIBILITIES & SCOPE

• Collect, analyze and interprete 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.

PHASES OF RESPONSIBILITIES & SCOPE

Phase 1

• Requirements documentation gathering, preparation and normalization
• Data mapping process
• Dashboard wireframes and architecture

Phase 2

• Power BI data model
• Automated data ingestion process
• Initial employment cost dashboard

Phase 3

• Executive Dashboard design
• User guide and documentation
• Knowledge transfer session
• Handover materials

Job Requirements

EDUCATION, LANGUAGE, SKILLS & QUALIFICATIONS

• 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.

Additional Notes

ESSENTIAL EXPERIENCE & KNOWLEDGE / TECHNICAL OR FUNCTIONAL COMPETENCIES

• Data Analysis
  • Advanced ability to collect, process, and analyze large sets of operational data using tools such as Excel, SQL, and other data analysis platforms.
• Predictive Modeling
  • Knowledge of predictive modeling techniques and the ability to develop models using aiming to anticipate trends related to cost of people.
• Data Visualization Tools
  • Proficiency in data visualization tools especially Power BI, or others to create visually impactful reports and dashboards that facilitate understanding and decision-making.

LEADERSHIP COMPETENCIES & PERSONAL STYLE

• Communication Skills:
  • Ability to effectively communicate with regional teams, translating complex data into understandable insights.
  • Excellent presentation skills to convey information clearly and impactfully.
• Teamwork and Collaboration:
  • Aptitude for effective collaboration with multidisciplinary teams, understanding the specific needs of each area.
  • Willingness to share knowledge and insights, fostering a collaborative work environment.
• Adaptability and Flexibility:
  • Ability to adapt to changes in demands and adjust strategies as necessary.
  • Flexibility to deal with different market cost details contexts and process peculiarities.
  • Results Oriented

Skills

Power BI