Data Engineer - Fabric, PySpark, Lakehouse (Onsite MO)

Derex Technologies Inc; Jefferson City (MO); On-site; USD 120,000 - 150,000; Full time

Job summary

Derex Technologies Inc. seeks a Data Engineer to join onsite in Jefferson City, MO. The role centers on migrating legacy SQL Server datamarts to Microsoft Fabric and building scalable data pipelines and Lakehouse solutions.

You will develop and optimize Fabric notebooks, pipelines, and data transformations, ensuring data quality and reliable production support. Strong experience with PySpark, Spark SQL, and MS Fabric is essential.

Qualifications

• 5+ years of Data Engineering experience.
• Strong MS Fabric, Python/PySpark, Spark SQL, SQL Server/T-SQL.
• Experience building data pipelines, Lakehouses, dimensional models, and ETL/ELT solutions.
• Knowledge of Spark performance tuning, incremental loads, data quality, and CI/CD.
• Experience with Git and production deployment processes.

Responsibilities

• Migrate legacy SQL Server datamarts to Microsoft Fabric.
• Develop and optimize Fabric notebooks, pipelines, and Lakehouse solutions.
• Build scalable data transformation and ingestion processes.
• Ensure data quality, testing, reconciliation, and production support.
• Collaborate with business and technical teams to deliver analytics-ready data solutions.

Skills

Microsoft Fabric

Python

PySpark

Spark SQL

SQL Server

T-SQL

Data pipelines

Lakehouses

ETL/ELT

Git

CI/CD

Tools

Databricks

Azure Synapse

Job description

Derex Technologies Inc. seeks a Data Engineer to join onsite in Jefferson City, MO. The role centers on migrating legacy SQL Server datamarts to Microsoft Fabric and building scalable data pipelines and Lakehouse solutions.

You will develop and optimize Fabric notebooks, pipelines, and data transformations, ensuring data quality and reliable production support. Strong experience with PySpark, Spark SQL, and MS Fabric is essential.