Senior Data Engineer (AWS/PostgreSQL)

Location: Charlotte, NC, United States

Company

Technology staffing company supporting enterprise data and application modernization initiatives.

What you will do

• Design and build PostgreSQL databases, schemas, and data models for scalable application platforms.
• Lead Oracle-to-PostgreSQL migrations from on-premises environments to AWS RDS PostgreSQL while maintaining data integrity and minimizing downtime.
• Build and optimize real-time data pipelines using Apache Kafka, Apache Flink, and Apache Hudi or comparable lakehouse technologies.
• Implement change data capture, audit logging, data lineage, validation, and data quality controls.
• Develop data catalogs, schema documentation, and architecture documentation for engineering and application teams.
• Partner with developers, architects, infrastructure teams, and business stakeholders while applying security, access control, encryption, and compliance practices.

Requirements

• Strong hands-on PostgreSQL expertise, including architecture, schema design, SQL, administration, performance tuning, and optimization.
• Experience with large-scale enterprise database migrations, preferably Oracle-to-PostgreSQL migrations.
• Hands-on AWS experience with RDS, EC2, networking, and security.
• Experience with Apache Kafka and Apache Flink for streaming and real-time data processing.
• Experience with Apache Hudi, Delta Lake, or comparable lakehouse technology.
• Knowledge of relational database design, normalized and denormalized data modeling, CDC, audit logging, data lineage, and change tracking.

Nice to have

• AWS Glue, Lambda, and Step Functions.
• Data quality and validation frameworks.
• Terraform or CloudFormation.
• Application modernization or legacy platform replacement experience.
• Knowledge of data security, encryption, GDPR, or HIPAA requirements.

Culture & Benefits

• Cross-functional collaboration with application, architecture, infrastructure, and business teams.
• Work focused on next-generation application platforms and large-scale data modernization.