ADT LLC
Manager, Data Analytics and Business Intelligence
A-22228-06446
H-1B
2023
Withdrawn
Salary
$102,253
Visa Type
H-1B
Job Title
Manager, Data Analytics and Business Intelligence
Employee's Citizenship
INDIA
Graduate School
UNIVERSITY OF ILLINOIS AT SPRINGFIELD
Case info
9 fields
Data Publish Year
2023
Case Number
A-22228-06446
Case Status
Withdrawn
Received Date
2022-09-15
Decision Date
2023-02-03
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
ADT LLC
Employer Address_Line 1
1501 YAMATO ROAD
Employer Address_Line 2
-
Employer City
BOCA RATON
State
-
Employer State/ Province
FLORIDA
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
33431
Employer Phone No.
561-981-4581
Employer Phone Extent No.
-
Total Number of Employees
17000
Employer Year of Commenced
2012
NAICS Code
561621
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
David A Buchsbaum
Employer Contact Address Line1
1501 Yamato Road
Employer Contact Address Line2
-
Employer Contact City
Boca Raton
Employer Contact State/ Provice
FLORIDA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
33431
Employer Contact Phone
561-226-2865
Employer Contact Email
dbuchsbaum@adt.com
Attorney
11 fields
Agent/ Attorney Name
Megan R Naughton
Agent/ Attorney Firm Name
Robinson Cole LLP
Agent/ Attorney Phone
8602758263
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
280 Trumbull Street, Floor 28
Agent/ Attorney Address Line 2
-
Agent/ Attorney City
Hartford
Agent/ Attorney State/ Province
CONNECTICUT
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
6103
Agent/ Attorney Email
mnaughton@rc.com
Position Info
89 fields
Prevailing Wage Track Number
P10021274618720
Prevailing Wage SOC Code
15-1199
Prevailing Wage SOC Title
Business Intelligence Analysts
Prevailing Wage Skill Level
Level IV
Prevailing Wage
102253
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-05-17
Prevailing Wage Expiration Date
2022-08-15
Wage Offer From
102253
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
1501 Yamato Road
Worksite Address Line 2
-
Worksite City
Boca Raton
Worksite State
FLORIDA
Worksite Postal Code
33431
Job Title
Manager, Data Analytics and Business Intelligence
Minimum Education
Master's
Other Degree/ Diploma
-
Major Field of Study
Management Information Systems
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
N
Required Expreience Months
-
Accept Alternate Field of Study
Y
Accept Alternate Major
A field related to Management Information Systems.
Alternate Combination of Education/ Experience
Y
Required Alternate Level of Education
Bachelor's
Other Alternate Level of Education
-
Acceptable Years of Experience
5
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
36
Accept Alternate Job Title
Experience in data analytics and reporting or a related role.
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Must possess the following at least 3 years of experience running queries using OracleSQL, including using PostgreSQL to interact with Redshift; at least 3 years of experience using Python, ASW, GCP and Firebase to derive insights; at least 3 years of experience using a data mart to create reportsanalysisdashboards; at least 3 years of experience working for a subscriptionbased service company; and at least 2 years of experience identifying and interpreting new unstructured big data in order to perform both analysis and reporting using ETL to movetransform data and Tableau for data visualization.
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-06-10
Job Oder End Date
2022-07-11
Sunday Edition Newspaper
Y
First Newspaper Name
Sun Sentinel
First Advertisement Start Date
2022-06-19
Second Newspaper Name
Sun Sentinel
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-06-26
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
2022-06-13
Employer Website to Date
2022-06-27
Pro. Org. Ad from Date
2022-06-21
Pro.Org. Ad to Date
2022-07-21
Job Search Website from Date
-
Job Search Website to Date
-
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-06-17
Local Ethnic Newspaper to Date
2022-06-23
Radio/TV Ad from Date
-
Radio/TV Ad to Date
-
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
Master's
Foreign Worker Education Other
-
Foreign Worker Major
MANAGEMENT INFORMATION SYSTEMS
Year of Compelted Education
2016
Foreign Worker Istitution of Eduation
UNIVERSITY OF ILLINOIS AT SPRINGFIELD
Foreign Worker Education Instution Address Line 1
ONE UNIVERSITY PLAZA
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
SPRINGFIELD
Foreign Worker Educatution Institution State
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
62703
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N/A
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
Megan R Naughton
Preparer Title
Attorney
Preparer Email
mnaughton@rc.com
Employer Information Declaration Name
David A Buchsbaum
Employer Declaration Title
Deputy General Counsel, Labor Employment