DELOITTE CONSULTING LLP
Consulting, Specialist Senior
A-22214-98697
H-1B
2023
Certified
Salary
$58,094
Visa Type
H-1B
Job Title
Consulting, Specialist Senior
Employee's Citizenship
INDIA
Graduate School
CARNEGIE MELLON UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22214-98697
Case Status
Certified
Received Date
2022-09-22
Decision Date
2023-07-27
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
DELOITTE CONSULTING LLP
Employer Address_Line 1
1700 MARKET STREET
Employer Address_Line 2
-
Employer City
PHILADELPHIA
State
-
Employer State/ Province
PENNSYLVANIA
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19103
Employer Phone No.
214-840-1464
Employer Phone Extent No.
-
Total Number of Employees
30600
Employer Year of Commenced
1996
NAICS Code
541611
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Sarah B Dieckbernd
Employer Contact Address Line1
191 Peachtree Street NE
Employer Contact Address Line2
Suite 2000
Employer Contact City
Atlanta
Employer Contact State/ Provice
GEORGIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
30303
Employer Contact Phone
404-631-2000
Employer Contact Email
permservices@deloitte.com
Attorney
11 fields
Agent/ Attorney Name
Ana V Perez
Agent/ Attorney Firm Name
Berry Appleman Leiden LLP
Agent/ Attorney Phone
(469) 505-2316
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
2400 N Glenville Drive
Agent/ Attorney Address Line 2
Building A
Agent/ Attorney City
Richardson
Agent/ Attorney State/ Province
TEXAS
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
75082
Agent/ Attorney Email
DCPERM@BAL.com
Position Info
89 fields
Prevailing Wage Track Number
P10021237544565
Prevailing Wage SOC Code
15-1199
Prevailing Wage SOC Title
Data Warehousing Specialists
Prevailing Wage Skill Level
Level I
Prevailing Wage
58094
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-05-09
Prevailing Wage Expiration Date
2022-08-07
Wage Offer From
143500
Wage Offer To
150675
Wage Offer Unit of Pay
Year
Workstie Address Line 1
1015 2nd Ave
Worksite Address Line 2
and various unanticipated Deloitte office locations and client sites nationally.
Worksite City
Seattle
Worksite State
WASHINGTON
Worksite Postal Code
98104-1126
Job Title
Consulting, Specialist Senior
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
See H.14
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
Y
Required Expreience Months
24
Accept Alternate Field of Study
Y
Accept Alternate Major
See H.14
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
24
Accept Alternate Job Title
See H.14
Normal Requirements of Job Opportunity
Y
Required Foreign Language
N
Specific Skills
Bachelors degree or foreign equivalent in Business Administration, any STEM field or a related field and two 2 years of related work experience in the job offered or in a related occupation. Must also have two 2 years of related work experience involving each of the followingbr Providing industry insight and analytical support using data mining, pattern matching, data visualization, and predictive modeling tools including Machine Learning models, Artificial Intelligence algorithms, mixed integer linear and nonlinear programming techniques, statistical modeling techniques, and libraries including Matplotlib Seaborn and Tableau, and consolidating the implications to presentbr recommendations to senior management and executives;br Providing insights into businesses using statistical tools and data modeling of relational databases including MSSQL, PostgreSQL, MongoDB, Amazon DynamoDB, Google BigQuery, R, Python and Amazon Relational Database RDB;br Utilizing cloudbased tools including DataBricks, Palantir Foundry, Jira, IPython Notebook, and Alteryx to coordinate and drive aspects of the full data delivery lifecycle for implementations, including business, technical and application requirements gathering, business process analysis, scripting, code deployments, enhancement validation, triage of defects and change requests, escalations and urgent issues;br Performing data analysis, including inspecting, cleansing, transforming and modeling for enabling data mining and resolving data mapping and data modeling issues using Python, Pandas, Spark, PySpark, Java and Regular Expression RegEx;br Interviewing business stakeholders to understand current and target state requirements and agree on engagement objectives and scope. Develop work plans and identify scope changes;br Developing, testing, and automating ETL Extract, Transform, Load procedures using Python, R, Groovy, Java, Extensible Markup Language XML, Selenium, UiPath, Automation Anywhere, WorkFusion, SQL, Hive, Impala and Google BigQuery to perform data warehousing and data integration functions;br Working with Collibra, IBM Data Governance and Jira to create custom build objects in order to maintain the Data Governance process, policies and standards; andbr Utilizing Python, R, MultiParadigm Programming Language MATLAB, Tableau, Power BI to generate insights leveraging cloudbased applications including Amazon Web Services AWS, Google Cloud Platform GCP, Azure, SharePoint, or Cloudera.br br 50 Travel Required Nationally.br Telecommuting Permitted.br br Addendum to H.1 Please note that the permanent work location is in the same area of intended employment as that set forth in the prevailing wage determination and recruitment, as the two addresses are within 0.5 miles of each other.
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-15
Job Oder End Date
2022-07-20
Sunday Edition Newspaper
Y
First Newspaper Name
The Seattle Times
First Advertisement Start Date
2022-06-19
Second Newspaper Name
The Seattle Times
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-08-17
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-06-15
Job Search Website to Date
2022-06-29
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
2022-06-13
Employee Referral Program to Date
2022-07-04
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
-
Local Ethnic Newspaper to Date
-
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
CHEMICAL ENGINEERING
Year of Compelted Education
2017
Foreign Worker Istitution of Eduation
CARNEGIE MELLON UNIVERSITY
Foreign Worker Education Instution Address Line 1
5000 FORBES AVE.
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
PITTSBURGH
Foreign Worker Educatution Institution State
PA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
15213
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N
Foreign Worker Alternate Education and Experience
N/A
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
Ana V Perez
Preparer Title
Associate Immigration Attorney
Preparer Email
DCPERM@BAL.com
Employer Information Declaration Name
Sarah Dieckbernd
Employer Declaration Title
Lead Immigration Specialist