Senior Data Engineer

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

Hybrid 3 days on-site in Charlotte, NC

Our client seeks a Senior Data Engineer to lead database architecture, data migration, and real-time data product initiatives supporting a modern cloud-based platform. The role will establish a scalable data foundation, migrate enterprise datasets from legacy systems, and implement governance and auditing to support compliance and downstream application teams.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $70.00 to $73.00/hr. w2

JN -092026-108571

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.

Experience Requirements

• Deep proficiency with PostgreSQL design, administration, optimization, and SQL.
• Proven enterprise data migration experience, preferably 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.

Education Requirements

• No formal degree requirement listed.