Senior Data Engineer: Real-Time Data, PostgreSQL & AWS

Eliassen Group; Charlotte (NC); Hybrid; Confidential; Full time

Benefits offered by this job

Medical, Dental, Vision benefits

401k with company matching

Life insurance

Job summary

The Eliassen Group is seeking a Senior Data Engineer in Charlotte, NC to lead database architecture, data migration, and real-time data initiatives on a modern cloud platform. You will build a scalable data foundation, migrate enterprise datasets from legacy systems, and implement governance for compliance and downstream teams.

Ideal candidates have strong PostgreSQL expertise, hands-on AWS experience, and experience with Kafka, Flink, and Hudi/Delta Lake.

Qualifications

• Deep proficiency with PostgreSQL design, administration, optimization, and SQL.
• Proven enterprise data migration experience, Oracle to PostgreSQL, with strong change management.
• Hands-on AWS experience including RDS, EC2, networking, and security configurations.
• Experience with streaming and real-time processing using Kafka and Flink, plus data lakehouse tech such as Hudi or Delta Lake.
• Data modeling for normalized and denormalized schemas across OLTP and analytical workloads.
• Implemented CDC patterns and audit logging for lineage and change tracking.
• Strong communication and documentation skills for architectures and schemas.
• Preferred: AWS Glue, Lambda, or Step Functions; data quality frameworks; Terraform or CloudFormation; application modernization; understanding of data security, encryption, and compliance such as GDPR or HIPAA.

Responsibilities

• Design and implement PostgreSQL databases and schemas for performance, scalability, and maintainability.
• Lead migration of large Oracle databases to AWS RDS for PostgreSQL with data integrity and minimal downtime.
• Build and optimize real-time data products using Apache Kafka, Apache Flink, and Apache Hudi.
• Analyze and optimize existing schemas, recommending structural improvements while ensuring integrity.
• Design and implement change data capture and comprehensive auditing solutions.
• Develop and maintain a data catalog and schema documentation for application integration.

Skills

PostgreSQL design

Oracle migration

AWS

Kafka

Flink

Hudi/Delta Lake

Data modeling

CDC patterns

Communication

Tools

AWS Glue

Terraform

CloudFormation

Step Functions

Job description

The Eliassen Group is seeking a Senior Data Engineer in Charlotte, NC to lead database architecture, data migration, and real-time data initiatives on a modern cloud platform. You will build a scalable data foundation, migrate enterprise datasets from legacy systems, and implement governance for compliance and downstream teams.

Ideal candidates have strong PostgreSQL expertise, hands-on AWS experience, and experience with Kafka, Flink, and Hudi/Delta Lake.