Data Engineer

TekWissen LLC

Overland Park, KS

JOB DETAILS
SALARY
$51.39–$51.39
SKILLS
Application Programming Interface (API), Best Practices, Business Intelligence, Cisco Unity, Cloud Computing, Communication Skills, Computer Programming, Data Analysis, Data Cleaning, Data Management, Data Processing, Data Quality, Data Sets, Data Warehousing, Dimensional Modeling, Diversity, Ecosystems, Error Handling, Information Technology & Information Systems, Metadata, Microsoft Product Family, Microsoft Windows Azure, Performance Tuning/Optimization, Power BI, Production Control, Production Support, Python Programming/Scripting Language, Reconciliation, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Scalable System Development, Snowflake Schema, Software Engineering, Star Schema, Structured Data, Training Data Sets, Use Cases, Warehousing, Workforce Management
LOCATION
Overland Park, KS
POSTED
1 day ago
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services
Position: Data Engineer
Location: Parsippany, NJ; Frisco, TX; Overland Park, KS; Bellevue, WA
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Hybrid
Job Description
  • We are seeking a hands-on Data Engineer or Associate Data Engineer with strong programming skills in Python and SQL and practical experience building scalable data ingestion, transformation, and quality pipelines using Azure ecosystem.
  • This role will focus on building scalable ingestion pipelines into the Bronze layer, developing Silver and Gold layer patterns, with strong focus on data quality, and enabling governed semantic models through Microsoft Fabric for analytics and reporting.
Key Responsibilities
  • Implement medallion lakehouse architecture patterns across Bronze, Silver, and Gold layers.
  • Build and maintain ingestion pipelines that bring structured, semi-structured data, files, API sources into the Bronze layer of the lakehouse.
  • Develop Silver layer patterns focused on data cleaning, standardization, deduplication, validation, and business-rule application.
  • Develop Gold layer datasets that are curated, analytics-ready, and suitable for enterprise reporting and semantic model consumption.
  • Build reliable data pipelines using Azure Databricks, SQL, and Python.
  • Design and support orchestration workflows using Azure Data Factory Implement data quality checks, reconciliation logic, exception handling, and monitoring across pipelines.
  • Support enterprise data warehouse design, including dimensional modeling, star schemas, fact tables, and dimension tables.
  • Prepare curated datasets that support semantic models, governed reporting, dashboards, and business intelligence use cases.
  • Enable semantic layers and semantic models through Microsoft Fabric, including Fabric Lakehouse, Fabric Warehouse, OneLake, and Power BI semantic model integration. Optimize data pipelines, transformations, models, and processing jobs for performance, scalability, and maintainability.
  • Collaborate with data analysts, BI developers, business stakeholders, and platform teams to translate requirements into trusted, reusable data products.
  • Communicate technical concepts clearly to both technical and non-technical stakeholders.
Required Skills and Experience
  • Data Engineer 3-5 years of industry experience in data engineering, analytics engineering and enterprise data platforms Strong hands-on experience with SQL and Python for data pipeline development, transformation, validation, and performance optimization.
  • Experience building ingestion pipelines into a lakehouse, cloud data platform, or enterprise data warehouse.
  • Experience designing and implementing Bronze, Silver, and Gold layers in a medallion lakehouse architecture.
  • Hands-on experience with Azure Databricks and distributed data processing.
  • Experience with Snowflake, including data loading, transformation, performance tuning, and integration with cloud platforms.
  • Experience implementing data cleaning, standardization, deduplication, validation, reconciliation, and data quality rules.
  • Working experience with enterprise data warehouses, dimensional modeling, star schemas, fact tables, and dimension tables.
  • Hands on experience with Microsoft Fabric a plus Experience creating curated datasets for reporting, analytics, dashboards, and semantic model consumption.
  • Understanding of data governance, metadata management, lineage, monitoring, and production support best practices.
  • Ability to own specific data domains, act as a subject matter expert, and guide implementation patterns.
Preferred Qualifications
  • Azure, Microsoft Fabric, Databricks, or Snowflake certification preferred.
  • Experience with Delta Lake, Unity Catalog, OneLake, or similar lakehouse governance technologies.
  • Experience implementing reusable ingestion, Silver transformation, and Gold curation patterns.
  • Experience supporting Power BI or Microsoft Fabric semantic model development.
  • Experience building production-grade data pipelines for enterprise analytics, reporting, or data platform modernization.
Technical Skills:
  • Python, SQL, PySpark, Pandas, Azure Databricks, Azure Data Factory, Snowflake, Star Schema, Dimensional Modeling and Microsoft Fabric.
TekWissen Group is an equal opportunity employer supporting workforce diversity.

About the Company

T

TekWissen LLC

WE THE TEKWISSEN PEOPLE

TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.

To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.

Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.

It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.

Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.



COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2009
WEBSITE
http://www.tekwissen.com/