← All jobs

Data Engineer (Agribusiness Software Solutions)

Coherent Solutions · Mexico

onsitefull-timemid level

About this role

Company Background

Our client is a company that delivers integrated software and tools for the agricultural business. As part of a leading global software group, the company supports the diversified grain industry and agricultural co-ops with best-in-class solutions covering business management, commodity management, agronomy, trading, patronage, and analytics.

Project Description

The project focuses on owning the end-to-end data flow for the client’s Data Analytics Platform (DAP). The platform ingests structured data (XML/JSON) into Azure Data Lake, orchestrates transformations using Azure Data Factory, and models curated data in Azure SQL Managed Instance with read-only replicas for reporting.

Technologies

  • Microsoft Azure
  • ADLS Gen2
  • Azure Data Factory (ADF v2)
  • Azure SQL Managed Instance

What You'll Do

  • Build and maintain ADF pipelines to ingest XML/JSON data into ADLS Gen2, including schema mapping, cleansing, and incremental loads;
  • Design and optimize data models in Azure SQL Managed Instance (indexes, partitioning, read-only replicas);
  • Configure and test backup, geo-replication, and disaster recovery strategies (RPO/RTO);
  • Automate infrastructure and deployments using Infrastructure-as-Code and CI/CD pipelines;
  • Provision and support datasets for self-service BI and reporting;
  • Implement monitoring, alerting, and cost-optimization dashboards;
  • Continuously tune platform performance, reliability, and cost efficiency;

Job Requirements

  • 5+ years of experience designing and building data solutions on Microsoft Azure;
  • 2+ years of hands-on experience with ADLS Gen2 and Azure Data Factory (ADF v2);
  • Expert-level T-SQL skills and performance tuning on Azure SQL Managed Instance or SQL Server;
  • Hands-on experience with Infrastructure-as-Code (Bicep or Terraform) and CI/CD;
  • Proven experience with backup, geo-replication, and disaster recovery in Azure;
  • Strong understanding of Azure security fundamentals;
  • Experience with Azure Synapse Analytics;
  • English level: B1+ (Intermediate) or higher;

What Do We Offer

The global benefits package includes:

  • Technical and non-technical training for professional and personal growth;
  • Internal conferences and meetups to learn from industry experts;
  • Support and mentorship from an experienced employee to help you professional grow and development;
  • Internal startup incubator;
  • Health insurance;
  • English courses;
  • Sports activities to promote a healthy lifestyle;
  • Flexible work options, including remote and hybrid opportunities;
  • Referral program for bringing in new talent;
  • Work anniversary program and additional vacation days.

About Coherent Solutions

Coherent Solutions is a digital product engineering company focused on empowering business success. Our global team of 1700+ talented professionals collaborate seamlessly to deliver innovative solutions that drive measurable business impact. Headquartered in Minneapolis, USA, the company’s core competencies across 10 locations worldwide include product software development, IT consulting, data and analytics, machine learning, mobile app development, DevOps, Salesforce, and more. We grow a team of advisors, not just order takers, and strive to make the company a place for career growth and opportunities. If you want to grow your core competencies, share your passion and be sure that every contribution is evaluated, we are on the same page.

Jobb.ai is an independent skill benchmarking platform. Applications are submitted on the employer's official website.