Executive recruitment company Monroe Consulting Group Philippines is recruiting on behalf of a leading company that provides managed services backed by its own scalable technology platforms with a focus on network and digital transformation. The company offers various services including Solutions Design and Engineering, Connectivity, Provisioning, Operational Support, Project Management, and Order Fulfillment Logistics.
Job Summary
Our esteemed client is seeking an experienced Data Analyst responsible for collecting, cleaning, analyzing, and interpreting large datasets. The successful candidate will leverage their expertise in SQL, Excel, and Power BI to extract valuable insights that support data-driven decision-making. This role will also involve managing a comprehensive Global Maintenance Program Quoting & Inventory Management Analysis. Attention to detail and preparedness are essential for this position, while leadership qualities are a plus. Strong analytical skills, along with advanced Excel proficiency (including Pivot Tables, VLOOKUP, and complex formulas), are required.
This job is located in Mandaluyong City and follows an on-site work setup with a permanent night shift schedule.
Key Responsibilities:
Data Collection and Cleaning:
- Gather data from various sources, including databases, APIs, and spreadsheets.
- Clean and preprocess data to ensure accuracy and consistency.
Data Analysis:
- Perform exploratory data analysis (EDA) to understand data patterns and trends.
- Use statistical techniques and data mining tools to extract meaningful insights.
- Develop predictive models and forecasts to support business strategies.
Data Visualization:
- Create compelling data visualizations using Power BI and other tools.
- Design interactive dashboards to communicate insights to stakeholders.
Business Intelligence:
- Collaborate with business users to understand their data needs.
- Translate complex data into actionable insights.
- Provide regular reports and presentations to key stakeholders.
Essential Duties:
- Use automated tools to extract data from primary and secondary sources to develop and process new Quotes (gather, create, analyze, quote based on customer set service and requirements).
- This entails preparing a quote and conducting further mapping analysis & warehouse allocation and assignment.
- Update notes in systems, organize and maintain process documents and prior quotes and templates used for quoting.
- Managing and Maintaining a Program Book - Bi-Weekly updates; Quotes, incorporating and updating
- new/cancelled devices into revised version of this running sheet; new inbound inventory, outbound/inbound
- RMA returns; warehouse to warehouse inventory transfers
- Warehouse Designation & Assignment Analysis; New Warehouse recommendation
- Inventory/Spares Analysis Management & Coverage - based on a customer specific SLA.
- This entails restocking of spares from new orders & OEM RMA returns; Maintaining Warehouse Levels - Inventory transfers to prioritize shuffling of used spares to cover higher at risk regions/depots; Alert & inbound/outbound tracking and management for the above mentioned activities.
- Assist in obtaining all key information as well as documenting and analyzing all essential data.
- Preparing reports for the management stating trends, patterns, and predictions using relevant data
- Develop/Review forecasts for accurate and timely inventory flow projections
- Other Tasks as assigned to support new and existing projects
Required Skills and Qualifications:
- Associate's or Bachelor's degree preferred
- Highly Proficient with Microsoft Office products, Word, Excel, Outlook (Specially EXCEL)
- Proficiency in English (Above 85%) (Written and Spoken).
- Strong proficiency in SQL and Power BI
- Experience with data cleaning, transformation, and analysis techniques
- Knowledge of statistical concepts and data mining techniques
- Excellent problem-solving and analytical skills
- Familiar with Equipment Maintenance and System Reliability concepts
- Ability to work independently and as part of a team
- A passion for ensuring high levels of service quality and reliability
- Excellent communication and interpersonal skills
- Ability to work independently and as part of a team
- Willing to work onsite
- Willing to work in Mandaluyong City
- Willing to work on a permanent night shift
