Associate Data Engineer

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: Associate 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 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:
Associate Data Engineer 1-2 years of industry experience in data engineering, data analysis, analytics engineering, or related data roles.
Strong knowledge of SQL and Python for data transformation, validation, and analysis.
Working experience in data platforms such as Azure, Databricks, Snowflake, or Microsoft Fabric with focus on data ingestion, data cleaning, data validation, and data quality.
Industry experience in lakehouse architecture, including Bronze, Silver, and Gold data layers.
Strong understanding of data warehousing concepts, dimensional modeling, star schema, fact tables, and dimension tables.
Ability to learn and apply reusable engineering patterns under guidance.
Ability to work with business and technical teams to understand data requirements and deliver reliable data outputs.
Technical Skills: Python, SQL, PySpark, Pandas, Azure Databricks, Azure Data Factory, Snowflake, Star Schema, Dimensional Modeling and Microsoft Fabric.

About Company:

TekWissen is a Leading Professional Services Consulting Company. As a leading staffing agency with a robust presence both locally and internationally, TekWissen specializes in connecting talented professionals with exciting job opportunities across diverse industries.