All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22340-68665
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22340-68665
Case Status
Certified-Expired
Received Date
2022-12-22
Decision Date
2023-12-06
Refile
N
Original File Date
2024-01-01 00:22:57
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
AVANADE
Employer Name Slug
avanade
Employer Address 1
1191 SECOND AVE
Employer Address 2
SUITE 100
Employer City
SEATTLE
Employer City Slug
seattle
Employer State
WASHINGTON
Employer State Slug
washington
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98101
Employer Phone
(206) 239-5822
Employer Number of Employees
3550
Employer Year Commenced Business
2000
NAICS Code
5416
FW Ownership Interest
N
Employer Contact Name
Nadine L Stanley-Ranger
Employer Contact Address 1
1191 Second Ave
Employer Contact Address 2
Suite 100
Employer Contact City
Seattle
Employer Contact State/Province
WASHINGTON
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
98101
Employer Contact Phone
(206) 577-2611
Employer Contact Email
n.l.stanley-ranger@avanade.com
Agent Attorney Name
Nancy M Nemeth
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
(312) 263-6101
Agent Attorney Address 1
333 W. Wacker Drive
Agent Attorney Address 2
15th Floor
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60606
Agent Attorney Email
nnemeth@fragomen.com
PW Track Number
P10022031864705
PW SOC Code
15-1243.00
PW SOC Title
Database Architects
PW Skill Level
Level IV
PW Wage
127941.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-07-27
PW Expiration Date
2023-06-30
Wage Offer From
127941.00
Wage Offer To
0.00
Average Salary
127941.00
Wage Unit of Pay
Year
Worksite Address 1
750 Town and Country Boulevard
Worksite Address 2
Suite 710
Worksite City
Houston
Worksite City Slug
houston
Worksite State
TEXAS
Worksite Postal Code
77024
Job Title
Advanced Analytics Consultant
Job Title Slug
advanced-analytics-consultant
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Information Technology, Statistics, or a related technical or quantitative field.
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
None
Accept Alternative Combination Education Years
7
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
48
Accept Alternative Job Title
Exp in the job offered, or as a Data AnlystAnlytics Engr, or in a similar IT or IT consulting role
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
The position requires at least a bachelors degree, or its foreign equivalent, in Computer Science, Information Technology, Statistics, or a related technical or quantitative field, plus at least four 4 years of experience in the job offered, or as a Data AnalystAnalytics Engineer, or in a similar IT or IT consulting role. Alternatively, in lieu of a bachelors degree and four 4 years of experience, the employer will accept no degree and seven 7 years of experience in the job offered, or as a Data AnalystAnalytics Engineer, or in a similar IT or IT consulting role. The employer deems that any suitable combination of education, training, or experience is acceptable. A qualified applicants experience must include 4 years of experience translating business requirements into technical requirements and sustainable data modelssolutions; 2 years of experience utilizing the Microsoft Database Management Systems SQLNoSQL; 1 year of experience utilizing programming languages C#PythonScalaRSAS or any other language for data analysis or statistical modeling; 2 years of experience utilizing Data Management Practices and Patterns Relational Databases, Data Lakes, Data Modeling, ETL, and Data Visualization; 1 year of experience working throughout the full software development lifecycle win an Agile Framework or Waterfall methodology; 1 year of experience designing, developing, and testing ETL mappings; and 2 years of experience designing and building data visualizations in SSRS, Power BI or any other visualization tool. Avanade requires all employees to be fully vaccinated against COVID19 as a condition of employment. Avanade will consider requests for medical or religious accommodation to this vaccination requirement on an individual basis.
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2022-09-15
SWA Job Order End Date
2022-10-20
Sunday Edition Newspaper
Y
First Newspaper Name
Houston Chronicle
First Advertisement Start Date
2022-08-28
Second Newspaper Ad Name
Houston Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-09-04
Employer Website From Date
2022-08-23
Employer Website To Date
2022-11-01
Professional Organization Ad From Date
2024-01-01 00:22:57
Professional Organization Advertisement To Date
2024-01-01 00:22:57
Job Search Website From Date
2022-08-29
Job Search Website To Date
2022-09-12
Employee Referral Program From Date
2024-01-01 00:22:57
Employee Referral Program To Date
2024-01-01 00:22:57
Local Ethnic Paper From Date
2022-09-02
Local Ethnic Paper To Date
2022-09-02
Radio/TV Ad From Date
2024-01-01 00:22:57
Radio/TV Ad To Date
2024-01-01 00:22:57
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
CANADA
Foreign Worker Birth Country
CHINA
Class of Admission
TN
Foreign Worker Education
Master's
Foreign Worker Information: Major
MANUFACTURING MANAGEMENT
Foreign Worker Years of Education Completed
2011
Foreign Worker Institution of Education
MCGILL UNIVERSITY
Foreign Worker Education Institution Address 1
845 SHERBROOKE ST W
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
MONTREAL
Foreign Worker Education Institution State/Province
QUEBEC
Foreign Worker Education Institution Country
CANADA
Foreign Worker Education Institution Postal Code
H3A 0G4
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Nancy M Nemeth
Preparer Title
Senior Attorney
Preparer Email
nnemeth@fragomen.com
Employer Information Declaration Name
Nadine L StanleyRanger
Employer Information Declaration Title
Manager, Business HR Immigration