Data Engineer Data Warehouse

4 days ago

New York, NY, United States DS Technologies Full time

About US: We are a company that provides innovative, transformative IT services and solutions. We are passionate about helping our clients achieve their goals and exceed their expectations. We strive to provide the best possible experience for our clients and employees. We are committed to continuous improvement and innovation, and we are always looking for ways to improve our services and solutions. We believe in working collaboratively with our clients and employees to achieve success.

DS Technologies Inc is looking for Data Engineer – Data Warehouse role for one of our premier clients.

Job Title: Data Engineer – Data Warehouse

Location: New York, NY (Hybrid – 3 days onsite at Amex Tower) Duration: Long Term Contract Only W2

Work Arrangement:

Hybrid: 3 days onsite at the American Express Tower, New York, NY.

Job Description:

We are seeking an experienced Data Engineer with strong expertise in ETL development, data warehousing, and large-scale data processing. The ideal candidate will have a solid understanding of data modeling, SQL, and Python-based ETL pipeline development. This role involves building and maintaining data pipelines that enable analytics, governance, and reporting across various enterprise systems.

Key Responsibilities:

Design, develop, and deploy ETL pipelines using Python from scratch.

Write efficient, reusable, and modular code adhering to OOP principles.

Design and optimize data models including schemas, entity relationships, and transformations.

Develop and analyze SQL queries across multiple RDBMS systems (SQL Server, DB2, Oracle).

Work with data warehouses such as BigQuery and Databricks Delta Lakehouse for ingestion, cleansing, governance, and reporting.

Create, manage, and monitor Airflow DAGs for scheduling and workflow automation.

Collaborate with cross-functional teams to ensure data consistency, accuracy, and accessibility.

Troubleshoot data issues and optimize ETL performance.

Required Skills & Experience:

6+ years of experience in Data Engineering, ETL Development, and Data Warehousing.

Strong programming skills in Python with proven experience in ETL pipeline design.

Expertise in SQL, RDBMS (MS SQL Server, DB2, Oracle).

Hands-on experience with Airflow for orchestrating workflows.

Solid understanding of OOP concepts and data modeling principles.

Experience with BigQuery, Databricks Delta Lakehouse, or similar data warehouse technologies.

Familiarity with Spark is a strong plus.

Nice to Have:

Experience with IBM Apptio platform and cost management data workflows.

Knowledge of Node.js for integration scripting or data API handling.

Flexible work from home options available.

  • Sr. Azure Data Engineer

    2 weeks ago

    New York, NY, United States Hudson Data Full time

    Job Title: Sr. Azure Data Engineer Location: NYC, NY Duration: Long Term W2 Role Job Description: The candidate should have hands-on experience with various Azure services including but not limited to Azure Data Factory, Databricks, Data Lake, and Power BI. They should be able to design, build, and maintain ETL pipelines, manage data lakes, and...

  • Data Engineer, Data and Insights

    3 days ago

    New York, NY, United States UJA Full time

    The Data Engineering and Architecture team at UJA-Federation of New York is seeking an experienced Data Engineer. The ideal candidate will bring strong expertise in Python development for data-intensive applications, coupled with familiarity in Azure DevOps practices and some familiarity with Infrastructure as Code (IaC) approach. This role involves building...

  • Data Engineer, Data and Insights

    1 day ago

    New York, NY, United States UJA Full time

    The Data Engineering and Architecture team at UJA-Federation of New York is seeking an experienced Data Engineer. The ideal candidate will bring strong expertise in Python development for data-intensive applications, coupled with familiarity in Azure DevOps practices and some familiarity with Infrastructure as Code (IaC) approach. This role involves building...

  • Data Engineer, Data and Insights

    6 days ago

    New York, NY, United States UJA Full time

    The Data Engineering and Architecture team at UJA-Federation of New York is seeking an experienced Data Engineer. The ideal candidate will bring strong expertise in Python development for data-intensive applications, coupled with familiarity in Azure DevOps practices and some familiarity with Infrastructure as Code (IaC) approach. This role involves building...

  • Data Engineer, Data and Insights

    2 days ago

    New York, NY, United States UJA Full time

    The Data Engineering and Architecture team at UJA-Federation of New York is seeking an experienced Data Engineer. The ideal candidate will bring strong expertise in Python development for data-intensive applications, coupled with familiarity in Azure DevOps practices and some familiarity with Infrastructure as Code (IaC) approach. This role involves building...

  • Data Engineer

    4 days ago

    New York, NY, United States RIT Solutions, Inc. Full time

    Data Engineer Remote Tri state are Top Skills: Strong SQL Python Snowflake Azure Products Position Summary The Data Engineer is responsible for integrating and modeling data in modern data stack to support analysts, business intelligence users, data scientists, and decision-makers across the company. The Data Engineer must have a deep understanding...

  • Data Engineer

    4 days ago

    New York, NY, United States RIT Solutions, Inc. Full time

    Data Engineer Remote Tri state are Top Skills: Strong SQL Python Snowflake Azure Products Position Summary The Data Engineer is responsible for integrating and modeling data in modern data stack to support analysts, business intelligence users, data scientists, and decision-makers across the company. The Data Engineer must have a deep understanding...

  • Data Engineer

    2 days ago

    New York, NY, United States RIT Solutions, Inc. Full time

    Data Engineer Remote Tri state are Top Skills: Strong SQL Python Snowflake Azure Products Position Summary The Data Engineer is responsible for integrating and modeling data in modern data stack to support analysts, business intelligence users, data scientists, and decision-makers across the company. The Data Engineer must have a deep understanding...

  • Data Engineer

    2 weeks ago

    New York, NY, United States HCL Global Systems Full time

    • High-Performance Culture: Be a key player in our high-performing team, surrounded by intellectual minds eager to collaborate and learn from each other. • Key Contributions: Be a key contributor on one of top-priority initiatives, backed by strong senior management support. The platform is already making waves, and now it & your chance to steer it to...

  • Data Engineer

    4 days ago

    New York, NY, United States HCL Global Systems Full time

    • High-Performance Culture: Be a key player in our high-performing team, surrounded by intellectual minds eager to collaborate and learn from each other. • Key Contributions: Be a key contributor on one of top-priority initiatives, backed by strong senior management support. The platform is already making waves, and now it & your chance to steer it to...