Data Engineer
Quick facts
- Pay
- $79/hour
- Type
- Full-time
- Location
- Wilmington, DE
- Skills
- Python, SQL, AWS
- Industry
- Information Technology — 1370 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:
J55442
Job Title:
Data Engineer
Location:
Wilmington, DE
Duration:
14 Months + Extension
Domain Exposure:
Aerospace/ Airlines
Client:
To Be Discussed Later
Employment Type:
W-2, 1099, C2C
Work Authorization:
US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other
Job Title: Data Engineer
Location: Wilmington, DE
Duration: 14 Months + Extension
Bill Rate: $79/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other
Job Description:
A hands-on Senior Data Engineer to build and run end-to-end data pipelines on AWS DMS and Databricks using PySpark, Python, and SQL. The position owns pipelines from source-database replication through transformation to curated, analytics-ready data, working directly with the customer. Immediate delivery on AWS is required with no ramp-up time from Azure or another cloud.
Key Responsibilities:
- Design, build, and maintain end-to-end data pipelines, from source ingestion through transformation to curated output tables.
- Configure and run AWS DMS replication tasks for full loads and ongoing Change Data Capture (CDC) from relational sources such as Oracle, SQL Server, and MariaDB.
- Land DMS output in Amazon S3 and process it in Databricks with PySpark, using Delta Lake and a bronze/silver/gold (medallion) design.
- Write complex, efficient SQL for transformations, data validation, reconciliation, and troubleshooting.
- Handle CDC logic: upserts and merges, deletes, late-arriving data, schema changes, and deduplication.
- Tune Spark jobs and DMS tasks for performance, cost, and reliability; diagnose replication lag and job failures.
- Build in data quality checks, logging, alerting, and restart/recovery so pipelines run without hand-holding.
- Orchestrate workloads with Databricks Workflows (or similar) and keep code in source control with peer review.
- Meet regularly with customer stakeholders: gather requirements, explain design choices and trade-offs, give status updates, and walk through issues and fixes.
- Write clear technical documentation for pipelines, data flows, and runbooks.
Required Qualifications (Must Have):
- All experience below must be hands-on and on AWS (experience only on Azure without AWS does not meet the bar):
- AWS DMS: Personally set up, run, and troubleshot DMS replication (full load + CDC) in a production setting, including endpoints, replication instances, task settings, and table mappings.
- Databricks: Strong hands-on development on Databricks on AWS: notebooks and jobs, Delta Lake, MERGE/upsert patterns, cluster configuration, and performance tuning.
- PySpark and Python: Writes production-grade PySpark transformations and Python code (modular, tested, version-controlled).
- End-to-end pipelines: Has built complex pipelines from source to curated data, not only the reporting or visualization layer.
- SQL: Strong SQL, including joins across large tables, window functions, CTEs, query tuning, and data reconciliation.
- Communication: Can explain work clearly to technical and non-technical audiences, and comfortable leading customer conversations.
- Experience: Typically 6+ years in data engineering, with at least 3 years currently on AWS data services and Databricks.
Nice to Have:
- AWS Glue: Jobs, crawlers, Data Catalog
- Power BI: Enough to understand how downstream reports consume the data
- Other AWS services: S3, IAM, Lambda, Step Functions, CloudWatch, Redshift
- Databricks features: Unity Catalog, Delta Live Tables, or Auto Loader
- CI/CD for data code: Git, Databricks Asset Bundles, Terraform
- Certifications: Databricks or AWS certifications (e.g., Databricks Data Engineer Professional, AWS Data Engineer Associate)
- Sector Experience: Experience on federal or public-sector projects
Who This Role Is Not For:
- DevOps or platform engineers whose DMS/Databricks work is mostly infrastructure, provisioning, or CI/CD, not building pipelines.
- Reporting or BI developers whose main work is dashboards, Power BI, or report-layer SQL.
- Azure-first engineers who would need to learn AWS on the job.
- Glue-only engineers whose AWS pipeline experience is mainly AWS Glue, without strong DMS and Databricks.
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
Level III (experienced)Database Architects · Philadelphia-Camden-Wilmington, PA-NJ-DE-MD. Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $108,576 | ~15% |
| Level II | $132,766 | ~31% |
| Level III | $156,957 | ~46% |
| Level IV | $181,147 | ~61% |
This job pays $164,320 a year (converted from an hourly rate, 2,080 hours) — that's Level III (experienced). In the wage-weighted H-1B lottery a Level III registration gets 3 entries; estimated selection chance about 46% — better than average.
* 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.