Azure Data Engineer

ISITE TECHNOLOGIES; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

ISITE TECHNOLOGIES in New York (Locals only) seeks a senior data engineer with 10-12 years of experience to design and implement cloud-based data pipelines using Azure Data Factory, SQL, and Python or C#.

You will build data warehouses, develop dimensional models, and ensure data availability for BI reporting via Power BI. Local candidates only; Cloud and AI tooling like Claude/Codex familiarity is a plus.

Qualifications

• 10-12 years of data engineering/ETL experience.
• Experience with cloud-based data warehousing and data pipelines.
• Proficient in SQL and Python or C# for data transformations.

Responsibilities

• Design, develop, and maintain data pipelines and ETL processes.
• Implement surrogate keys and dimensional models (facts and dimensions).
• Collaborate with analysts to define KPIs and data requirements for BI.
• Migrate data across central warehouses and reporting databases.
• Work with Power BI or similar tools for BI reporting.

Skills

ETL frameworks

Azure Data Factory

SQL

Python

C#

Data warehousing

Data modeling

Power BI

Cloud platforms

Big data concepts

Tools

SQL IDEs

Power BI

Microsoft Fabric

Claude

Codex

Job description

Experience: 10-12 years

Location: New York (Locals only)

Visa: Any

Mode of Interview: 1st round Virtual, Client round In-person

Job Description:

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