Job Openings
Data Transformation Specialist (Hybrid)
About the job 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)