Datawarehouse Admin Associate

With 75 years of experience, our focus is on helping the most vulnerable children overcome poverty and experience fullness of life. We help children of all backgrounds, even in the most dangerous places, inspired by our Christian faith.

Come join our 33,000+ staff working in nearly 100 countries and share the joy of transforming vulnerable children’s life stories!

Key Responsibilities:

This position is responsible mainly for ensuring the integrity, timeliness and optimal performance of the Finance Data Warehouse/Data Lake platform. This role involves monitoring data ingestion (ETL/ELT), troubleshooting and applying code fix/change to production related issues and maintaining the documentation to support the business operations. Additionally, the position manages the environment to secure the data platform from unauthorized access and maintain platform scalability within the budget thresholds.

Work Set-up:

• The role requires an on-site presence and involves regular collaboration with global teams across various time zones.
• This position is eligible for Hybrid-Work based on GFS Manila Hybrid Work Position and Implementing Rules.
• The position requires ability and willingness to travel domestically and internationally as needed.
  
  

• Monitor and maintain ETL/ELT pipelines to ensure data warehouse/lake house platforms are up-to-date and optimized for performance.
• Manage and perform the uploading of diverse data sources/source files into the data warehouse/data lake platform.
• Monitor and Automate data validation by comparing data from source file vs data uploaded in data warehouse/data lake platform.
• Assist in analyzing data quality issues and collaborate on resolution to be applied.
• Document production operations manual.
• Communicate changes, corrections and updates to users and stakeholders.
  
  

• Provide root cause analysis and fixes/code changes to production issues.
• Design, develop and deploy data pipeline process/data loaders/data quality code to accommodate evolving business requirements.
• Document root cause analyses, resolutions and any code fixes/changes applied.
• Collaborate with developers during stabilization of deployed code.
• Communicate changes, corrections and updates to users and stakeholders.
  
  

• Administer the different data layers of the data warehouse/lake house to ensure compliance with organizational data governance and standard data architecture.
• Establish Code Deployment in Production to allow Continuous Integration/Continuous Delivery (CI/CD).
• Daily monitoring of server performance and cost utilization
• Coordination with IT counterparts for server maintenance and downtime schedule.
• Test servers/cloud data services for availability.
• Escalation of server problems encountered to IT counterparts.
• Coordination with data engineers and solution architects and IT counterparts on storage and environments assessment and future requirements.
  
  

• Build knowledge base and share best practices in the area of data engineering/administration.
• Perform other additional tasks that may be assigned.
• Attend and participate in meetings, conferences, workshops, chapel services, devotions, etc.
  
  

• Candidate must possess a Bachelor’s degree in IT, Computer Science or related course/field.
• At least 2 years work experience working with SQL Server Administration.
• 1 to 3 years work experience in ETL development or support.
• Experience in SQL Server Administration, RDBMS, Microsoft SSIS OLAP Cubes administration.
• Strong understanding of data pipelines (ETL/ELT) processes.
• Proficiency in SQL, SSIS or any other ETL tools
  
  

• Knowledge in Python, Excel (Advanced Data Manipulation).
• Knowledge in data warehouse/data lake architecture.
• Preferably knowledgeable in Cloud Datawarehouse deployment in Azure/AWS (e.g Microsoft Fabric, Microsoft DW Technology Stack) and data governance framework.
• Knowledge in accounting/ERP, budget and planning software is an advantage.
• Experience with large data in a multinational organization