Jr. Data Engineer

Saransh Inc
New York, NY, United States
about 2 months ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
4 years minimum
Compensation
$65,000.0 - $90,000.0
Working hours
Regular working hours
Job source

Tech stack

Query Performance Application Programming Interfaces (APIs) Cloud Database Information Engineering Data Warehousing JSON Python (Programming Language) Standard Sql SQL Databases Extensible Markup Language (XML) Data Lakes Restful APIs
+5 more
Pagination Data Pipelines Api Management Databricks Web Api

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)., 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.

Requirements

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.

Benefits & conditions

  • $65,000-90,000 per year

About the company

Jones Lang LaSalle

  • Jersey City, NJ
  • $115,315-122,720 per year JLL empowers you to shape a brighter way. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology fo…, Jones Lang LaSalle

  • Flushing, Queens, NY
  • $97,864 per year JLL empowers you to shape a brighter way. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology fo…

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou Ā· Coffee With Developers

3:47 min

Exploring JSON, CBOR, and JOSE for data serialization

Aaron Russell Ā· LIVE

9:56 min

Expanding browser capabilities with modern web APIs

Ire Aderinokun Ā· JS Congress

2:27 min

Managing traffic and tracking costs with Databricks Unity Catalog

Viktoria Semaan Viktoria Semaan Ā· WWC Europe 2026

56 sec

Introduction to analytical data formats for software developers

Matthias Niehoff Matthias Niehoff Ā· WWC Europe 2026

2:03 min

Distinguishing type definition constructs from data validation routines

Clemens Vasters Clemens Vasters Ā· WWC 2025

Videos

See all

Related articles

See all