Data Engineer
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
Interested in this job?
20 days left to apply