TIREHUB, LLC

BI TECHNICAL LEAD

A-22210-97165 H-1B 2023 Certified
Salary

$119,538

Visa Type

H-1B

Job Title

BI TECHNICAL LEAD

Employee's Citizenship

INDIA

Graduate School

VISVESWARAIAH TECHNOLOGICAL UNIVERSITY

Case info

9 fields
Data Publish Year 2023
Case Number A-22210-97165
Case Status Certified
Received Date 2022-08-01
Decision Date 2023-07-06
Refile N
Original File Date -
Previous State Work Force Agency (SWA) Case Number Stete -
Schedule A or a Sheepherder Occupation N

Company Info

14 fields
Employer Name TIREHUB, LLC
Employer Address_Line 1 1 RAVINIA DRIVE NORTHEAST
Employer Address_Line 2 SUITE 1300
Employer City DUNWOODY
State -
Employer State/ Province GEORGIA
Employer Country UNITED STATES OF AMERICA
Employer Postal Code 30346
Employer Phone No. 470-377-9000
Employer Phone Extent No. -
Total Number of Employees 1000
Employer Year of Commenced 2018
NAICS Code 42313
Foreign Worker Ownership & Interest N

HR Info

9 fields
Employer Contact Name Amanda Garcia
Employer Contact Address Line1 1 Ravinia Drive Northeast
Employer Contact Address Line2 -
Employer Contact City Dunwoody
Employer Contact State/ Provice GEORGIA
Employer Contact Country UNITED STATES OF AMERICA
Employer Contact Post Code 30346
Employer Contact Phone 470-377-9000
Employer Contact Email amanda.garcia@tirehub.com

Attorney

11 fields
Agent/ Attorney Name Ellen Freeman
Agent/ Attorney Firm Name Ellen Freeman Immigration Law Group PLLC
Agent/ Attorney Phone 4128226500
Agent/ Attorney Phone Ext. -
Agent/ Attorney Address Line 1 PO Box 11374
Agent/ Attorney Address Line 2 -
Agent/ Attorney City Pittsburgh
Agent/ Attorney State/ Province PENNSYLVANIA
Agent/ Attorney Country UNITED STATES OF AMERICA
Agent/ Attorney Postal Code 15238
Agent/ Attorney Email efreeman@freemanimmigration.com

Position Info

89 fields
Prevailing Wage Track Number P10021260590111
Prevailing Wage SOC Code 15-1199
Prevailing Wage SOC Title Computer Systems EngineersArchitects
Prevailing Wage Skill Level Level IV
Prevailing Wage 119538
Prevailing Wage Unit of Pay Year
Prevailing Wage Source OES
Prevailing Wage Other Source -
Prevailing Wage Determination Date 2022-05-11
Prevailing Wage Expiration Date 2022-08-09
Wage Offer From 119538
Wage Offer To -
Wage Offer Unit of Pay Year
Workstie Address Line 1 1 Ravinia Dr Ste 1300
Worksite Address Line 2 -
Worksite City Atlanta
Worksite State GEORGIA
Worksite Postal Code 30343
Job Title BI TECHNICAL LEAD
Minimum Education Bachelor's
Other Degree/ Diploma -
Major Field of Study Computer Science
Required Training N
Required Training Month -
Required Field of Training -
Required Experience Y
Required Expreience Months 120
Accept Alternate Field of Study Y
Accept Alternate Major Engineering or related
Alternate Combination of Education/ Experience N
Required Alternate Level of Education -
Other Alternate Level of Education -
Acceptable Years of Experience -
Accept Foreign Educationa Y
Acceptable Alternate Occupation Y
Acceptable Alternate Occupation Month 120
Accept Alternate Job Title ETL Data Engineer or related
Normal Requirements of Job Opportunity N
Required Foreign Language N
Specific Skills 10 years of prior experience as in ETL Data Engineer working with ETL, Data Warehousing, and Bl Technologies with special requirements of 3 years experience in data dimensional modeling for DW Kimball star schema architectures; 1 year experience in designing and developing Power Bl dataflows, datasets, and reports; 10 years experience writing andor reviewing complex Microsoft TSQL, data extracts, and data cleansing processes; 10 years experience using Microsoft SSIS to build ETL solutions; 3 years of experience in SQL query optimization; 2 years experience in building data factory pipelines using Azure Data Factory; 1 year experience in building workflows in Power Automate; Experience migrating from OnPremises relational model to Azure Cloud Bl architecture.
Combination Occupation N
Offered to Applied Foreign Worker Y
ForeignWorker Live on Premises N
Live in Domestic Service Worker N
Employment Contract -
Professional Occupation Y
College/ University Teacher N
Competitive Process -
Basic Recruitment Process -
Teacher Select Date -
Teacher Publish Journal Name -
Additional Recruitment Information -
Job Oder Start Date 2022-05-18
Job Oder End Date 2022-06-20
Sunday Edition Newspaper Y
First Newspaper Name Atlantic Journal Constitution
First Advertisement Start Date 2022-05-22
Second Newspaper Name Atlantic Journal Constitution
Second Advertisement Type Newspaper
Second Ad Start Date 2022-05-29
Job Fair From Date -
Job Fair to Date -
On Campus Recruiting from Date -
On Campus Recruiting to Date -
Employer Website from Date -
Employer Website to Date -
Pro. Org. Ad from Date -
Pro.Org. Ad to Date -
Job Search Website from Date 2022-05-17
Job Search Website to Date 2022-06-03
Private Employment Firm from Date -
Pricate Employment Firm to Date -
Employee Referral Program from Date -
Employee Referral Program to Date -
Campus Placement from Date -
Campus Placement to Date -
Local Ethnic Newspaper from Date 2022-05-26
Local Ethnic Newspaper to Date 2022-05-26
Radio/TV Ad from Date 2022-05-25
Radio/TV Ad to Date 2022-05-25
Employer Received the Payment N
Payment Details -
Bargaining Representative Notified N/A
Posted Notice at Worksite Y
Layoff in Past Six Months N
US Worker Considered -
Country of Citizenship INDIA
Foreign Worker Birth Country INDIA
Class of Admission H-1B

Employee Info

24 fields
Foreign Worker Education Bachelor's
Foreign Worker Education Other -
Foreign Worker Major COMPUTER SCIENCE, INFORMATION SCIENCE AND ENGINEERING
Year of Compelted Education 2009
Foreign Worker Istitution of Eduation VISVESWARAIAH TECHNOLOGICAL UNIVERSITY
Foreign Worker Education Instution Address Line 1 MACHHE, BELAGAVI
Foreign Worker Education Institution Address Line 2 JNANA SANGAMA, VTU MAIN RD, VISVESVARAYA TECHNOLOGICAL UNIVERSITY
Foreign Worker Education Institution City BELGAUM
Foreign Worker Educatution Institution State KARNATAKA
Foreign Worker Education Institution Country INDIA
Foreign Worker Education Training Post Code 590018
Foreign Worker Training Completion N/A
Foreign Worker Required Experience Y
Foreign Worker Alternate Education and Experience N
Foreign Worker Alternate Occupation Experience Y
Foreign Worker Experience with Employer N
Foreign Worker Employer Pay for Education N
Foreign Worker Currently Employed Y
Employer Completed Application N
Preparer Name Ellen Freeman
Preparer Title Managing Partner
Preparer Email efreeman@freemanimmigration.com
Employer Information Declaration Name Amanda Garcia
Employer Declaration Title Human Resources Manager