Data Engineer: Cloud Modernization & Lakehouse

Diverse Lynx, LLC; Houston (TX); On-site; USD 90,000 - 96,000; Full time

Job summary

Diverse Lynx LLC is seeking a Data Engineer for Houston, TX to support transactional database engineering, modernization, and cloud-based data platform initiatives. You will work on SQL Server assessment, PostgreSQL/Aurora migrations, data modeling, and building reliable data solutions using Amazon S3 and Databricks, with emphasis on secure, scalable data access across systems.

Candidates should have 5+ years in data engineering and a track record of modernizing databases and CI/CD for data

Qualifications

• 5+ years of experience in data engineering or a related technical discipline.
• Hands-on experience with Amazon S3.
• Experience with Databricks and modern data engineering platforms.
• Experience with DevOps practices supporting data environments.
• Knowledge of PostgreSQL or Amazon Aurora migrations.
• Strong data modeling and data dependencies.

Responsibilities

• Assess existing SQL Server environments, including database structures, dependencies, performance, and migration considerations.
• Support database migration initiatives involving PostgreSQL and Amazon Aurora.
• Design and implement data models that support transactional processing, integration, and analytical use cases.
• Contribute to database modernization initiatives and cloud-based data engineering solutions.
• Develop and maintain data engineering solutions using Amazon S3 and Databricks.
• Support lakehouse and medallion architecture patterns for organizing, processing, and managing data.
• Implement data quality, validation, and schema management practices to improve data reliability and consistency.
• Apply DevOps and CI/CD practices to database and data engineering workflows.
• Support infrastructure automation and environment management using tools such as Terraform.
• Contribute to automated schema validation, version control, deployment automation, and controlled release processes.
• Collaborate with architecture, application, and data teams to establish effective data access and integration patterns.
• Support API-based data access, event-driven integration, data contracts, and domain-oriented architecture principles.
• Help establish appropriate separation between transactional databases, integration services, and analytical data platforms.
• Maintain technical documentation covering data models, migration processes, system dependencies, and operational procedures.

Skills

Data modeling

Analytical thinking

Cross-functional collaboration

Troubleshooting

Documentation

SQL Server

PostgreSQL

Aurora

Tools

Amazon S3

Databricks

Terraform

Job description

Diverse Lynx LLC is seeking a Data Engineer for Houston, TX to support transactional database engineering, modernization, and cloud-based data platform initiatives. You will work on SQL Server assessment, PostgreSQL/Aurora migrations, data modeling, and building reliable data solutions using Amazon S3 and Databricks, with emphasis on secure, scalable data access across systems.

Candidates should have 5+ years in data engineering and a track record of modernizing databases and CI/CD for data