Sysco Logo

Sysco

Functional Analyst – ETL & SQL Data Analyst

Reposted 5 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

39 Minutes Ago
Remote or Hybrid
East York, ON, CAN
Junior
Junior
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead design, deployment, and sustainment of IL6S/TPM systems to eliminate losses and improve equipment reliability. Train and coach teams, run Kaizen and DMAIC events, track KPIs (OEE, MTBF/MTTR), implement SOPs and visual management, perform loss analysis, and support preventive/predictive maintenance to drive productivity and safety targets.
Top Skills: 5WhysAutonomous MaintenanceDmaicE2E Data Collection SystemsGeIshikawaKaizenLean Six SigmaMakigamiMtbbMtbfMttrOeeParetoPdcaPredictive MaintenanceRoot Cause Analysis (Rca)SmedStandard WorkTpmValue Stream Mapping (Vsm)Visual ManagementWpi Tool
39 Minutes Ago
Remote or Hybrid
CA
Senior level
Senior level
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Outbound-focused senior account executive responsible for sourcing and closing new restaurant merchant logos. Duties include prospecting, discovery, demos, consultative selling of Square ecosystem, field relationship building, partnering with BD/Product/Marketing, managing the sales cycle and onboarding, and meeting monthly sales KPIs using Salesforce.
Top Skills: SalesforceSquare
4 Hours Ago
Remote or Hybrid
Senior level
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Manage and grow ServiceNow partner relationships across Canada: build partner practices, set targets, drive governance, enablement, reporting, business reviews, remediation plans, and achieve joint revenue goals while coaching partners and collaborating with global teams.
Top Skills: AIServicenow

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account