Design and develop interactive analytical dashboards using Snowflake and BI tools to provide market and regulatory intelligence. Integrate and model complex datasets while maintaining web functionalities using Symfony PHP to support dashboard applications.
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.
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.
Main responsibilities
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
Required profile
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
Nice to have
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
Company Overview 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.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”
— Sarah J.
·
Marketing Manager
★★★★★
Verified
