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 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!

#J-18808-Ljbffr

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