Jr. Data Engineer Job at Saransh Inc, New York, NY

bHRVdjE3YVJ4TWRHNXdDQTN6MFgwOTZHYlE9PQ==
  • Saransh Inc
  • New York, NY

Job Description

Position Title: Jr. Data Engineer
Location: NYC, NY (5 Days Onsite)
Duration: 6 Months Contract

Job Description:
The client is strategically transitioning the Data Warehouse engineering operations onshore and is looking for a driven Data Warehouse Engineer to help lead this initiative.
Your primary focus will be migrating, building, and optimizing ELT pipelines that extract data from third-party APIs and load it into our data lake utilizing managed Delta tables.
You will initially work closely with our existing offshore team to complete a comprehensive Knowledge Transfer (KT).


Key Responsibilities:
ELT Pipeline Development: Design, build, and maintain robust ELT (Extract, Load, Transform) pipelines to migrate data from various third-party API sources into our enterprise data lake.
Databricks Ecosystem: Create, manage, and optimize managed Delta tables within a Databricks environment to ensure high data reliability and query performance.
API Integration: Securely connect to, authenticate with, and extract data from a wide variety of third-party RESTful APIs.
Data Modeling & Querying: Write clean, scalable, and efficient Python and SQL code to transform raw data into analytics-ready datasets.
Knowledge Transfer (KT): Actively participate in onboarding and KT sessions with the current offshore team to seamlessly transition ownership of existing pipelines and architecture.
Documentation: Maintain clear technical documentation for data pipelines, API integrations, and Delta table schemas to support future onshore hires.

Required Skills & Qualifications
Experience: 4+ years of experience in data engineering, data warehousing, or a similar technical role.
Core Languages: Strong, hands-on proficiency in Python and SQL.
Databricks & Data Lakes: Practical experience working with Databricks, specifically building and maintaining Delta tables and working within a modern data lake architecture.
API Expertise: Proven experience extracting and handling data from third-party APIs (handling pagination, rate limiting, JSON/XML parsing, etc.).
Methodology: Solid understanding of ELT methodologies and cloud-based data architecture.
Communication: Excellent verbal and written communication skills, with the ability to effectively absorb complex technical information during cross-border knowledge transfers.

Job Tags

Contract work

Similar Jobs

Ace Hardware

Small Engine Mechanic Job at Ace Hardware

 ...Job Title: Power Equipment Repair Technician Job Description: At Laskowski Ace, Sales Associates are the backbone of the business...  ...and women are part of the fabric of your community. They are small business owners who are local and loyal...just like it ought to... 

Gpac

Construction Superintendent Job at Gpac

A highly respected local General Contractor is seeking a Superintendent to join their growing team! They have a backlog of local and regional...  ...facing as well as have a thorough knowledge in commercial construction processes. Although their projects have grown in size and... 

Seva Hospitality

Hotel Maintenance Technician Job at Seva Hospitality

 ...Join the Seva Hospitality team as a Hotel Maintenance Technician for a career in hospitality servicing Marriott & Hilton hotels. Job Description Seva Hospitality is seeking to add a Regional Maintenance Technician to oversee various hotel locations in... 

Baptist Memorial Health Care

Patient Transporter Job at Baptist Memorial Health Care

Overview Job Summary Provides courteous, safe transport of patients and/or supplies throughout the facility. Performs other duties as assigned. Responsibilities Transports patients, equipment, and/or supplies throughout hospital to ensure items are available ...

VIR Properties

Entry-level Project Manager Job at VIR Properties

 ...As an Entry-level Project Manager , you will support the planning, coordination, and execution of marketing campaigns and client projects. You will work alongside senior leaders and cross-functional teams to ensure projects are delivered on time, meet quality standards...