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