Saransh Inc

Lead Data Engineer - Only W2

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Lead Data Engineer in San Francisco, CA, offering a 9-month W2 contract. Requires 8-10 years of software development, 7 years with SQL, Databricks, ADF, and ETL tools, plus strong BI and data modeling skills.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
April 10, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
On-site
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
San Francisco, CA
-
🧠 - Skills detailed
#ADF (Azure Data Factory) #Cloud #Azure #Data Ingestion #Tableau #"ETL (Extract #Transform #Load)" #Azure Data Factory #Deployment #Data Engineering #Scala #Data Modeling #Stories #SSAS (SQL Server Analysis Services) #DataStage #ThoughtSpot #Jira #BI (Business Intelligence) #Databricks #Documentation #Data Warehouse #NoSQL #SQL (Structured Query Language) #AWS (Amazon Web Services) #Python
Role 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, ADF, DataStage (or other ETL tool), 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)