Senior Snowflake Data Warehouse Engineer / Data Engineer
Quick facts
- Pay
- $78/hour
- Type
- Full-time
- Location
- Madison, WI
- Experience
- 7+ years
- Skills
- SQL
- Industry
- Financial Services — 112 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:
J54864
Job Title:
Senior Snowflake Data Warehouse Engineer / Data Engineer
Location:
Madison, WI
Duration:
8 Months + Extension
Domain Exposure:
Manufacturing
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: Senior Snowflake Data Warehouse Engineer / Data Engineer
Location: Madison, WI
Duration: 8 Months + Extension
Bill Rate: $78/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:
- We are seeking an experienced Senior Snowflake Data Warehouse Engineer with strong expertise in Snowflake, Power BI, SQL, DAX, and investment management data.
- The ideal candidate will have 7+ years of experience in Business Intelligence, Data Engineering, or Analytics, with hands-on experience supporting large-scale financial, portfolio, or asset management datasets.
- The candidate must have strong Power BI development and semantic modeling skills, advanced SQL expertise, and a solid understanding of investment data, including portfolios, positions, transactions, securities, benchmarks, risk, and performance.
- Excellent communication skills are essential, as the candidate will work closely with investment professionals, portfolio managers, analysts, risk teams, and business stakeholders.
Key Responsibilities:
- Design, develop, and maintain enterprise-level Power BI reports, dashboards, and semantic models.
- Develop and optimize complex SQL queries and Snowflake data warehouse solutions.
- Work with high-volume financial and investment datasets, ensuring data accuracy and performance.
- Build advanced DAX calculations, measures, hierarchies, and reusable business logic.
- Develop dimensional data models, including fact tables, dimensions, and slowly changing dimensions.
- Partner with investment, risk, performance, and operations teams to understand business requirements.
- Optimize Power BI reports, dashboards, data models, and refresh performance.
- Troubleshoot data, reporting, refresh, and performance-related issues.
- Implement data quality checks, reconciliation, testing, and monitoring processes.
- Support source control, automated deployments, and CI/CD processes.
- Document technical solutions, data models, and business logic.
Required Skills & Qualifications:
- 7+ years of experience in Data Engineering, Business Intelligence, or Analytics.
- 5+ years of hands-on Power BI development experience.
- Strong expertise in Snowflake Data Warehouse and Snowflake SQL.
- Expert-level SQL skills and query optimization experience.
- Advanced Power BI, DAX, and semantic modeling experience.
- Experience with Power BI Service, security, refresh strategies, and performance tuning.
- Strong understanding of dimensional modeling and data warehousing concepts.
- Must have experience supporting high-volume financial, portfolio, or investment datasets.
- Direct experience in Asset Management, Investment Management, Institutional Investment, or Financial Services.
- Understanding of portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
- Experience working with portfolio managers, investment analysts, risk professionals, or investment operations teams.
- Excellent verbal and written communication skills.
Preferred Qualifications:
- Microsoft PL-300 Power BI Data Analyst Certification.
- CFA, CAIA, or other investment-related certifications.
- Experience with automated testing, data reconciliation, and data quality frameworks.
- Experience with Git, source control, and CI/CD pipelines.
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 IV (fully competent)Database Architects · Madison, WI. Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $110,032 | ~15% |
| Level II | $126,277 | ~31% |
| Level III | $142,542 | ~46% |
| Level IV | $158,787 | ~61% |
This job pays $162,240 a year (converted from an hourly rate, 2,080 hours) — that's Level IV (fully competent). In the wage-weighted H-1B lottery a Level IV registration gets 4 entries; estimated selection chance about 61% — 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.