Data Transformation Specialist (Hybrid)

Work setup: Hybrid setup (2-4x RTO/month) in MOA Pasay, Philippines

Shift Schedule: Night Shift

Qualifications:

• College Degree in Computer Science, Economics, Mathematics, or Business Administration
• 1+ years relevant experience
• Data Management experience
• Strong communication skills/Client-Facing experience
• Strong Technical Skills in Excel particularly in VBA and Macros
• Strong Technical Skills in SQL
• Strong mathematical and analytical skills
• Moderate Microsoft Excel (Power User), Access, and PowerPoint required (2 years of VBA working knowledge is a must). Must be proficient in Pivot Tables and advanced nested formulas
• Working knowledge with relational querying concepts, i.e. MS SQL Server Management Studio
• Experienced at capturing and analyzing relevant data for formulating recommendations
• Ability to summarize information utilizing charts and graphs using MS PowerPoint
• Excellent written and verbal communication and the ability to work with internal and external customers
• Dependability and the ability to maintain utmost confidentiality in dealing with business information
• Computer skills: MS SQL and VBA for Excel and Access are required

Nice to have

• Background in Finance
• Equipment/Device to take excel assessment

Key Responsibilities:

• Collect and document business requirements for project and business improvements/automation efforts
• Facilitate process workflow modeling in order to collaborate on process improvements, automation capabilities and clearly defined end-to-end use cases Identify issues and risks
• Bring inconsistencies and problems to the attention of management
• Participate in the problem resolution
• Design and develop ad-hoc analysis/reports to help Pricing and Sr. Management drive business decisions and support strategic initiatives
• Review data source and reporting for accuracy and completeness
• Utilize Microsoft Office skills to automate reporting and analysis
• Conduct extensive data prep and analysis of trends
• Assist in preparation of monthly reports/metrics
• Evaluate/design new and existing macros and report logic
• Assist in Data Acquisition and Data Preparation process as a business need arises
• Other ad hoc tasks or activities associated with the Process Analyst Support function and/or tasks within the capability and pay grade of the Process Analyst as may be assigned.

Why Apply?

• Hybrid Work Set-up
• Equipment provided
• HMO Coverage
• Work-life Balance
• Engagement Activities
• Telecommunication Allowance for Team Leaders and Up
• Performance-based Bonuses (Quarterly)
• For work onsite days, the office is located near transport terminals (Mall of Asia, Pasay)