Data Engineer (Data Strategy & Platforms)

Elios AI; Houston (TX); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Elios AI is seeking a Data Engineer to design and optimize modern data platforms in Houston, Texas. This hybrid, full-time position focuses on scalable, cloud-native solutions that enable advanced analytics and data-driven decisions.

The ideal candidate has 3 to 7+ years of relevant experience with Microsoft Fabric, SQL, and working with data environments, aiming to enhance client outcomes through innovative data architectures.

Qualifications

• 3 to 7+ years of data engineering experience using Microsoft and Azure-based technologies.
• Strong hands-on expertise with Microsoft Fabric and related tools.
• Advanced proficiency in SQL, T-SQL, and modern data modeling techniques.

Responsibilities

• Design and implement scalable data architectures using Microsoft Fabric.
• Build and optimize ingestion and transformation pipelines.
• Support client engagements through workshops and roadmap development.

Skills

Microsoft Fabric

SQL

PySpark

Data modeling techniques

Stakeholder management

Tools

Azure Data Factory

Azure Synapse

Power BI

Job description

Data Engineer (Data Strategy & Platforms)

Location: Houston, Texas (hybrid) | Type: Full Time | Experience: 3 to 7+ years

About the Role

You will work with clients to design, build, and optimize modern data platforms in the Microsoft data ecosystem. The focus is on scalable, cloud-native solutions that support advanced analytics, reporting, and data-driven decision-making across enterprise environments.

This role sits in high-impact transformation work across Financial Services and Energy. It is a recurring need around data strategy and platform skills, and experience in the ETRM space is especially relevant.

Responsibilities

Design and implement scalable data architectures using Microsoft Fabric, including OneLake, Lakehouses, Warehouses, Pipelines, Spark, and Shortcuts.

Build and optimize ingestion and transformation pipelines using Fabric Data Pipelines, Dataflows Gen2, PySpark, SQL, Azure Data Factory, and Azure Synapse.

Create reusable frameworks for data quality, metadata-driven processing, schema management, and incremental ETL/ELT patterns.

Partner with analytics and business teams to deliver performant semantic models, reporting solutions, and Power BI integrations.

Support client engagements through workshops, roadmap development, effort estimation, and stakeholder communication.

Qualifications

3 to 7+ years of data engineering experience using Microsoft and Azure-based technologies.

Strong hands-on expertise with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Pipelines, Spark Notebooks, and Power BI integration.

Advanced proficiency in SQL, T-SQL, PySpark/Python, and modern data modeling techniques such as star schema, snowflake, and data vault.

Experience implementing CDC, SCD, incremental processing, partitioning strategies, and performance optimization for large-scale data environments.

Excellent communication and stakeholder management skills, ideally from consulting or client-facing environments.

Preferred

Experience in or around ETRM / energy trading data environments.

Experience with Azure Event Hub, IoT Hub, Microsoft Purview, and Azure Key Vault.

Exposure to CI/CD and DevOps practices, including Git integration and deployment pipelines.

Knowledge of streaming ingestion and real-time analytics architectures.

Experience supporting data science workloads and feature store implementations.

Management consulting experience within Financial Services or Energy.