What are the responsibilities and job description for the Data Engineer Power BI position at TEKsystems?
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.
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).
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.
Requirements
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:
This is a fully remote position.
Application Deadline
This position is anticipated to close on Apr 3, 2026.
h4>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
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.
About TEKsystems And TEKsystems Global Services
We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
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.
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).
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.
Requirements
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)
This is a fully remote position.
Application Deadline
This position is anticipated to close on Apr 3, 2026.
h4>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
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.
About TEKsystems And TEKsystems Global Services
We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Salary : $80 - $90