Functional Analyst – ETL & SQL Data Analyst
Global Service Center- Costa Rica
Aplicar ahoraResumen de la Empresa
Sysco conecta al mundo para compartir alimentos y cuidar unos de otros. Sysco lidera desde el corazón de la comida y el servicio para ofrecer los alimentos más frescos e ideas innovadoras a restaurantes, centros de salud, instituciones educativas, establecimientos de hospedaje y otros clientes que preparan comidas fuera del hogar. Nuestros clientes pueden contar con nosotros para entregar productos y soluciones precisas, ya que solo Sysco es el líder global que se encuentra en el centro de la innovación en suministro, entrega, cocina y más.
Acerca del role:
The Functional Analyst – Data will support the Sysco Technology Archive, a centralized repository of legacy HR data. This role works closely with archive team developers and designers to extract, validate, transform, and organize data from legacy systems no longer in use. The ideal candidate is detail-oriented, hands-on with data, and experienced in collaborating across technical and functional teams. Strong hands-on experience with SQL and ETL processes is mandatory for this role, including data extraction, transformation, validation, and troubleshooting across multiple data sources.
Responsibilities:
Collaborate with developers and designers to extract, cleanse, and transform HR data from legacy systems for archival.
Act as a liaison between business stakeholders and the archive team to gather and document data requirements.
Analyze legacy data structures and determine mappings to the Sysco Technology Archive format.
Perform data validation and quality checks to ensure integrity and completeness of archived data.
Assist with creating functional documentation, data dictionaries, and mapping specifications.
Support data migration and conversion activities by translating business needs into technical specifications.
Participate in testing and validation cycles to ensure accurate migration and retention of historical HR data.
Troubleshoot data-related issues and support post-archival inquiries from business units.
Provide input on process improvements and automation opportunities in the archival workflow.
Education
Bachelor's degree in information systems, Computer Science, Data Analytics, ora related field.
3+ years of experience as a data or functional analyst, preferably in HR or enterprise systems.
Excellent communication skills in English (B2+ or higher) and ability to collaborate across functions and geographies.
Skills
Strong understanding of Extract, Transform, and Load (ETL) processes; hands-on ETL experience is mandatory.
Familiarity with SQL object and table security; hands-on SQL experience is mandatory. Strong SQL skills for querying and validating data across multiple sources.
Familiarity with HR systems and data structures (e.g., PeopleSoft, SAP, Workday, or similar).
Ability to read and interpret database schemas, ERDs, and legacy data formats.
Excellent analytical and problem-solving skills with a strong attention to detail.
Familiarity with programming languages such as Java.
Experience documenting functional and technical specifications.
Effective communication skills, with the ability to work cross-functionally and explain complex data concepts to non-technical stakeholders.
Comfortable working in agile, collaborative team environments.Familiarity with security for objects/tables in SQL.
Benefits:
This is a hybrid position based in Ultra Park II, Lagunilla (Heredia). On-site presence is required only when necessary, such as for meetings, trainings, or collaborative activities, in alignment with the company’s telework agreement, which currently requires employees to work on-site three (3) days per week.)
Private Medical Insurance
Asociacion Solidarista
Life Insurance
Personal Day Off
Note: Only candidates with Costa Rican nationality or valid immigration status will be considered; applicants residing outside Costa Rica will not be considered, and relocation is not available