Senior Data Integration & SQL Engineering Specialist

Ingeniosi; México; On-site; MXN 900,000 - 1,300,000; Full time

Job summary

Ingeniosi is seeking a Senior Data Integration & SQL Engineering Specialist to modernize legacy data processes, optimize SQL queries, and build Python-based data pipelines. You will ensure data accuracy across multiple systems and collaborate with stakeholders to deliver reliable data workflows.

The role targets experienced SQL Developers, Data Engineers, ETL/Integration Engineers with hands-on Python development and strong data validation skills.

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 Jira.
• English proficiency: B2 or higher.

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.

Job description

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