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
Support funding operations for the loan portfolio, manage loan cash flows, automate reporting and reconciliations, coordinate audits, design controls and governance, and lead investor financial reporting while working cross-functionally with Capital, Finance, Product, and Engineering.
Top Skills:
Ai-Enabled Productivity ToolsExcelPythonSQLWorkflow Automation Tools
Big Data • Fintech • Mobile • Payments • Financial Services
Build and operate ML training and serving infrastructure. Design, develop, and launch backend systems, collaborate across teams, support operations and on-call, write well-tested extensible code, and participate in team growth and hiring activities.
Top Skills:
AWSKotlinKubernetesMySQLPython
HR Tech • Information Technology • Professional Services • Sales • Software
The SMB Account Executive drives new business growth by managing the sales cycle, from prospecting to closing deals in a SaaS environment.
Top Skills:
Salesforce
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
