We are looking for a highly skilled Senior Data Integration & SQL Engineering Specialist with strong hands-on experience in Microsoft SQL Server, Python, and data integration.
In this role, you will modernize legacy data processes, optimize complex SQL queries, develop Python-based data pipelines, and ensure data accuracy across multiple systems.
The idóneo candidate is a hands-on engineer who enjoys solving complex data challenges, improving existing solutions, and building reliable, production-ready data workflows.
This opportunity is particularly well suited for experienced SQL Developers, Data Engineers, ETL Developers, and Data Integration Engineers.
Key Responsibilities
- Develop, maintain, and optimize complex queries using Microsoft SQL Server and Azure SQL.
- Refactor and modernize legacy SQL queries, stored procedures, and data processing workflows.
- Perform SQL performance tuning, troubleshooting, and query optimization.
- Build and maintain Python-based data integration and transformation pipelines.
- Process and transform CSV, Excel, delimited,



and structured text files.
- Use Pandas and OpenPyXL for data manipulation, validation, and automation.
- Develop and maintain ETL processes to integrate data from multiple sources.
- Investigate data discrepancies and perform root cause analysis.
- Execute data reconciliation and validation to ensure accuracy and consistency.
- Implement data quality checks and support regression testing.
- Collaborate with technical teams and business stakeholders to understand requirements and deliver effective solutions.
- Follow software development best practices, including version control, code reviews, testing, and documentation.

Required Qualifications
- 5+ years of professional experience in SQL development, data engineering, ETL, or data integration.
- Strong hands-on experience with Microsoft SQL Server, advanced T-SQL, and Python-based data processing.
- Advanced hands-on experience with Microsoft SQL Server and/or

📌 Senior Data Integration (México)
🏢 Ingeniosi
📍 México