DELOITTE CONSULTING LLP

Consulting, Manager

A-22224-05094 H-1B 2023 Certified

Salaire

$114,899

Type de visa

H-1B

Intitulé du poste

Consulting, Manager

Citoyenneté de l'employé

INDIA

École de diplôme

UNIVERSITY OF MUMBAI

Info du cas Info entreprise Info RH Avocat Info poste Info employé

Info du cas

9 fields

数据公布年 2023

申请编号 A-22224-05094

申请状态 Certified

收件日期 2022-09-12

通过日期 2023-08-09

曾备案（Y/N） N

原备案日期 -

原SWA申请编号 -

是否为紧缺/短缺职位 N

Info entreprise

14 fields

雇主公司名 DELOITTE CONSULTING LLP

雇主地址-第一行 1700 MARKET STREET

雇主地址-第二行 -

雇主城市 PHILADELPHIA

申请州 -

雇主所在州/省 PENNSYLVANIA

雇主所在国 UNITED STATES OF AMERICA

雇主邮编 19103

雇主电话 214-840-1464

雇主分机号 -

雇员总数 30600

雇主经营年限 1996

北美行业代码 541611

雇员雇主所有权及家庭联系 N

Info RH

9 fields

雇主联系人 Sarah B Dieckbernd

雇主联系人地址 191 Peachtree Street NE

雇主联系人地址 Suite 2000

雇主联系人城市 Atlanta

雇主联系人州/省 GEORGIA

雇主联系人国 UNITED STATES OF AMERICA

雇主联系人邮编 30303

雇主联系人电话 404-631-2000

雇主联系人邮件 permservices@deloitte.com

Avocat

11 fields

代理人/律师姓名 Diego G Menendez

代理人/律师公司名称 Berry Appleman Leiden LLP

代理人/律师电话 4695052316

代理人/律师分机号 -

代理人/律师地址 2400 N Glenville Drive

代理人/律师地址 Building A

代理人/律师城市 Richardson

代理人/律师州/省 TEXAS

代理人/律师国 UNITED STATES OF AMERICA

代理人/律师邮编 75082

代理人/律师邮箱 DCPERM@bal.com

Info poste

89 fields

现行工资跟踪号 P10021237544270

职业代码 15-1199

职业名称 Data Warehousing Specialists

技能等级 Level IV

现行工资 114899

现行工资周期 Year

现行工资信息实体 OES

其他现行工资信息来源 -

现行工资确定日期 2022-05-16

现行工资失效日期 2022-08-14

起薪点 158900

工资最高点 166845

工资支付周期 Year

工作地址 111 S Wacker Drive

工作地址 Various unanticipated Deloitte office locations and client sites nationally.

工作城市 Chicago

工作州 ILLINOIS

工作邮编 60606

工作职位 Consulting, Manager

最低学历 Master's

其他教育学历 -

对应专业 See H.14

所需培训 N

培训时长 -

所需培训领域 -

前置经验 Y

经验时长（月） 36

替代领域学历 Y

替代专业 See H.14

可替代教育及经验组合 Y

所需教育层级 Bachelor's

其他可替代教育层级 -

认可经验年限 5

境外教育背景 Y

可替代职业 Y

可替代职业时长（月） 36

可替代职业名称 See H.14

是否为正常职业要求 N

是否需要外语 N

