Senior Data Integration & SQL Engineer

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

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.