Data Engineer – Data Modernization & Database Transformation

Position Overview

We are seeking experienced Data Engineers to join a large-scale data modernization initiative for a Financial Services client. The project focuses on transforming and modernizing legacy SQL-based systems into a scalable and maintainable PostgreSQL-centric architecture.

The idóneo candidate will have strong experience analyzing existing database models, understanding evolving business requirements, and designing and implementing modern relational data structures that support current and future business needs. This role requires engineers who can work collaboratively with Business Analysts, Project Managers, Database Architects, Developers, and UX teams in an environment where requirements are continuously refined throughout the project lifecycle.

This is a highly collaborative role requiring both strong technical expertise and excellent communication skills. Successful candidates will be comfortable working with partially defined requirements, contributing to solution design discussions, and helping shape the future-state data architecture.

Responsibilities

Analyze and understand existing legacy database structures, data models, and business processes.

Collaborate with Business Analysts, Architects, and stakeholders to translate evolving business requirements into scalable database solutions.

Design, develop,



and maintain modern relational data models in PostgreSQL.

Support database modernization and migration initiatives from legacy SQL platforms.

Develop and optimize SQL queries, stored procedures, views, and database objects.

Participate in data modeling activities, including conceptual, logical, and physical design.

Evaluate and implement hybrid relational and NoSQL approaches when appropriate to support business requirements.

Ensure data integrity, consistency, and performance across the solution.

Conduct data analysis and validation to support successful migration and transformation efforts.

Troubleshoot and resolve database-related issues, performance bottlenecks, and data quality concerns.

Work closely with cross-functional teams in an Agile environment to deliver incremental solutions.

Contribute to technical discussions and provide recommendations for improving system architecture and database design.

Key Success Factors

Ability to quickly understand complex legacy systems.

Strong communication and stakeholder management skills.

Comfort working with ambiguity and evolving requirements.

Strong database design and data architecture mindset.

Proactive approach to identifying and proposing improvements.

Collaborative attitude within large multidisciplinary teams.

📌 Data Engineer-Data Modernization & Database Transformation for Data Migration Bilingual (Ciudad de México)
🏢 NORTHWARE SA DE
📍 Ciudad de México