Power BI and Data Management Analyst

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