Mexico
Cummins
Softgic
1790 Senior Data Engineer AWS Redshift
Mexico
State of Mexico, Mexico
SQLPostgreSQLAWS
Automatic translation. Check the original.
About the opportunity
We are looking for a Senior Data Engineer to lead the modernization of an enterprise analytics platform by migrating reporting workloads from PostgreSQL to Amazon Redshift.
This position is ideal for professionals with experience in data platforms on AWS, report optimization, replication pipelines using CDC (Change Data Capture), and data quality assurance, rather than traditional ETL processes.
Responsibilities
- Lead the implementation and go-live of Amazon Redshift.
- Migrate reporting workloads from PostgreSQL to Redshift.
- Design and optimize analytical models, SQL queries, and materialized views.
- Validate and monitor replication pipelines using AWS DMS (CDC).
- Improve the performance, scalability, and data quality used for reporting.
- Implement reconciliation and data validation processes between different sources.
- Work closely with Product, Engineering, QA, and business teams.
- Create and maintain data dictionaries, KPI definitions, and reporting standards.
Requirements
Mandatory Requirements
- More than 5 years of experience as a Data Engineer.
- Solid experience with Amazon Redshift.
- Advanced proficiency in SQL.
- Experience working with PostgreSQL.
- Experience designing data models for analytics.
- Experience optimizing SQL queries for complex reports.
- Experience with AWS DMS or CDC replication processes.
- Experience implementing data validation and reconciliation processes.
- Experience developing reporting, dashboard, and business analytics solutions.
- Experience working with large data volumes.
- Experience in AWS.
- English level B2 or higher.
More opportunities with one profile
Want to be considered for more roles without repeating the whole process? Create your profile and be found by companies using Nort.
Create my profile
