2024-7364_Datawarehouse Support Analyst - Level II

  • Full-time

Company Description

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

Job Description

THIS ROLE IS ONLY APPLICABLE FOR CANDIDATES PERMANENTLY RESIDING IN THE PHILIPPINES

Shift assignment: Night Shift

The Datawarehouse Support is responsible to operational support and management of various business applications across the enterprise.

This role will be responsible for monitoring, troubleshooting, upgrading and implementing carious software application for a thriving reinsurance company. This position will work in concert with IT team to ensure all applications are operating and running properly and serving the need of the business.

  • Monitoring SDW Daily jobs (including weekend)
  • Communicate to business users on any delays in daily jobs
  • In case of failures review job logs and fix them and re-run the jobs
  • Daily reconciliation of Warehouse data post loads to source systems

Qualifications

Required Skills/Experience

  • Good to excellent SQL writing capabilities (MS SQL/Snowflake – they are similar so SQL Server should be good)
  • Data Analysis in Excel so high proficiency with Excel is very much preferred
  • Organized/Meticulous and good communication skills
  • Work schedule: Must be open to flexible scheduling to cover different shifts including weekends.

Desired Skills/Experience

  • Platform they will work on and trained (if not experienced)
  • Azure Data Factory
  • Databricks
  • SQL Server (must have existing experience)
  • Qlik Some level of Warehousing background will be looked at more favorably
  • Ability to work well independently and as part of a team

Additional Information

  • Bachelors’ degree in Computer Science, Management of Information Systems, or related field required