Snowflake Data engineer(Datastage, DBT,AWS)
Quick facts
- Pay
- 65 - 68 USD /HOUR
- Type
- Full-time
- Location
- Detroit, MI
- Skills
- SQL, AWS
- Industry
- Information Technology — 671 open jobs
- Visa in listing
- H-1B
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
Job description
Job Title: Snowflake Data engineer (Datastage, DBT, AWS)
Location: Detroit, MI (Onsite)
Visa: H1B Only
Experience: 10+years
Role Overview
We are seeking an experienced Data Engineer / Technical Lead with strong hands-on expertise in Snowflake, DataStage, and dbt (mandatory). The ideal candidate will have a strong background in data warehousing, data modeling, ETL/ELT, AWS data services, and customer-facing technical leadership.
Key Responsibilities
- Lead end-to-end data engineering and data warehousing projects using Snowflake, DataStage, and dbt.
- Design scalable data models, ETL/ELT pipelines, and Snowflake data architecture.
- Develop and optimize dbt models and transformations.
- Work with AWS services including Aurora, RDS, DMS, and DynamoDB.
- Develop and optimize SQL, PL/SQL, Oracle, and PostgreSQL queries.
- Implement CDC and real-time data integration solutions.
- Drive data quality, governance, security, and performance best practices.
- Gather requirements, handle CRs, and provide technical solution designs.
- Act as the bridge between business stakeholders and technical teams.
- Mentor junior engineers and provide technical guidance.
Mandatory Requirements
- 8–13 years of Data Engineering / Data Warehousing / Data Modeling experience.
- Expert-level Snowflake, DataStage, and dbt – Mandatory.
- Strong AWS data services experience: Aurora, RDS, DMS, DynamoDB.
- Strong Oracle, PL/SQL, SQL, and database performance optimization.
- Strong ETL/ELT, Data Integration, Data Architecture, and Dimensional Modeling experience.
- Experience with customer handling, requirement gathering, and solution design.
- Strong communication and technical leadership skills.
Visa sponsorship record: Tech Genius Inc
Sponsors actively| Fiscal year | H-1B LCAs | USCIS approvals | USCIS denials | PERM |
|---|---|---|---|---|
| FY2026 | 4 | 4 | 0 | — |
| FY2025 | 5 | 2 | 0 | — |
| FY2024 | 4 | 6 | 0 | — |
This exact kind of role (Database Architects) isn't among the roles Tech Genius Inc sponsored most often.
Roles they sponsor most
- software engineer3 LCAs · median $82k
- performance tester2 LCAs · median $95k
- software developer2 LCAs · median $88k
- data scientist1 LCA · median $80k
- data scientist master data domain1 LCA · median $80k
Which visas can work for this job
Occupation: Database Architects (SOC 15-1243) — estimated from the job title.
- Mentioned in the listing
H-1B
- 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)
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 · Detroit-Warren-Dearborn, MI. Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $89,814 | ~15% |
| Level II | $109,595 | ~31% |
| Level III | $129,397 | ~46% |
| Level IV | $149,178 | ~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.