Data Engineer

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

Title: Data Engineer

Location: Houston, TX
Rate: $65-70/hour

Job Summary

We are seeking an experienced Data Engineer to support transactional database engineering, database modernization, and cloud-based data platform initiatives. The role focuses on SQL Server assessment, PostgreSQL/Aurora migration, data modeling, and the development of reliable, scalable data solutions using Amazon S3, Databricks, and DevOps practices.

The ideal candidate will have experience modernizing database environments, implementing data engineering best practices, and supporting secure, reliable data access across transactional, integration, and analytical systems.

Key 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.

Required Qualifications and Skills

• 5+ years of experience in data engineering, database 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 engineering or database environments.
• Knowledge of transactional database engineering and database modernization.
• Experience assessing SQL Server databases and evaluating migration requirements.
• Experience with PostgreSQL and/or Amazon Aurora migration initiatives.
• Strong understanding of data modeling, database structures, and data dependencies.
• Ability to analyze data requirements and support reliable data integration across systems.
• Strong analytical, troubleshooting, documentation, and cross-functional collaboration skills.

Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance.