Lead Azure Data Engineer

Smart IT Frame LLC; Mount Laurel Township (NJ); Hybrid; USD 130,000 - 170,000; Full time

Job summary

Smart IT Frame LLC is seeking an experienced Data Warehouse/ETL Engineer for onsite/hybrid work in Mount Laurel Township, New Jersey.

The role requires 12+ years of IT experience in data warehousing and ETL, hands‑on Azure data services (ADF, Synapse) and PySpark/Python, plus the ability to draft STTM specifications and mentor junior resources across client offices.

Qualifications

• 12+ years of IT experience in Datawarehouse and ETL.
• Hands-on data experience on Cloud Technologies on Azure, ADF, Synapse, PySpark/Python.
• Ability to understand Design, Source to target mapping (STTM) and create specifications documents.
• Flexibility to operate from client office locations.
• Able to mentor and guide junior resources, as needed.

Responsibilities

• Design and develop data warehousing and ETL solutions.
• Build and optimize Azure-based data pipelines (ADF, Synapse).
• Create detailed STTM specifications and design documents.
• Mentor junior resources and support client office teams.
• Collaborate with clients to ensure timely delivery and governance.

Skills

Datawarehouse

ETL

Azure

ADF

Synapse

PySpark

Python

Tools

Azure Data Factory

Azure Synapse

PySpark

Python

Job description

Mode of work: Onsite/Hybrid (3 days/per week)

Total Experience: 12+ Years

Secondary: Datawarehouse,

Job Description:

• 8- 12 Years of IT experience in Datawarehouse and ETL
• Hands-on data experience on Cloud Technologies on Azure, ADF, Synapse, Pyspark/Python
• Ability to understand Design, Source to target mapping (STTM) and create specifications documents
• Flexibility to operate from client office locations
• Able to mentor and guide junior resources, as needed