Senior Data Engineer – Database Architecture, Design & Performance SOL-1791

SOFTGIC

Job Location:

Mexico City - Mexico

Monthly Salary: MXN 3100 - 3100

Experience Required: 5years

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

Este es un puesto de trabajo remoto.

The Senior Data Engineer is responsible for leading and supporting the database architecture data design database buildout optimization and performance improvement efforts for the Elections platform as part of the TEam team.

This role is focused on strengthening the foundation of the TEAM system by ensuring database changes are well-designed scalable performant supportable and aligned with the broader platform strategy. The role should support other TEam developers and data engineers by providing database design guidance query optimization schema review data modeling support and hands-on implementation for complex database changes.

The expectation is not simply to complete database tickets but to improve the overall quality reliability scalability and maintainability of the platforms database layer.

Definition of Success

Success will be measured by tangible improvements in database quality performance supportability and delivery confidence including:

Faster database issue diagnosis

Better-performing critical queries

Reduced production database risk

Fewer poorly designed schema changes

Improved migration quality

More consistent indexing and query review

Better support for PIR reporting and Redshift workloads

Clearer database ownership and standards

Reduced manual data repair risk

Improved developer confidence when making database changes

Stronger alignment between application design data quality and reporting architecture

Executive Expectation

The expectation is to leave the platforms database foundation materially better than it was found within the first 90 days. Success is not simply supporting database tickets. Success means improving database architecture strengthening design standards optimizing performance supporting developers and data engineers reducing operational risk and creating a scalable database foundation that supports TEam delivery reporting accuracy Redshift modernization and long-term platform stability.

Required Skills:

5 years of experience as a Data Engineer or in similar data engineering roles. Strong experience designing and implementing enterprise Data Quality frameworks. Hands-on experience with GX Core (Great Expectations) or similar tools such as Soda. Strong SQL skills and experience working with Aurora PostgreSQL and Amazon Redshift. Experience designing data validation rules reconciliation processes and observability solutions. Experience building and maintaining ETL pipelines and large-scale data workflows. Strong understanding of data modeling referential integrity synchronization and batch processing. Experience integrating data validation into CI/CD pipelines. Experience with Git and engineering best practices such as Rule-as-Code. Experience building dashboards alerts and reporting for operational monitoring. Strong analytical and problem-solving skills with experience performing root cause analysis. Experience collaborating with cross-functional engineering teams. Excellent communication and documentation skills.

Required Education:

System Engineer

Este es un puesto de trabajo remoto. The Senior Data Engineer is responsible for leading and supporting the database architecture data design database buildout optimization and performance improvement efforts for the Elections platform as part of the TEam team. This role is focused on strength...