Job role overview

  • Date posted

    May 4, 2026

  • Hiring location

    Riverwoods

Description

Description
TEKsystems is looking for a Data Engineer to lead the design, build, and optimization of our modern data platform on Microsoft Fabric—with a focus on Fabric Data Warehouse, OneLake, and Lakehouse patterns. The fabric piece just needs to be someone with knowledge and possibly hands‑on experience.

Skills
Azure, Sql, Data, pyspark, tsql, Data warehouse, fabric

Top Skills Details
Azure,Sql,Data,pyspark,tsql,Data warehouse

What You’ll Do (Key Responsibilities)

Architect & Build on Fabric

Design and implement Fabric Data Warehouse schemas (star/snowflake, dimensional modeling) and Lakehouse patterns using Delta/Parquet.

Orchestrate end‑to‑end pipelines with Data Factory (Fabric Pipelines) and Dataflows Gen2‑batch and (where relevant) near‑real‑time.

Develop robust SQL (T‑SQL/DAX‑aware patterns) and Spark notebooks (PySpark) for complex transformations.

Design semantic models that support BI and ML use cases; optimize for cost and performance (partitioning, indexing, caching, concurrency).

Implement CDC/merge/upsert strategies for evolving datasets.

Implement data validation & testing (unit, schema, anomaly checks), monitor SLAs, and set up alerting & lineage.

Drive data reliability SLOs (freshness, completeness, accuracy).

Enforce RBAC, row‑level/column‑level security, masking, and data retention.

Potentially integrate with Microsoft Purview for catalog, lineage, and policies.

Use Git integration in Fabric for version control and CI/CD (multi‑environment deploys, templates, release automation).

Establish IaC patterns where applicable (e.g., ARM/Bicep/Terraform for related Azure resources).

Partner with Analytics Engineers, Data Scientists, and Power BI Developers to translate requirements into technical designs.

Mentor engineers and champion best practices (coding standards, reviews, documentation).

Additional Skills & Qualifications

Experience with Delta Lake patterns, medallion architecture, and near‑real‑time ingestion.

Familiarity with Power BI semantic models and performance implications.

Azure ecosystem exposure (Key Vault, Event Hub/Kafka, Azure Functions, Synapse migration experience).

Certifications: Microsoft DP‑600 (Fabric Analytics Engineer Associate), DP‑203 (Azure Data Engineer Associate).

Regulated data (HIPAA, SOC 2, GDPR) and data contracts with product teams.

Job Type & Location
This is a Contract position based out of Deerfield, IL.

Pay and Benefits
The pay range for this position is $80.00 – $90.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

Medical, dental & vision

Critical Illness, Accident, and Hospital

401(k) Retirement Plan – Pre‑tax and Roth post‑tax contributions available

Life Insurance (Voluntary Life & AD&D for the employee and dependents)

Short and long‑term disability

Health Spending Account (HSA)

Transportation benefits

Employee Assistance Program

Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type
This is a fully remote position.

Application Deadline
This position is anticipated to close on Apr 2, 2026.

EEO Statement
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

#J-18808-Ljbffr

work mode

On-site

Interested in this job?

20 days left to apply

Apply now

Call employer
Apply now
Send message
Cancel