Lead Data Engineer - Only W2

Saransh Inc; San Francisco (CA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Saransh Inc is hiring a Lead Data Engineer in San Francisco, CA. The role involves building data ingestion pipelines and designing data warehouse architecture. Candidates should have a minimum of 8-10 years in software development with strong experience in SQL, Databricks, and BI tools.

This is a W2 Contract position lasting 9 months, requiring on-site presence 1-2 days a week. Advanced SQL and Python skills are required, with a strong database knowledge preferable. Ideal candidates should possess experience converting business functionalities into technical stories.

Qualifications

• 8-10 years of software development and deployment experience.
• At least 7 years of hands-on experience with SQL and BI tools.
• Strong database knowledge and advanced SQL and Python skills.

Responsibilities

• Build data ingestion pipelines and design data warehouse architecture.
• Write documentation and manage Confluence pages.
• Convert business functionalities into technical Jira stories.

Skills

SQL

Databricks

Azure Data Factory (ADF)

DataStage

SSAS cubes

Cognos

Tableau

ThoughtSpot

Job description

Role: Lead Data Engineer
Location: San Francisco, CA (1-2 days a week onsite is must)
Job Type: W2 Contract
Contract Length: 9 months with possible extension
Experience Level: Senior/Lead

Main Skills

• SQL
• Databricks
• Azure Data Factory (ADF)
• DataStage (or other ETL tools)
• SSAS cubes
• Cognos/other
• Tableau/other
• ThoughtSpot/other

Required Experience

• 8-10 years of software development and deployment experience
• At least 7 years of hands‑on experience with:
• SQL
• Databricks
• Azure Data Factory (ADF)
• DataStage (or other ETL tools)
• SSAS cubes
• BI tools (Cognos, Tableau, ThoughtSpot, etc.)
• Strong database knowledge (SQL & No‑SQL preferred)
• Advanced SQL and Python skills
• Experience working with APIs for data collection/ingestion

Additional Skills & Requirements

• Experience building data ingestion pipelines and data warehouse architecture
• Ability to write design documentation, source‑to‑target mapping documentation, and manage Confluence pages
• Experience converting business functionalities into technical Jira stories
• Strong experience with data modeling, design patterns, and building scalable BI solutions
• Knowledge of cloud platforms (Azure, AWS or equivalent)