Data Engineer

Ohm Systems

New York (NY)

On-site

USD 120,000 - 170,000

Full time

7 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Microsoft in New York seeks a data engineering professional to design and optimize data pipelines using SQL Server, ETL concepts, and T-SQL. The role involves working with Azure Synapse, Azure Data Factory, PySpark/Scala, and DAX within tabular cubes and Power BI reporting environments.

Familiarity with Azure Stack and Azure Synapse scripting for ETL is highly valued. The ideal candidate will have hands-on SQL Server experience, data pivots in Excel for analysis, and exposure to Microsoft

Job description

Client: Microsoft

Job Description

Technical skills

Microsoft SQL Server
- Database and ETL design concepts
- T SQL
- SQL server Analysis server
- Fluent in DAX queries (good to have)
Little bit of understanding on the Tabular cubes and PBI reporting experience
Actual working experience on "Azure Stack" (Azure Synapse, ADF) and also language side pyspark, scala
Azure Synapse including creating scripts for ETL using Python(pyspark)
Experience with excel includes creating data pivots to different sources for analyzing
Good to have prior experience with Microsoft projects, process, and tools (like VSTS, VSO)