XP Power is looking for a detailoriented and analytical Reporting Analyst to join our team. The ideal candidate will be responsible for extracting analysing and interpreting data from XPs systems to generate comprehensive reports and insights must have a background in creating the framework for Selfserve reporting in a global organisation working as part of our Global Business Systems Team. This role will be primarily focused on the companys Global SAP S4/HANA ERP System data but will also encompass other ERPs and key line of business systems e.g. SalesForce.
KEY RESPONSIBILITIES
- Background in building a Kimball model for SeifServe Reporting. Must understand SQL models and Extract Transform & Load (ETL) functions.
- Managing adhoc data extraction and transformation requests to support business needs for data visibility.
- Support a new initiative for business selfserve analytics with the provision of common comprehensive and reusable datasets
- Provision of visuals in Power BI to meet business reporting requirements.
- Strong working knowledge of technologies including SQL Azure and Databricks to compile underlying data models to support reporting.
- Support the ingestion process and scheduling of source raw data tables into the XP data warehouse.
- Liaison with the business and SAP Data Architect to understand data requirements for extraction in preparation for reporting.
- Support the business with any general reporting issues queries and management of enhancement requests.
- Maintenance and creation of key documentation to support BI and the XP reporting catalogue.
- Provide training and support to endusers on report generation and utilization of Power BI as a global reporting solution.
Qualifications :
Key Qualifications and Skills
- Must have a minimum of 3 years proven experience working with Power BI & SQL.
- Strong SQL skills for data querying and transformation. Must understand modelling required for facts and dimensions to support selfserve reporting (Kimball Model)
- Background in developing data cubes to support selfserve reporting. Must have been involved with requirements design build deployment and training.
- Experience working with SAP systems specifically in reporting and data analysis.
- Exposure to Microsoft Azure Data Factory and Databricks.
- Analytical mindset with the ability to interpret complex data sets and generate meaningful insights.
- Proven ability to document business requirements translate them into technical specifications and provide clear simple business user guides.
- Detailoriented with a focus on data accuracy and quality.
- Great communicator with ability to present complex problems in a simple manner and to a nontechnical audience.
- Ability to engage with stakeholders at all levels.
- Highly selfmotivated with excellent organisational skills and ability to work independently.
Additional Information :
Location
- Based in The Philippines
- Homebased initially until facility established in Metro Manilla (expected Ortigas Metro Manila area)
Remote Work :
No
Employment Type :
Fulltime