Azure data Engineer

iSite Technologies Corp.; Trenton (NJ); On-site; USD 120,000 - 170,000; Full time

Job summary

iSite Technologies Corp. in Hamilton Township, NJ, is seeking an Azure Data Engineer with extensive experience to design and govern data platforms. The role focuses on building scalable data pipelines, integrating cloud ETL workflows, and ensuring data quality across the enterprise.

You will work with SQL and Python, implement dimensional models, and optimize data warehouses. Strong BI collaboration with Power BI is expected, along with familiarity with NoSQL databases and data lifecycle

Qualifications

• 12 years of experience in data engineering.
• Experience with ETL frameworks on Azure Cloud using Data Factory.
• Experience in Data Warehouse environments, building data pipelines and complex data transformations.
• Experience with relational and NoSQL databases, open data formats, and Python or C#.
• Experience with SQL IDEs and analytics tools such as Power BI.

Responsibilities

• Design and implement data pipelines and transformations for data warehouses.
• Maintain data warehouses and BI reporting systems.
• Develop dimensional models (facts and dimensions) and optimize data structures.
• Collaborate with stakeholders to identify KPIs and support operational and strategic planning.

Skills

Azure Data Factory

SQL

Python

C#

Power BI

Data Warehousing

ETL pipelines

Data modeling

NoSQL databases

Tools

Power BI

SQL IDEs

Databricks

Azure

Job description

Job : Azure data Engineer

Experience : 12 years

Location : Hamilton Township, NJ ( Locals only )

Visa : No GC

Skills

Experience with ETL frameworks and tools on Cloud platforms using Azure Data Factory with SQL or Python.

Experience in understanding data life cycle and data software development, data engineering with SQL in a Data Warehouse environment, building data pipelines and complex data transformations as well using Relational & NoSQL databases, open data formats, and programming languages such as Python or C#, etc.

Exp with SQL IDE’s, and analytics tools such as Power BI or similar tool.

Implemented Surrogate key by using Key Management functionality for newly inserted rows in Data warehouse which made data availability more convenient.

Very good understanding and implementation experience with dimensions and fact table designs.

Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.

Installed, developed, and maintained a variety of applications to support business intelligence products, data warehouses and reporting systems.

Designed and implemented daily data migration between central data warehouse server and application/reporting database server and analyst database server.

Experience In Microsoft Fabric Platform Or Certification Preferred.

• Should have experience with Claude or Codex