Skip to content
aitrainer.work - AI Training Jobs Platform
Software Engineering Turing

Data Engineer (Data Warehouse Focus)

Turing • Remote

Education

Not stated

Type

Hourly

Pay

$25-55/hr est.

Turing does not post a rate for this role. This is our estimate for similar roles. How we estimate

Last checked

10d ago

Checked

Only apply if this role fits your skills and interests.

Send this job to a friend

New roles in Telegram: @aitrainerwork

About this role

From the Turing listing

Job Title: Data Engineer (Data Warehouse Focus)

Domain: BFSIExperience: 5-8 YearsLocation:Gurugram, Haryana - 3 days WFOEmployment Type: Full-Time

Job Summary

Seeking a Data Engineer with strong expertise in Snowflake, Python, Airflow, and SQL to design, build, and maintain scalable cloud-based data warehouse solutions for BFSI platforms.

Key Responsibilities

  • Design and develop data warehouse architectures and ETL/ELT pipelines.
  • Build and orchestrate workflows using Python, SQL, Airflow, PySpark, Kafka, Databricks.
  • Perform data modeling, validation, and governance in regulated BFSI environments.
  • Migrate data from legacy systems to AWS/Azure cloud platforms.
  • Create analytics and reports using Power BI, Tableau, Alteryx.
  • Collaborate with data science teams to productionize ML features.
  • Ensure performance, reliability, and operational excellence.

Required Skills

  • Core: Snowflake, Python, SQL, Airflow
  • Data & Cloud: Oracle/PostgreSQL/MySQL/SQL Server, AWS (S3, EMR), Azure (ADLS, ADF, Databricks)
  • Big Data: Kafka, Databricks
  • BI & Tools: Power BI, Tableau, Alteryx, dbt, Git
  • Methodology: Agile (Scrum/Kanban)

BFSI Experience

  • Strong experience in Banking, Financial Services, or Insurance.
  • Knowledge of financial data models, compliance, security, and regulatory reporting.

Education

  • MCA / BSc / BE / BTech in Computer Science or related field.

Nice to Have

  • Exposure to Pandas, NumPy, SciPy
  • Snowflake or Cloud certifications

Requirements

  • Fluent proficiency in English (Written & Verbal)
  • Reliable high-speed internet connection

How long hiring takes

On the platforms we refer people to, half of hires came within about 25 days of applying. Time from applying to hire:

Under 2 weeks
~30%
2 weeks to 6 weeks
~40%
6 weeks to 3 months
~15%
Over 3 months
~15%

Data Warehouse Engineer interview prep

Questions Data Warehouse Engineer interviewers often ask. They aren't taken from this listing.

How do you decide between a star schema and a more normalized model when designing a data warehouse?

I lean toward a star schema when the primary use case is reporting and analytics, since the denormalized structure keeps queries simpler and faster for end users. I only introduce more normalization where storage costs or update anomalies genuinely outweigh the query performance benefit.

What's your approach to building an ETL pipeline that needs to handle both historical backfills and ongoing incremental loads?

I design the pipeline so incremental loads and backfills share the same transformation logic, just with different source windows, rather than maintaining two separate code paths that can drift out of sync. I also make sure the incremental logic is idempotent so a rerun doesn't duplicate data.

How do you approach optimizing a query that's become slow as the underlying table has grown?

I start by checking the query plan to see where time is actually being spent, rather than guessing at the fix, and I look at whether partitioning or indexing aligned with the common filter columns would help before considering a full redesign of the table.

What's your process for validating that a new ETL pipeline is producing correct data before it goes live?

I reconcile totals and row counts against the source system for a representative sample period, and I check edge cases like nulls and duplicate keys specifically, rather than only spot checking a few rows that look fine. I keep the validation checks running as part of the pipeline going forward, not just as a one time gate.

See all 10 Data Warehouse Engineer interview questions →

This listing mentions these tools. Brush up before a technical screen:

Typical contract length

Across 28 Turing Software Engineering listings we've tracked, contracts typically run about 8.4 weeks. Length varies by project.

Why this role

This Data Engineer (Data Warehouse Focus) position asks for solid Software Engineering knowledge. The AI training workflow itself gets taught on the job.

Skills and categories

More jobs in these fields:

Related jobs

Verified reviews

Loading reviews…

Community reviews

Loading reviews…
💬

Share your experience with Turing

Sign in to leave a review

Common questions

How and when does Turing pay contractors?

Monthly, in USD, via Deel, Payoneer, or direct bank transfer. You're engaged as an independent contractor responsible for your own local taxes. Plan your cash flow around a monthly cycle if you're used to weekly payouts elsewhere.

Do I need to be a software engineer to work for Turing?

No, not anymore. Turing built its name matching senior engineers with Silicon Valley companies, but it has since expanded into AGI infrastructure work and now hires non-engineering domain experts, technical writers, and researchers for post-training data annotation and RLHF. A strong analytical background and excellent English matter more than coding ability.

What does task-based AI training work look like?

Short, hands-on tasks such as recording videos, sorting images, rating AI answers or checking data. Most take 5 to 60 minutes each.

Can I choose my own hours?

Usually, yes. You log in when you want, pick up a task, finish it and submit it, with no meetings. Other people work from the same pool of tasks, so some days there may be no work until more is added.

What does Software Engineering work look like for a Data Engineer (Data Warehouse Focus)?

You check AI answers to Software Engineering questions, correct their errors and write expert reasoning. As a Data Engineer (Data Warehouse Focus), you're hired for that judgment, so hands-on Software Engineering experience matters.

What specific skills does this listing call for?

Coding, SQL, and Python are named directly in the listing. If you don't have hands-on experience with these, expect the screening to test for them.

How much does this specific role pay?

The listing doesn't state a rate. The $25-55/hr shown here is our estimate from the role type and location (see /pay-methodology), so treat it as a rough guide and confirm the actual rate with the platform before committing time.

What happens when I click Apply on this listing?

Apply opens Turing's site, where you create an account and follow its sign-up steps.