Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:THE BOSTON CONSULTING GROUP
Employer Address_Line 1:200 PIER FOUR BOULEVARD
Employer Address_Line 2:
Employer City :BOSTON
State:
Employer State/ Province:MASSACHUSETTS
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:2210
Employer Phone No.:(617) 973-1200
Employer Phone Extent No.:
Total Number of Employees:7730
Employer Year of Commenced :
NAICS Code:541611
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Jacqueline O'Connor
Employer Contact Address Line1:200 PIER FOUR BOULEVARD
Employer Contact Address Line2:
Employer Contact City:Boston
Employer Contact State/ Provice:MASSACHUSETTS
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:2210
Employer Contact Phone:(617) 973-1200
Employer Contact Email:OConnor.Jacqui@bcg.com
Attorney
Agent/ Attorney Name:Mahsa Aliaskari
Agent/ Attorney Firm Name:Seyfarth Shaw LLP
Agent/ Attorney Phone:(213) 270-9679
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:601 S Figueroa Street
Agent/ Attorney Address Line 2:Suite 3300
Agent/ Attorney City:Los Angeles
Agent/ Attorney State/ Province:CALIFORNIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:90017
Agent/ Attorney Email:maliaskari@seyfarth.com
Position Info
Prevailing Wage Track Number:P10020365983359
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Data Warehousing Specialists
Prevailing Wage Skill Level:Level IV
Prevailing Wage:93246
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-06-22
Prevailing Wage Expiration Date :2021-09-20
Wage Offer From:203000
Wage Offer To:253750
Wage Offer Unit of Pay:Year
Workstie Address Line 1:444 Liberty Avenue
Worksite Address Line 2:Suite 1600
Worksite City :Pittsburgh
Worksite State:PENNSYLVANIA
Worksite Postal Code:15222
Job Title:Principal Data Engineer
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 :N
Required Expreience Months :
Accept Alternate Field of Study:Y
Accept Alternate Major:Engineering, Data Science, Applied Mathematics or related field
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Master's
Other Alternate Level of Education:
Acceptable Years of Experience:6
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:96
Accept Alternate Job Title:Working on largescale, full lifecycle data implementation projects.
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Continued from H.10B Requires a Bachelors degree in computer science, engineering, data science, applied mathematics or related field willing to accept foreign education equivalent plus eight 8 years of experience in working on largescale, full lifecycle data implementation projects or, alternatively, a Masters degree with an underlying bachelors in computer science, engineering, data science, applied mathematics or related field and six 6 years of experience as stated. Specific skillsother requirements Must also possess the following two 2 years of experience developing software architectures and deploying data pipelines, and designing data analytics platforms onpremises or in the cloud using the AWS, Azure, or GCP stack; quantitative experience requirements not applicable to this section data modeling, building data marts and data warehouses, and implementing predictive analytics and machine learning models; designing and developing data integration, data lake, and data management solutions; handson RDBMS experience performing data modeling, analysis, programming, and stored procedures; developing and automating ETLELT workflows with Python, Scala, Delta Lake, or Spark; utilizing data management tools, including RDBMS technology, Big Data technology, Enterprise Data Management, or NoSQL platforms; developing organizational data strategy, data architecture plans and implementation roadmaps, and conducting architecture assessments; developing best practices and standards to assist in the implementation of data governance; migrating onprem legacy applications into cloud ecosystem; developing MDM strategy, process design, architecture and the implementation plan for customer 360, supplier 360 and various other master data; and data visualization of complex data sets with tools such as Tableau or PowerBI.
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:2021-10-01
Job Oder End Date:2021-11-05
Sunday Edition Newspaper:Y
First Newspaper Name:The Pittsburgh PostGazette
First Advertisement Start Date:2021-10-03
Second Newspaper Name:The Pittsburgh PostGazette
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-10-10
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:2021-09-14
Job Search Website to Date:2021-10-05
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-09-21
Employee Referral Program to Date:2021-10-14
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:
Local Ethnic Newspaper to Date:
Radio/TV Ad from Date:2021-10-20
Radio/TV Ad to Date:2021-10-21
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
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:BUSINESS ADMINISTRATION
Year of Compelted Education:2015
Foreign Worker Istitution of Eduation:THE UNIVERSITY OF NORTH CAROLINA AT GREENSBORO
Foreign Worker Education Instution Address Line 1:1400 SPRING GARDEN ST.
Foreign Worker Education Institution Address Line 2:
