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 (México)
🏢 Ingeniosi
📍 México