Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:RIVIAN AUTOMOTIVE, LLC
Employer Address_Line 1:14600 MYFORD ROAD
Employer Address_Line 2:
Employer City :IRVINE
State:
Employer State/ Province:CALIFORNIA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:92606
Employer Phone No.:734-892-7091
Employer Phone Extent No.:
Total Number of Employees:7000
Employer Year of Commenced :
NAICS Code:336111
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Natasha Hines
Employer Contact Address Line1:13250 N. Haggerty Road
Employer Contact Address Line2:
Employer Contact City:Plymouth
Employer Contact State/ Provice:MICHIGAN
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:48170
Employer Contact Phone:734-892-7091
Employer Contact Email:nhines@rivian.com
Attorney
Agent/ Attorney Name:Aviva Meerschwam
Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy, LLP
Agent/ Attorney Phone:2129094126
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:1400 Broadway
Agent/ Attorney Address Line 2:9th Floor
Agent/ Attorney City:New York
Agent/ Attorney State/ Province:NEW YORK
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:10018
Agent/ Attorney Email:rivianivteam@fragomen.com
Position Info
Prevailing Wage Track Number:P10021026033085
Prevailing Wage SOC Code :15-1133
Prevailing Wage SOC Title :Software Developers, Systems Software
Prevailing Wage Skill Level:Level II
Prevailing Wage:120578
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-06-08
Prevailing Wage Expiration Date :2021-09-06
Wage Offer From:125900
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:607 Hansen Way
Worksite Address Line 2:
Worksite City :Palo Alto
Worksite State:CALIFORNIA
Worksite Postal Code:94304
Job Title:AWS Data Engineer
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:Computer Science, Engineering, Information Technology, Mathematics, or a closely related field
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
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:24
Accept Alternate Job Title:Software development, data architecture, data engineering, business intelligence...See H.14
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Masters degree or foreign equivalent Computer Science, Engineering, Information Technology, Mathematics, or a closely related field plus 2 years of experience in software development, data architecture, data engineering, business intelligence, data science with a track record of manipulating, processing, and extracting value from large datasets. Alternatively, employer will accept a Bachelors degree or foreign equivalent in an acceptable field as stated above plus 5 years of progressively responsible experience as stated above. Experience must include Managing Big Data and data warehousing services offered by AWS; Working with AWS big data technologies, including Redshift, Spectrum, S3, EMR, Glue, Athena and big data technologies, including Hadoop, Hive, Hbase, and Spark; Creating data management strategies and tuning large Redshift clusters; Developing ETL, data modeling, and data warehousing; Buildingoperating highly available, distributed systems of data extraction, ingestion, and processing large data sets; Utilizing analytics reporting tools, such as Tableau, Power BI, Qlikview and programming languages, such as Java, Python, and Scala; and Working with data base in Relational, Columnar and NOSQL databases such as Redshift, DynamoDB. MongoDB, AND SQL Server.br br QUALIFICATIONS OF THE FOREIGN NATIONAL SEE ALSO SECTIONS J AND K The beneficiary readily meets the minimum requirements of the offered position. Specifically, as detailed in Section J, in 2017 the beneficiary completed a Masters degree in Information Technology Management. In addition, the beneficiary possesses in excess of 2 years of experience in software development, data architecture, data engineering, business intelligence, data science with a track record of manipulating, processing, and extracting value from large datasets by virtue of his employment with Stier Solutions Inc. from November 1, 2008 to January 3, 2020, Wise Equations Solutions from March 27, 2018 to October 31, 2018, and Logipro Software Pvt. Ltd. from December 1, 2014 to December 20, 2016. The beneficiarys experience included Managing Big Data and data warehousing services offered by AWS; Working with AWS big data technologies, including Redshift, Spectrum, S3, EMR, Glue, Athena and big data technologies, including Hadoop, Hive, Hbase, and Spark; Creating data management strategies and tuning large Redshift clusters; Developing ETL, data modeling, and data warehousing; Buildingoperating highly available, distributed systems of data extraction, ingestion, and processing large data sets; Utilizing analytics reporting tools, such as Tableau, Power BI, Qlikview and programming languages, such as Java, Python, and Scala; and Working with data base in Relational, Columnar and NOSQL databases such as Redshift, DynamoDB. MongoDB, AND SQL Server.
