BI Consultant (BI/ Data Analytics/Power BI/ Tableau / SQL / Data Warehousing)
Quick facts
- Pay
- $40,000 - $100,000 per year
- Type
- Full-time
- Location
- San Diego, CA
- Background
- Bachelor's degree
- Experience
- 5+ years
- Skills
- Python, SQL
- Industry
- Information Technology — 666 open jobs
- Visa in listing
- H-1B, OPT
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
Job description
We're hiring! Are you passionate about turning complex data into insights that help businesses make better decisions? 2DOT2 INC is looking for a Business Intelligence Consultant to join our team and work on client analytics projects across healthcare, pharma, finance, telecom and retail.
Who can apply
- US Citizens, Green Card holders, H-1B, OPT and STEM OPT candidates are welcome.
- Open to candidates anywhere in the US.
- Entry-level through experienced candidates are encouraged to apply.
What you'll do
- Gather business and data requirements from client stakeholders.
- Build dashboards, scorecards, visualizations and reports in Power BI, Tableau and SSRS.
- Analyze large, complex data sets to find trends, operational impact and opportunities.
- Write and tune SQL queries; use Python for data preparation and analysis.
- Work with data warehouse and multi-source data, including ingestion, cleanup and integration.
- Document data definitions, business rules and data quality requirements.
- Run data audits and quality checks, and troubleshoot errors in reports.
- Communicate findings to clients, management and team members at all levels.
- Handle day-to-day deliverables and ad hoc reporting requests.
Required skills
- Power BI and/or Tableau, plus SSRS
- SQL (writing and reading others' queries) and relational databases
- Data warehousing concepts
- Python
- Excel, Outlook and Teams
- Strong written and verbal communication and a customer-service mindset
- Good visual sense for report design
- Strong analytical, organizational and multitasking skills
Nice to have
- Experience with cloud and on-premises data warehouse platforms, including Microsoft Fabric, Azure, Snowflake, Databricks, Redshift, and SQL Server.
- Healthcare or Pharma domain experience
- Advanced analytics or forecasting experience
Experience
- Bachelor's degree in information systems, computer science or a related field, or equivalent experience
- Entry-level (recent graduates on OPT/STEM OPT welcome) to 5+ years of experience in data analysis, query design and reporting
- Valid US work authorization
What we offer
- Competitive pay
- Immigration support
- Real client projects and space to grow your BI career
How to apply: Click Apply, or send your resume to . Visit 2dot2.com to learn more. 2DOT2 INC is an equal opportunity employer. We consider all qualified applicants regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other protected characteristics.
Job Types: Full-time, Part-time, Contract
Pay: $40,000.00 - $100,000.00 per year
Ability to Commute: San Diego, CA 92126 (Required)
Ability to Relocate: San Diego, CA 92126: Relocate before starting work (Required)
Work Location: In person
Visa sponsorship record: 2DOT2 Inc
Sponsors occasionally| Fiscal year | H-1B LCAs | USCIS approvals | USCIS denials | PERM |
|---|---|---|---|---|
| FY2026 | 1 | — | — | — |
| FY2025 | 1 | 1 | 0 | — |
✔ 2DOT2 Inc filed 2 H-1B applications for this kind of role (Data Scientists) in the period above.
Roles they sponsor most
- business intelligence analyst1 LCA · median $79k
- data analyst1 LCA · median $78k
Which visas can work for this job
Occupation: Data Scientists (SOC 15-2051).
- 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 “Mathematician / Statistician” — 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
Below Level IData Scientists · San Diego-Chula Vista-Carlsbad, CA. Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $80,600 | ~15% |
| Level II | $107,390 | ~31% |
| Level III | $134,202 | ~46% |
| Level IV | $160,992 | ~61% |
This job pays $40,000–$100,000 a year — below the Level I prevailing wage. For H-1B the employer must pay at least the prevailing wage, so the offer would have to go up.
* 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.