About the Role

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 adecuado 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 Azure SQL .
- Strong proficiency in T-SQL, stored procedures, CTEs, window functions, and complex SQL queries.
- Proven experience in SQL query optimization, performance tuning, and troubleshooting.
- Experience refactoring and modernizing existing SQL solutions.
- Hands-on Python development experience for data processing, automation, and integration.
- Practical experience with Pandas and OpenPyXL .
- Experience developing and maintaining ETL pipelines and data integration processes.
- Experience processing CSV, Excel, and structured text files.
- Strong knowledge of data validation, reconciliation, and data quality practices.
- Experience with Git and version control workflows.
- Familiarity with Agile methodologies and tools such as Jira.
- Strong analytical, problem-solving, and communication skills.
- English proficiency: B2 or higher.

Nice-to-Have Qualifications
- Experience in healthcare distribution, logistics, or supply chain environments.
- Knowledge of EDI X12 transactions, particularly 867, 844, 849, or 852.
- Experience with chargebacks, rebates, contract pricing, or financial reconciliation.
- Familiarity with Master Data Management (MDM), deduplication, and entity resolution.
- Experience with fuzzy matching tools such as RapidFuzz.
- Knowledge of automated testing frameworks such as PyTest.
- Experience working with sensitive data or regulated environments.
- Familiarity with AI-assisted development tools and responsible coding practices.

What We're Looking For We are seeking a technically strong, detail-oriented professional who can independently develop, troubleshoot, and improve complex data solutions.

The successful candidate will combine deep SQL expertise with practical Python development skills and a strong understanding of data integration, reconciliation, and quality.

If you enjoy modernizing data systems, solving complex SQL challenges, and building reliable data pipelines, we'd love to hear from you!

📌 Senior Data Integration & SQL Engineering Specialist (México)
🏢 Ingeniosi
📍 México