The Role
Develop and maintain Panorama analytical dashboards using Snowflake, Tableau, and data from multiple sources. Build data warehouse structures, data models, data marts, and ETL/ELT integrations while ensuring performance and data quality. Translate client and business needs into KPIs and visualizations. Develop supporting web functionality with Symfony PHP, collaborate with IT, Product, and Data teams, and maintain technical documentation and testing processes.
Summary Generated by Built In
Lexagri Data & Analytics Developer
Lexagri is looking for an experienced Data & Analytics Developer to join the IT team. This role will focus on the development of Panorama (Insights) projects: analytical dashboards that combine data from multiple sources from Lexagri product like Homologa and Agrowin to deliver market and regulatory intelligence to our clients.
For more than three decades, FoodChain ID has been at the forefront of the New Food industry, helping companies navigate increasing global demands for transparency, accountability, safety, and sustainability.
Lexagri is looking for an experienced Data & Analytics Developer to join the IT team. This role will focus on the development of Panorama (Insights) projects: analytical dashboards that combine data from multiple sources from Lexagri product like Homologa and Agrowin to deliver market and regulatory intelligence to our clients.
- Design, build, and evolve Panorama dashboards and the data flows that feed them, working closely with the existing Insights development team.
- The role combines data analytics expertise, work with large and heterogeneous datasets in a cloud data warehouse (Snowflake), BI tool development (Tableau preferred), and web development skills based on Symfony PHP to support and extend the applications around our dashboards.
- Design and develop interactive dashboards for Panorama (Insights) projects, connected to our Snowflake data warehouse
- Integrate, model, and combine data from different data sources into Snowflake (databases, ETL outputs, external files)
- Design and maintain data warehouse structures (schemas, views, data marts) optimized for dashboard performance
- Work with large data volumes, ensuring performance, data quality, and consistency
- Translate business and client needs into clear KPIs, data models, and visualizations
- Develop and maintain web functionalities with Symfony PHP that support or embed dashboard solutions
- Collaborate with IT, Product, and Data teams
- Produce and maintain technical and functional documentation
- Support testing, validation, and continuous improvement initiatives
- Minimum 2-3 years of experience in data analytics, business intelligence, data integration, software development, or related fields
- Solid experience with data warehousing concepts (dimensional modeling, star/snowflake schemas, data marts)
- Hands-on experience with Snowflake (strongly desired) or another cloud data warehouse such as BigQuery, Redshift, or Azure Synapse
- Proven experience working with large and complex datasets from multiple sources
- Hands-on experience with Tableau (desired) or other BI tools such as Power BI
- Strong SQL skills and good knowledge of relational databases (MariaDB, PostgreSQL)
- Experience with ETL / ELT and data integration processes
- Experience with PHP
- Analytical mindset, attention to detail, and ability to turn data into clear insights
- Team player with good communication skills
- English
- French
- Experience with Symfony
- Python for data processing
- dbt or similar data transformation tools
- Linux and Docker knowledge
- Experience in agriculture, food, or regulatory data domains
- Knowledge of Agrowin, Homologa, or similar sector software
For more than three decades, FoodChain ID has been at the forefront of the New Food industry, helping companies navigate increasing global demands for transparency, accountability, safety, and sustainability.
Skills Required
- Minimum 2-3 years of experience in data analytics, business intelligence, data integration, software development, or a related field
- Experience with data warehousing concepts, including dimensional modeling, star/snowflake schemas, and data marts
- Hands-on experience with Snowflake or another cloud data warehouse such as BigQuery, Redshift, or Azure Synapse
- Experience working with large and complex datasets from multiple sources
- Hands-on experience with Tableau or another BI tool such as Power BI
- Strong SQL skills and knowledge of relational databases such as MariaDB and PostgreSQL
- Experience with ETL/ELT and data integration processes
- Experience with PHP
- Analytical mindset and attention to detail
- Ability to turn data into clear insights
- Strong teamwork and communication skills
- English language proficiency
- French language proficiency
- Experience with Symfony
- Python for data processing
- dbt or similar data transformation tools
- Linux and Docker knowledge
- Experience in agriculture, food, or regulatory data domains
- Knowledge of Agrowin, Homologa, or similar sector software
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
FoodChain ID has been providing integrated food safety, quality and sustainability services to the global agrifoods industry since 1996. Serving more than 30,000 clients in over 100 countries, FoodChain ID provides expertise and technology-driven services that support the production of safe, ethical, and sustainable food throughout the world
