About the role
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
*Note: Applicants need to be legal residents in Spain. All applications outside Spain will be automatically disqualified!
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.