Data Engineer

Note: Only US Citizens and Green Card Holders are considered for this position (W2 Requirement, Full -Time)

Position title: Data engineer

Location: 800 Connecticut Avenue, Norwalk, CT

Onsite: 3 days a week

Perm: 130k-160k

Relo candidates: Yes that's fine

Status: anyone that does not require current or future sponsorship (meaning if someone requires sponsorship in 3-5 years, we cant use)

Interview process: apex screening, then two video interviews to hire

Must have: 5 years experience or more, databricks, building databricks and using Azure datawarehouse or azure synapse

Current State:

o Migrated three businesses into one

Consolidating subledgers and CRM systems

o Just migrated to Azure cloud à would be using azure synapse for analytics

o Currently using TCS but it's not going well, poor support model and struggling with time zone difference

Has a team of 7 resources, SQL Server/SSIS backgrounds and really struggling to keep pace or learn new technologies

o Current reporting is a lot of manual excel spreadsheets

Future State End Goal:

o Enterprise Datawarehouse with self-service reporting

Hasn't started this process at all, would need to road map how to consolidate the current 3 DWs to one first

Add in Azure Snapse to automate the reporting

Needs to implement MDM, Data Quality & Data Governance, doesn't exist right now