特殊技能 H.11 job dutiesbr Conduct user testing workshops with Key client stakeholders to ensure the deliverable matches the requirement, utilizing AWS, EMR spark, PostgreSQL, Athena , S3, Python, Pyspark , Snowflake, Oracle, Datastage, Tableau, Cognos, PLSQL, Unix, Control M, Microsoft word, Excel, MS Visio, Balsamic and PowerPoint. Follow one of the project execution model such as Waterfall, Agile using MS Project plan, MS PowerPoint, MS excel and JIRA. Provide required training to use the software and required knowledge transfer to manage the system.br br H.14 skillsbr Masters degree or foreign equivalent in Business Administration, any STEM field, or a related field and three 3 years of related work experience in the job offered or in a related occupation. In the alternative, the employer will accept a Bachelors degree or foreign equivalent and five 5 years of progressive related work experience in the job offered or in a related occupation. Must also have three 3 years of related work experience involving each of the followingbr br Managing teams, utilizing Amazon Web Services AWS, Elastic MapReduce EMR Spark, Athena, Snowflake, PostgreSQL, Oracle, Unix, DataStage, Control M, PLSQL, Amazon S3, UC4, Bitbucket, Cognos, and Tableau to generate insights leveraging Onpremise, Web, and Cloudbased platforms;br Managing complex engagements and teams that perform data management, including master data, metadata, data architecture, data governance, data quality, and data modeling, while utilizing AWS, EMR Spark, Athena, Snowflake, PostgreSQL, Oracle, Unix, DataStage, Control M, PLSQL, Amazon S3, UC4, Bitbucket, Cognos, and Tableau;br Managing teams that work to provide industry insight and analytical support, using data mining, pattern matching, data visualization, and predictive modeling tools, including AWS, Athena, EMR Spark, Snowflake, PostgreSQL, Oracle, Unix, DataStage, PLSQL, Cognos, and Tableau to produce analysis and algorithms;br Formulating and creating functional and nonfunctional specification documentation for product development and roadmaps, business process reengineering, business modeling, analytical and business rules definition, highly detailed user flows and process flows, annotated wireframes, and design of interactions for complex applications, data architecture, and user interface and experience, utilizing Microsoft MS Word, MS Excel, MS PowerPoint, MS Visio, and Balsamic;br Improving data discovery, sourcing, modeling, and analytics by defining process mapping, decision mapping, and data governance to support the creation of data flows and models, using AWS, Athena, EMR Spark, Snowflake, PostgreSQL, Oracle, Unix, DataStage, PLSQL, Cognos, Tableau, MS Word, MS Excel, MS PowerPoint, MS Visio, and Balsamic;br Managing project and milestone deliverable status to ensure timely project delivery and communicating updates to internal and external stakeholders, utilizing MS Project Plan, MS Excel, MS PowerPoint, and Jira;br Overseeing the project responsibilities of crossfunctional onshore and offshore team members to ensure efficient completion of project tasks, utilizing MS Project Plan, MS Excel, MS PowerPoint, and Jira; andbr Interfacing directly with client stakeholders to gather functional and technical requirements, analyze client requirements, and translate requirements into project designs to deliver solutions that meet client needs, utilizing MS Word, MS Excel, MS PowerPoint, MS Visio, and Balsamic.br br Any suitable combination of education, training, or experience is acceptable.

职业组合 N

是否提供给申请人 Y

是否在地工作 N

是否为住家家政 N

是否签订合同 -

是否为专业职业 Y

是否为大学老师 N

竞争性招聘 -

基础招聘流程 -

竞争性招聘日期 -

广告投放期刊名 -

补充招聘信息 -

SWA订单开始日期 2022-06-03

SWA订单结束日期 2022-07-07

周日见报 Y

首次见报刊名 Chicago Tribune

首次见报日期 2022-06-12

二次见报刊名 Chicago Tribune

二次刊登种类 Newspaper

二次刊登日期 2022-06-19

招聘会起始日期 -

招聘会截止日期 -

校招起始日期 -

校招截止日期 -

雇主网站起始日期 2022-06-03

雇主网站截止日期 2022-08-08

专业机构起始日期 -

专业机构截止日期 -

招聘网站起始日期 2022-06-07

招聘网站截止日期 2022-06-21

私营就业起始日期 -

私营就业截止日期 -

内推起始日期 2022-06-03

内推结束日期 2022-06-24

校办推荐起始日期 -

校办推荐截止日期 -

本地报纸起始日期 -

本地报纸截止日期 -

电台/TV广告起始日期 -

电视/TV广告截止日期 -

聘方收费 N

收费细节 -

通知谈判代表 N/A

备案通知张贴 Y

雇主裁员 N

通知美国工人 -

外籍工人国籍 INDIA

工人出生国籍 INDIA

工人签证状态 H-1B

Info employé

24 fields

教育背景 Bachelor's

其他教育背景 -

专业背景 COMPUTER ENGINEERING

教育完成年份 2010

教育机构名 UNIVERSITY OF MUMBAI

教育机构地址1 121 MAHATMA GANDHI ROAD

教育机构地址2 -

工人受教城市 MUMBAI

工人受教州 MH

工人受教国 INDIA

工人受教邮编 400001

是否完成培训 N/A

所需经验 N

教育和经验 Y

外国工人经验 Y

雇主经验 N

雇主教育报销 N

受雇于请愿雇主 Y

雇主申请完成 N

准备者姓名 Diego G Menendez

准备者职位 Associate Immigration Attorney

准备者邮件 DCPERM@bal.com

雇主声明签字者姓名 Sarah Dieckbernd

雇主声明签署者职位 Lead Immigration Specialist