Data Engineer
Quick facts
- Type
- Full-time
- Location
- San Jose, CA
- Background
- Bachelor's degree
- Skills
- Python, SQL, AWS
- Industry
- Information Technology — 1403 open jobs
- Visa in listing
- H-1B, OPT
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
Job description
Job ID: J53282
Job Title: Data Engineer
Location: San Jose, CA
Duration: 6 Months + Extension
Domain Exposure: Pharmaceuticals
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD
Client: To Be Discussed Later
Employment Type: W-2, 1099, C2C
Role: Data Engineer
Technology Stack: Python, SQL, PySpark, Apache Spark, Azure Data Factory, Databricks, Azure Data Lake, AWS, Snowflake, ETL/ELT, SQL Server, Power BI, Git.
Roles and Responsibilities
- Designed, developed, and maintained scalable data pipelines to extract, transform, and load data from multiple sources.
- Developed ETL/ELT workflows using Python, SQL, PySpark, and Azure Data Factory.
- Built and optimized data processing solutions using Apache Spark and Databricks.
- Worked with structured and unstructured data from relational databases, APIs, flat files, and cloud storage.
- Designed and implemented data integration solutions to support business intelligence and analytics requirements.
- Developed complex SQL queries, stored procedures, views, and functions to transform and process large datasets.
- Implemented data validation, data cleansing, data transformation, and data quality checks to ensure data accuracy.
- Worked with Azure Data Lake Storage and cloud-based data platforms to store and manage large volumes of data.
- Created and maintained data warehouses, data marts, and dimensional data models.
- Integrated data from multiple enterprise systems using REST APIs and database connectors.
- Monitored data pipelines, identified failures, and resolved performance and data processing issues.
- Implemented incremental data loading, partitioning, and optimization techniques to improve pipeline performance.
- Worked with Snowflake for data loading, transformation, query optimization, and warehouse management.
- Implemented data security, access controls, and governance practices to protect sensitive business information.
- Used Git and Azure DevOps for source control, CI/CD, and deployment management.
- Collaborated with data analysts, data scientists, and business teams to understand data requirements.
- Participated in Agile/Scrum ceremonies, technical discussions, code reviews, and production support.
Technical Skills
- Programming: Python, SQL, PySpark
- Big Data: Apache Spark, Hadoop, Databricks
- ETL Tools: Azure Data Factory, Informatica, SSIS
- Cloud Platforms: Microsoft Azure, AWS
- Data Storage: Azure Data Lake, Amazon S3
- Data Warehousing: Snowflake, Azure Synapse Analytics, SQL Server
- Databases: PostgreSQL, MySQL, Oracle, SQL Server
- Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling
- DevOps: Git, Azure DevOps, CI/CD, Jenkins
- Reporting: Power BI
- Methodologies: Agile, Scrum, SDLC
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Experience in data engineering, ETL development, and data pipeline implementation.
- Strong programming knowledge in Python, SQL, and PySpark.
- Experience working with cloud platforms and data warehousing technologies.
- Understanding of data modeling, database concepts, and data integration.
- Strong analytical, problem-solving, debugging, and communication skills.
Equal Opportunity Employer
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/immigration status, veteran status, or any other status protected under federal, state, or local law.
Visa sponsorship record: Robotics Technologies LLC
Sponsors actively| Fiscal year | H-1B LCAs | USCIS approvals | USCIS denials | PERM |
|---|---|---|---|---|
| FY2026 | 86 | 30 | 5 | — |
| FY2025 | 82 | 8 | 0 | — |
| FY2024 | 36 | 11 | 0 | — |
✔ Robotics Technologies LLC filed 7 H-1B applications for this kind of role (Database Architects) in the period above.
Also filed: H-1B1 Singapore × 1 — a good sign for Australian (E-3), Chilean and Singaporean (H-1B1) candidates.
Roles they sponsor most
- data analyst22 LCAs · median $90k
- software developer13 LCAs · median $84k
- software engineer10 LCAs · median $84k
- business analyst8 LCAs · median $80k
- data engineer7 LCAs · median $98k
Which visas can work for this job
Occupation: Database Architects (SOC 15-1243).
- Mentioned in the listing
H-1B, OPT
- H-1B cap-exempt employer
Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).
- TN (citizens of Canada and Mexico)
This kind of role may fit the USMCA profession “Computer Systems Analyst” — it depends on the actual duties. No lottery, no cap; you need the matching degree or license.
- E-3 (Australia) and H-1B1 (Chile, Singapore)
This employer has filed before (H-1B1 Singapore: 1). Same degree requirement as H-1B, but no lottery and a separate quota that is rarely filled.
- O-1 (extraordinary ability)
For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.
- STEM OPT extension (F-1 students)
Requires an E-Verify employer. We didn't find this company in the E-Verify list — ask HR.
Salary vs prevailing wage
Database Architects · San Jose-Sunnyvale-Santa Clara, CA. Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $132,642 | ~15% |
| Level II | $161,762 | ~31% |
| Level III | $190,882 | ~46% |
| Level IV | $220,002 | ~61% |
The listing has no salary, so we can't place it on a wage level. Ask the employer which wage level they'd file at: Level III–IV registrations get 3–4 entries in the H-1B lottery.
* Odds are DHS projections for the FY2027 wage-weighted lottery (actual results vary by year and employer). Since the FY2027 cap season the H-1B lottery is weighted by wage level: Level I = 1 entry, II = 2, III = 3, IV = 4. The level is set by the offered wage against the prevailing wage for the occupation and worksite. Separately, a $100,000 fee for new H-1B petitions for workers outside the US was announced in 2025; as of September 2026 a federal court ruling keeps it unenforceable while appeals continue — check the current status.
Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.