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