✨ AI Summary
The Data Analyst & Office Manager will be responsible for both data analysis and office management. Key data analysis duties include extracting, cleaning, and transforming data from ERP systems and databases, developing Power BI dashboards, automating reports, monitoring KPIs, and performing variance analysis. Office management responsibilities include overseeing daily operations, maintaining records, coordinating with vendors, and preparing presentations. The role requires a Bachelor's degree and 8-10 years of relevant experience, with advanced proficiency in Excel, Power Query, and Power BI.
Requirements
QualificationsBachelor’s degree in business administration, engineering, computer science, information systems, finance, or a related field.8–10 years of experience in business analysis, operations analysis, executive office, or office management.Advanced Microsoft Excel.Advanced Power Query.Advanced Power BI.Strong analytical and problem-solving skills.Excellent communication and presentation skills.Experience with ERP systems (SAP is highly preferred).Ability to manage multiple priorities in a fast-paced environment.
Description
Key Responsibilities:Data Analysis & Business IntelligenceExtract data from ERP systems and various databases.Clean, validate, and transform data using Power Query.Develop and maintain interactive Power BI dashboards.Automate recurring reports and eliminate manual reporting processes.Monitor KPIs and identify trends, anomalies, and performance gaps.Perform variance analysis and provide recommendations.Ensure data accuracy and consistency across reports.Support management with ad hoc analysis and decision-making.Office ManagementManage daily office operations and ensure smooth administrative processes.Maintain corporate records, contracts, and confidential documentation.Track executive action items and follow up on deadlines.Coordinate with internal departments and external vendors.Prepare presentations, reports, and meeting minutes when required.