Coherent Solutions

Data Engineer (Agribusiness Software Solutions)

Coherent Solutions  •  Mexico (Hybrid)  •  19 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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;
  • Familiarity with BI ecosystems (Power BI, Luzmo, Tableau) and provisioning datasets for self‑service reporting;
  • Strong understanding of Azure security fundamentals (networking, managed identities, RBAC);
  • Proven experience designing and optimizing data flows using Azure Synapse Analytics, including dedicated SQL pools and serverless querying;
  • English level: B1+ (Intermediate) or higher;

Nice to Have

  • Microsoft Certified: Azure Data Engineer Associate (DP‑203) or higher;
  • Exposure to Synapse Analytics or Databricks;
  • Knowledge of .NET 6+/C# or Python for custom ADF activities or utility scripts;
  • Experience with cost‑governance / FinOps in Azure;

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;
  • 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.
Coherent Solutions

About Coherent Solutions

Coherent Solutions is a digital product engineering company focused on empowering business success. Our global team of talented professionals seamlessly collaborate to deliver innovative solutions that drive measurable business impact. As a preferred digital product engineering partner and advisor, we leverage our expertise in software product development to help clients thrive in the digital age.

•‎ 30 years in business

•‎ 1000+ projects completed

•‎ 95% client retention

•‎ 10 global locations

•‎ 1700+ global employees

Let’s discuss your project! Schedule a consultation on https://www.coherentsolutions.com.

Coherent Solutions. Empowering Business Success.

Industry
IT & Software
Company Size
1,001-5,000 employees
Headquarters
St Louis Park, Minnesota
Year Founded
1995
Social Media