Data Engineer Power BI

TEKsystems•Deerfield, IL

2d•$80 - $90•Remote

About The Position

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.

Requirements

Azure
Sql
Data
pyspark
tsql
Data warehouse
fabric

Nice To Haves

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.

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.
Data Modeling & Performance
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.
Quality, Observability & Reliability
Implement data validation & testing (unit, schema, anomaly checks), monitor SLAs, and set up alerting & lineage.
Drive data reliability SLOs (freshness, completeness, accuracy).
Security & Governance
Enforce RBAC, row-level/column-level security, masking, and data retention.
Potentially integrate with Microsoft Purview for catalog, lineage, and policies.
DevOps & Lifecycle
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).
Collaboration & Leadership
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).