Data Engineer (Data Strategy & Platforms)

Elios, Inc.; Houston (TX); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Elios, Inc. is seeking a Data Engineer to design and optimize modern data platforms within the Microsoft data ecosystem. You will work across enterprise environments to enable advanced analytics, reporting, and data-driven decision-making in Financial Services and Energy contexts.

The role emphasizes scalable, cloud-native architectures, data quality frameworks, and collaboration with analytics teams to deliver robust semantic models and Power BI integrations.

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.

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

Skills

SQL

PySpark

Power BI

Azure Data Factory

Azure Synapse

Microsoft Fabric

Data Modeling

CDC/SCD

Git

Tools

Git

Azure DevOps

Spark Notebooks

OneLake

Job description

Data Engineer (Data Strategy & Platforms)

Location Houston, TX

Workplace Type Hybrid

Position Type Permanent

Sector Technology

Data Engineer (Data Strategy & Platforms)

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

About the Role

You'll 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's 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