All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20034-14362
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-20034-14362
Case Status
Certified
Received Date
2020-02-13
Decision Date
2020-06-22
Refile
N
Original File Date
2020-01-01 08:35:44
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
NATIONAL COUNCIL OF YMCAS OF THE USA
Employer Name Slug
national-council-of-ymcas-of-the-usa
Employer Address 1
101 N Wacker Drive
Employer Address 2
Suite 1600
Employer City
Chicago
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60606
Employer Phone
800-872-9622
Employer Number of Employees
416
Employer Year Commenced Business
1982
NAICS Code
624110
FW Ownership Interest
N
Employer Contact Name
Jennifer E Boyd
Employer Contact Address 1
101 N Wacker Drive
Employer Contact Address 2
Suite 1600
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60606
Employer Contact Phone
800-872-9622
Employer Contact Email
jennifer.boyd@ymca.net
Agent Attorney Name
LISA M TAYLOR
Agent Attorney Firm Name
Ogletree, Deakins, Nash, Smoak Stewart, P.C.
Agent Attorney Phone
919-760-3000
Agent Attorney Address 1
8529 Six Forks Road
Agent Attorney Address 2
Forum IV, Suite 600
Agent Attorney City
Raleigh
Agent Attorney State/Province
NORTH CAROLINA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
27615
Agent Attorney Email
LISA.TAYLOR@odnss.com
PW Track Number
P10019140345771
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialist
PW Skill Level
Level IV
PW Wage
115211.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-09-18
PW Expiration Date
2020-06-30
Wage Offer From
120000.00
Wage Offer To
0.00
Average Salary
120000.00
Wage Unit of Pay
Year
Worksite Address 1
101 N. Wacker Dr.
Worksite Address 2
#1600
Worksite City
Chicago
Worksite City Slug
chicago
Worksite State
ILLINOIS
Worksite Postal Code
60606
Job Title
Sr. Business Intelligence Developer
Job Title Slug
sr-business-intelligence-developer
Minimum Education
Bachelor's
Major Field of Study
Business
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
CS, CE, EE, MIS or related field
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
related occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Applicants must also have the following experiencebr br 5 years withbr br Developing business intelligence solutions.br Architecting data warehouses, data acquisitions processes, and data structures to support reporting and analysis.br Writing and tuning TSQL.br Designing and developing ETL processes using Microsoft SQL Server Integration Services or similar enterprise ETL tool.br Designing and developing reports using Microsoft SQL Server Reporting Services or similar enterprise reporting tool.br br Demonstrated experience withbr br Designing and developing multidimensional and tabular databases such as Microsoft SQL Server Analysis Servicesbr Translating business requirements and desired outcomes into solution designs, processes and proceduresbr Communicating technical options and recommendations to stakeholdersbr Power BI, Tableau, or similar visualization toolsbr Microsoft Office Excel, Outlook, and Visiobr br Bachelors degree in Business, Computer Science, Computer Engineering, Electronic Engineering, Management Information System MIS or related field
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
2019-10-10
SWA Job Order End Date
2019-11-26
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago Tribune
First Advertisement Start Date
2019-10-13
Second Newspaper Ad Name
Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-10-20
Employer Website From Date
2019-10-03
Employer Website To Date
2019-11-05
Professional Organization Ad From Date
2020-01-01 08:35:44
Professional Organization Advertisement To Date
2020-01-01 08:35:44
Job Search Website From Date
2019-10-13
Job Search Website To Date
2019-10-27
Employee Referral Program From Date
2020-01-01 08:35:44
Employee Referral Program To Date
2020-01-01 08:35:44
Local Ethnic Paper From Date
2019-10-16
Local Ethnic Paper To Date
2019-10-16
Radio/TV Ad From Date
2020-01-01 08:35:44
Radio/TV Ad To Date
2020-01-01 08:35:44
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
ELECTRICAL ELECTRONIC ENGINEERING
Foreign Worker Years of Education Completed
2011
Foreign Worker Institution of Education
THE CALIFORNIA STATE UNIVERSITY, SACRAMENTO
Foreign Worker Education Institution Address 1
6000 J STREET
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
SACRAMENTO
Foreign Worker Education Institution State/Province
CA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
95819
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
LISA M TAYLOR
Preparer Title
ATTORNEY
Preparer Email
LISA.TAYLOR@ODNSS.COM
Employer Information Declaration Name
AMY BATESON
Employer Information Declaration Title
Deputy General Counsel