Data Engineer

Simarn Solutions; Houston (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Simarn Solutions is seeking a Data Engineer in Houston, TX, to modernize SQL Server databases and migrate to PostgreSQL or Amazon Aurora PostgreSQL. You will design scalable data models and build cloud data solutions with Databricks and S3.

The role requires 5–9 years of data engineering experience and hands-on work with Databricks, S3, and DevOps practices, including CI/CD and automated testing. Collaboration with architects and product teams is essential.

Qualifications

• 5–9 years of data or database engineering experience.
• Hands-on with Databricks, Amazon S3, and DevOps practices.
• Strong SQL skills in transactional relational databases.
• Experience assessing SQL Server environments for modernization.
• Experience migrating databases to PostgreSQL or Aurora PostgreSQL.
• Understanding of relational data modeling, indexing, and performance.
• Experience with Git, CI/CD, automated testing, and controlled deployments.
• Experience validating migration accuracy and managing production cutover and recovery.

Responsibilities

• Assess existing SQL Server databases, including schemas and dependencies.
• Plan and execute migrations to PostgreSQL or Aurora PostgreSQL, including schema conversion.
• Design and optimize transactional data models for performance and scalability.
• Develop and maintain data pipelines using Databricks and Amazon S3.
• Support database modernization while separating transactional, integration, and analytical data concerns.
• Implement CI/CD pipelines and automated schema validation.
• Perform SQL tuning, indexing, reconciliation, and production troubleshooting.
• Collaborate with application teams and stakeholders to deliver reliable data solutions.

Skills

Strong SQL

Relational data modeling

Data engineering

Migration planning

Tools

Databricks

Amazon S3

DevOps practices

Git

CI/CD

Job description

Location: Houston, TX

Experience: 5–9 years

Employment Type: W2 only

Eligibility: U.S. Citizens and Green Card holders only

Mandatory Skills: Amazon S3, Databricks, DevOps

About the Role:

We are seeking a Data Engineer with hands‑on experience in transactional database engineering, SQL Server assessment, and migration to PostgreSQL or Amazon Aurora PostgreSQL. This role involves modernizing database platforms, designing reliable data models, and building scalable cloud data solutions.

Key Responsibilities

• Assess existing SQL Server databases, including schemas, stored procedures, dependencies, performance, and migration readiness.
• Plan and execute migrations to PostgreSQL or Amazon Aurora PostgreSQL, including schema conversion, data validation, cutover, and rollback.
• Design and optimize transactional data models to support application performance, integrity, and scalability.
• Develop and maintain data pipelines using Databricks and Amazon S3.
• Support database modernization while separating transactional, integration, and analytical data concerns.
• Implement CI/CD pipelines, automated schema validation, and controlled database release practices.
• Perform SQL tuning, indexing, reconciliation, and production troubleshooting.
• Collaborate with application teams, architects, and business stakeholders to deliver reliable data solutions.

Required Qualifications

• 5–9 years of relevant data engineering or database engineering experience.
• Hands‑on experience with Databricks, Amazon S3, and DevOps practices.
• Strong SQL skills and experience engineering transactional relational databases.
• Experience assessing SQL Server environments and identifying modernization requirements.
• Hands‑on experience migrating databases to PostgreSQL or Amazon Aurora PostgreSQL.
• Strong understanding of relational data modeling, schema design, indexing, and performance optimization.
• Experience with Git, CI/CD, automated testing, and controlled deployments.
• Experience validating migration accuracy and managing production cutover and recovery.

Preferred Qualifications

• Experience with Terraform and database infrastructure automation.
• Knowledge of medallion or lakehouse architectures, data catalogs, and analytical data products.
• Familiarity with domain‑oriented architecture, API‑based data access, event‑driven integration, and data contracts.
• Experience in energy, trading, retail, financial services, or another data‑intensive regulated environment.

This opportunity is available only on W2 for U.S. Citizens and Green Card holders. No C2C