The Functional Analyst - Data will manage data extraction, validation, and organization from legacy HR systems, ensuring the integrity of archived data and documenting functional requirements while collaborating with technical teams.
JOB DESCRIPTION
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.
- Bachelor's degree in information systems, Computer Science, Data Analytics, or a 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.
- 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
Similar Jobs
Big Data • Fintech • Mobile • Payments • Financial Services
Lead cross-functional initiatives to remediate control deficiencies and improve month-end close. Coordinate between operational close teams, Product, Engineering, and Financial Systems to integrate new products/processes into the GL, translate R2R requirements into reports, resolve complex accounting issues, and recommend scalable process improvements.
Top Skills:
Financial SystemsGeneral LedgerExcelPivottablesSQLVlookup
Artificial Intelligence • Productivity • Software • Automation
Lead and develop a team of Technical Support Specialists, driving AI initiatives and supporting operations that connect to business outcomes, while ensuring high customer experience and team performance.
Top Skills:
AIAutomation ToolsSaaS
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead architecture and implementation of routing, dispatch, and real-time tracking systems. Design scalable backend services and APIs, integrate with TMS/ERP systems, build dispatcher web interfaces, mentor engineers, and collaborate with product, design, and mobile teams to deliver fleet optimization features at scale.
Top Skills:
AndroidAs/400ErpGeospatialGoGraphQLiOSReactReact NativeReal-Time SystemsRoute OptimizationSAPTmsTypescript
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.
