Sysco Logo

Sysco

Functional Analyst – ETL & SQL Data Analyst

Reposted 9 Days Ago
In-Office or Remote
Hiring Remotely in Canada
Mid level
In-Office or Remote
Hiring Remotely in Canada
Mid level
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.
The summary above was generated by AI
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. 
Education
  • 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.
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

Similar Jobs

18 Minutes Ago
Easy Apply
Remote or Hybrid
2 Locations
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
The Senior Python Engineer will develop and support MongoDB Python drivers, collaborate with teams, and resolve bugs, enhancing user experience with MongoDB tools.
Top Skills: Ai/Ml FrameworksDjangoMongoDBPymongoPython
18 Minutes Ago
Easy Apply
Remote or Hybrid
6 Locations
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
The Senior Product Manager will oversee the strategy and execution of MongoDB's replication and storage engines ensuring system reliability and performance for critical workloads.
Top Skills: DatabasesDistributed SystemsMongoDB
28 Minutes Ago
Easy Apply
Remote or Hybrid
Canada
Easy Apply
Senior level
Senior level
Marketing Tech • Real Estate • Software • PropTech • SEO
The Design Engineer will enhance the design system, improve UI quality, build tooling and workflows, and ship production-ready code, collaborating closely with product designers and engineers.
Top Skills: Base UiFigmaReactStorybookTailwindTypescript

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account