Data Engineer Data Warehouse

21 hours 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

    1 week 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

    21 hours 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

    1 week 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

    2 weeks ago

    New York, NY, United States Beam Impact Full time

    Are you looking to join a highly motivated team working for social impact? At Beam we're on a mission to shift $10 Billion to high-impact nonprofits. About the role As a Data Engineer on our Engineering team with a focus on data development, you will be working with a team of talented developers responsible for helping create and maintain the data...

  • Data Engineer

    5 days ago

    New York, NY, United States Beam Impact Full time

    Are you looking to join a highly motivated team working for social impact? At Beam we're on a mission to shift $10 Billion to high-impact nonprofits. About the role As a Data Engineer on our Engineering team with a focus on data development, you will be working with a team of talented developers responsible for helping create and maintain the data...

  • Data Engineer

    3 days ago

    New York, NY, United States Beauty by Imagination (BBI) Full time

    About Beauty by Imagination:Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. We are a platform company of diverse, market-leading brands, including Wet Brush, Goody, Bio Ionic, and Ouidad - all of which are driven to be the most trusted choice for happy, healthy hair....

  • Data Engineer

    2 days ago

    New York, NY, United States Beauty by Imagination (BBI) Full time

    About Beauty by Imagination:Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. We are a platform company of diverse, market-leading brands, including Wet Brush, Goody, Bio Ionic, and Ouidad - all of which are driven to be the most trusted choice for happy, healthy hair....

  • Data Engineer

    5 days ago

    New York, NY, United States Beauty by Imagination (BBI) Full time

    About Beauty by Imagination:Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. We are a platform company of diverse, market-leading brands, including Wet Brush, Goody, Bio Ionic, and Ouidad - all of which are driven to be the most trusted choice for happy, healthy hair....

  • Data Engineer

    5 days ago

    New York, NY, United States Beauty by Imagination (BBI) Full time

    About Beauty by Imagination:Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. We are a platform company of diverse, market-leading brands, including Wet Brush, Goody, Bio Ionic, and Ouidad - all of which are driven to be the most trusted choice for happy, healthy hair....

  • Data Engineer

    1 week ago

    New York, NY, United States Amadeus Search Full time

    Role: Data Engineer Type: Full-time Location: On-site, New York, NY Compensation: $160k - $250k base + equity (0.6%-0.9%) Visa: Sponsorship available (H1B transfers welcome; other guaranteed sponsorship paths)About the Role This is a high-impact opportunity for a Data Engineer to build and scale complex data infrastructure that powers mission-critical...