Senior Data Infrastructure Engineer – SQL (USD 7-8K/month CONTRACTOR)

NOUS LATAM

United States

Remote

USD 120,000 - 210,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

NOUS LATAM is seeking a highly experienced Data Infrastructure Engineer to build a platform enabling seamless queries across diverse database engines. The role focuses on SQL dialects, query transformation, and data federation to ensure consistent results and high performance.

You will work on interoperability, connectors, and federation layers, tackling compatibility challenges and pushing capability across BigQuery, Databricks, Snowflake, and more.

Qualifications

  • Strong experience with SQL, database systems, and data infrastructure.
  • Hands-on experience working across multiple database engines or data platforms.
  • Practical experience with SQL transpilation, parsing, or AST manipulation.
  • Cross-database compatibility, migration validation, or result parity testing.
  • Query federation, routing, pushdown, or execution offloading.
  • Database connectors, drivers, or adapters.
  • Solid understanding of SQL dialect differences, data type mapping, and query semantics.
  • Production experience with major data platforms like BigQuery, Databricks, Snowflake.

Responsibilities

  • Design and implement SQL transpilation and query transformation mechanisms across different database engines and SQL dialects.
  • Develop and maintain query routing and engine-selection logic based on query characteristics, metadata, and execution costs.
  • Ensure query result consistency across different engines, addressing differences in data types, numeric precision, type coercion, and SQL semantics.
  • Build mechanisms for cross-engine validation, schema comparison, data diffing, and result parity testing.
  • Develop and integrate database connectors, drivers, and federation layers, including query pushdown and execution offloading.
  • Handle unsupported SQL features, dialect incompatibilities, and fallback execution strategies.
  • Work with modern data infrastructure technologies and contribute to reliability and scalability of distributed data processing workflows.

Skills

SQL
Data infrastructure
Cross-engine compatibility
Query federation
SQL dialect differences

Tools

JDBC
ODBC
dbt adapters

Job description

We are looking for a highly experienced Data Infrastructure Engineer to help build and improve a technology platform that enables queries to work seamlessly across different database engines and data platforms. This role requires strong expertise in SQL dialects, query transformation, cross-engine compatibility, and data federation. You will work on the challenges of translating, routing, and executing queries across heterogeneous database environments while ensuring consistent results, data integrity, and performance. We are particularly interested in engineers who have worked on database interoperability, SQL transpilers, query federation, database migration, or connectors between different query engines. This is not a traditional database administration or database performance tuning role. We are looking for someone who understands the boundaries and behavioral differences between database engines and has hands-on experience solving compatibility challenges across them.

Key Responsibilities
  • Design and implement SQL transpilation and query transformation mechanisms across different database engines and SQL dialects.
  • Develop and maintain query routing and engine-selection logic based on query characteristics, metadata, and execution costs.
  • Ensure query result consistency across different engines, addressing differences in data types, numeric precision, type coercion, and SQL semantics.
  • Build mechanisms for cross-engine validation, schema comparison, data diffing, and result parity testing.
  • Develop and integrate database connectors, drivers, and federation layers, including query pushdown and execution offloading.
  • Handle unsupported SQL features, dialect incompatibilities, and fallback execution strategies.
  • Work with modern data infrastructure technologies and contribute to the reliability and scalability of distributed data processing workflows.
Required Qualifications
  • Strong experience with SQL, database systems, and data infrastructure.
  • Hands-on experience working across multiple database engines or data platforms.
  • Practical experience with at least one of the following:
  • SQL transpilation, parsing, or AST manipulation.
  • Cross-database compatibility, migration validation, or result parity testing.
  • Query federation, routing, pushdown, or execution offloading.
  • Database connectors, drivers, or adapters.
  • Strong understanding of SQL dialect differences, data type mapping, type coercion, and query semantics.
  • Production experience with at least one major data platform, preferably Google BigQuery or Databricks/Spark.
  • Ability to investigate and resolve behavioral differences between database engines, ensuring equivalent query results.
Highly Relevant Technologies & Experience
  • SQL Transpilation & AST: SQLGlot, Apache Calcite, Substrait, custom SQL parsers and AST manipulation.
  • Query Engines: DuckDB, DataFusion, Trino, Presto, Spark SQL, ClickHouse.
  • Data Platforms: Google BigQuery, Databricks, Snowflake.
  • Data Integration & Connectors: JDBC, ODBC, dbt adapters, Fivetran, Airbyte.
  • Data Formats & Table Formats: Apache Arrow, Apache Iceberg, Delta Lake.
  • Programming Languages: Python, Rust, Java, or Scala.
What Would Make You Stand Out
  • Contributions to open-source projects such as SQLGlot, Apache Arrow, DataFusion, Iceberg, DuckDB, Trino, Ibis, or dbt adapters.
  • Experience building automated data comparison or migration validation frameworks.
  • Experience ensuring that the same SQL query produces equivalent results across different database engines.
  • Experience implementing query routing, engine selection, cost estimation, or query offloading mechanisms.
  • Experience developing database connectors, federation layers, or custom SQL dialect extensions.
Ideal Background

Engineers who have worked at companies building database interoperability, data integration, query federation, SQL transformation, or database migration products will be particularly interesting. Relevant backgrounds may include data infrastructure teams at companies such as Datafold, dbt Labs, Tobiko, Starburst, Databricks, Google BigQuery, Fivetran, Airbyte, Dremio, Materialize, SingleStore, or Firebolt. The ideal candidate is someone who has worked across database engines, understands their differences at a technical level, and has built practical solutions to make them interoperate reliably.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Middle Software Engineer — Query Engine / Data Platform
Middle Software Engineer — Query Engine / Data Platform

OpportuLand • United States

Hybrid
USD 101,000 - 135,000
Senior Data Engineer
Senior Data Engineer

Zoominfo • United States

Remote
USD 110,000 - 170,000
Remote work
Senior Software Engineer — Query Engine / Data Platform
Senior Software Engineer — Query Engine / Data Platform

OpportuLand • United States

Remote
USD 101,000 - 156,000
Senior Data Engineer
Senior Data Engineer

RelMap Consulting • United States

Remote
USD 96,000 - 110,000
Senior Data Engineer
Senior Data Engineer

Insomniac Design • United States

On-site
USD 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Durham (NC)

On-site
USD 100,000 - 130,000
Data Infrastructure Engineer, Query Engine
Data Infrastructure Engineer, Query Engine

Clera Labs, Inc. • San Mateo (CA)

On-site
USD 150,000 - 210,000
Visa sponsorship
Senior Data Engineer 4 4P/259
Senior Data Engineer 4 4P/259

4P Consulting Inc. • Atlanta (GA)

On-site
USD 120,000 - 150,000
Senior Data Engineer (SQL, dbt)
Senior Data Engineer (SQL, dbt)

externaljobboards • United States

Hybrid
USD 120,000 - 180,000
Healthcare
Remote work options
Equipment provided
Data Engineer (in person)
Data Engineer (in person)

SEP • Westfield (IN)

On-site
USD 90,000 - 110,000
Flexible work schedules
Opportunities to learn and develop
Community of friendly peers
+1