16 nov
|
ConsultNet Technology Services and Solutions
|
México
16 nov
ConsultNet Technology Services and Solutions
México
Data Engineer (SQL Server / SSIS and Cloud Migration) Nearshore Remote (Latin America) | Long-term project
About the Role Our client is a growing food distribution and manufacturing company in the middle of a multi-year move from an on-premises SQL Server environment to a modern Azure cloud platform. The business still runs on the legacy platform every day while that move happens, and it still needs new reports, fixes, and enhancements.
In this role you'll keep the legacy platform healthy. You'll support and enhance the SQL Server and SSIS workloads that connect the ERP and operational systems, handle day-to-day requests, and help cross-train a small, close-knit data engineering team.
This is not a dead-end legacy seat. As you get comfortable, you'll move into migration work on Azure, Databricks, and Airflow and learn the new platform alongside the team. If you already know the cloud side, you'll contribute there sooner.
What You'll Do
- Support, troubleshoot, and maintain on-premises SQL Server databases and SSIS packages that move data between the ERP and other business applications
- Build enhancements and new requests on the legacy platform so the business isn't waiting on the cloud migration
- Write and tune complex T-SQL, including stored procedures, views, and queries
- Monitor scheduled jobs and loads, and resolve failures quickly
- Document legacy processes so knowledge is shared across the team
- Help migrate legacy tables and workloads to Azure (Data Factory, Databricks, ADLS, Airflow)
- Validate migrated data against legacy sources with data quality checks and reconciliation
- Adopt modern team practices as they roll out, including GitHub, CI/CD, and Terraform
- Bring ideas for using AI tools to work faster and smarter
- Explain data issues clearly to business users in Finance, Operations, Sales, and Supply Chain
What You'll Bring
- 5+ years in data engineering or database development
- Deep, hands-on SQL Server experience: advanced T-SQL, stored procedures, and performance tuning
- Strong SSIS experience: building, maintaining, and troubleshooting packages in production
- Experience supporting data integrations with an ERP or other core business systems
- A solid grasp of data warehousing concepts, including dimensional modeling
- Comfort using AI coding tools (Claude, Copilot, Windsurf, or similar) in daily work
- Strong written and spoken English, with working hours that overlap US Eastern time
Nice to Have
- Azure Data Factory, Databricks (PySpark), ADLS
- Apache Airflow, Python, GitHub, CI/CD, or Terraform
- Experience with NetSuite or another ERP
- Experience on a project migrating on-premises systems to the cloud
Interview Process A short phone screen, then a 60 to 90 minute skills assessment. You're expected to use AI tools on the assessment; the focus is on your reasoning and how you explain your approach. About ConsultNet ConsultNet is an IT staffing and consulting firm that connects skilled technology professionals with organizations across the US and Latin America. Through our nearshore delivery team, we place top Latin American talent on meaningful, long-term engagements with US companies, backed by competitive pay, benefits, and real support.
ConsultNet is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by law.
📌 Data Engineer (SQL Server / SSIS and Cloud Migration) Nearshore (México)
🏢 ConsultNet Technology Services and Solutions
📍 México