Remote Analytics Engineer - SQL & Data Modeling

IXO Inc.; France; À distance; EUR 78 000 - 129 000; Temps partiel

Résumé du poste

IXO Inc. is seeking an analytics engineer to build analytical cases from raw tables to tested data models and to write reference queries with clear explanations of modeling and query decisions.

You will assess SQL for correctness and warehouse costs, and you will identify misleading aggregations, invalid joins, and expensive execution choices. Remote, part-time engagement with 10+ hours weekly. USD hourly compensation.

Qualifications

• At least 2 years of professional analytics engineering or SQL-intensive analytics.
• Expert joins, window functions, CTEs and query optimization.
• Hands-on BigQuery, Snowflake, Redshift or comparable warehouse work.

Responsabilités

• Build analytical cases progressing from raw tables to tested data models.
• Write reference queries with explanations of modeling and query decisions.
• Assess generated SQL for correct results and reasonable warehouse costs.
• Find misleading aggregations, invalid joins and expensive execution choices.

Connaissances

SQL

Analytical engineering

Query optimization

Window functions

CTEs

Joins

Documentation

Outils

BigQuery

Snowflake

Redshift

Description du poste

IXO Inc. is seeking an analytics engineer to build analytical cases from raw tables to tested data models and to write reference queries with clear explanations of modeling and query decisions.

You will assess SQL for correctness and warehouse costs, and you will identify misleading aggregations, invalid joins, and expensive execution choices. Remote, part-time engagement with 10+ hours weekly. USD hourly compensation.