All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23005-82666
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23005-82666
Case Status
Certified-Expired
Received Date
2023-01-23
Decision Date
2024-02-26
Refile
N
Original File Date
2024-01-01 00:38:51
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
HUBSPOT, INC.
Employer Name Slug
hubspot-inc
Employer Address 1
2 CANAL PARK
Employer Address 2
Employer City
CAMBRIDGE
Employer City Slug
cambridge
Employer State
MASSACHUSETTS
Employer State Slug
massachusetts
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
2141
Employer Phone
8779290687
Employer Number of Employees
4500
Employer Year Commenced Business
2007
NAICS Code
511210
FW Ownership Interest
N
Employer Contact Name
Katie Rossi
Employer Contact Address 1
25 First Street
Employer Contact Address 2
Employer Contact City
Cambridge
Employer Contact State/Province
MASSACHUSETTS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
2141
Employer Contact Phone
8578295324
Employer Contact Email
krossi@hubspot.com
Agent Attorney Name
Christopher R Graff
Agent Attorney Firm Name
Clark Lau LLC
Agent Attorney Phone
6172994200
Agent Attorney Address 1
155 Federal Street
Agent Attorney Address 2
Suite 400
Agent Attorney City
Boston
Agent Attorney State/Province
MASSACHUSETTS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
2110
Agent Attorney Email
cgraff@clarklau.com
PW Track Number
P10022062949353
PW SOC Code
13-1082.00
PW SOC Title
Project Management Specialists
PW Skill Level
Level IV
PW Wage
128170.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-09-06
PW Expiration Date
2023-06-30
Wage Offer From
180000.00
Wage Offer To
270000.00
Average Salary
225000.00
Wage Unit of Pay
Year
Worksite Address 1
25 First Street
Worksite Address 2
Worksite City
Cambridge
Worksite City Slug
cambridge
Worksite State
MASSACHUSETTS
Worksite Postal Code
2141
Job Title
Director, Financial Operations
Job Title Slug
director-financial-operations
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Industrial Engineering, or a closely related 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
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
See H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Employer requires a Bachelors degree in Computer Science, Industrial Engineering, or a closely related quantitative field and at least five 5 years of progressively more responsible work experience in an occupation within the business analytics or data science fields.br br In addition, the successful candidate must have the followingbr br Demonstrated knowledge of data visualization tools like QlikView, Tableau, or Looker with interactive views, trends, and drilldowns to create digestible KPI dashboards gained through five 5 years of work experience.br Demonstrated ability analyzing data by combining multiple sources and using it to produce actionable business recommendations gained through five 5 years of work experience.br Demonstrated ability partnering with crossfunctional stakeholders to identify and translate business questions into analyses or data automation opportunities and lay the project roadmap for the team gained through three 3 years of work experience.br Demonstrated knowledge of advanced SQL techniques windows functions, JSON flattening, common table expressions, UDFs, etc. for data investigation, transformation, and analysis of the relevant data gained through five 5 years of work experience.br Demonstrated knowledge of software programming tools Python or R for analytics development gained through three 3 years of work experience.br Demonstrated ability working with data store and processing technologies such as MySQL, Redshift, S3, Athena, Snowflake, Presto, MapReduce, or Spark to operationalize, and model the datasets to facilitate user application gained through three 3 years of work experience.br Demonstrated ability with data science modelbuilding to develop regression, classification, and anomaly detection models while working with stakeholders to reviewvalidate model results gained through three 3 years of work experience.br br All years of experience may be gained concurrently.
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-10-26
SWA Job Order End Date
2022-11-30
Sunday Edition Newspaper
Y
First Newspaper Name
Boston Sunday Globe
First Advertisement Start Date
2022-11-06
Second Newspaper Ad Name
Boston Sunday Globe
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-11-13
Employer Website From Date
2024-01-01 00:38:51
Employer Website To Date
2024-01-01 00:38:51
Professional Organization Ad From Date
2024-01-01 00:38:51
Professional Organization Advertisement To Date
2024-01-01 00:38:51
Job Search Website From Date
2022-10-26
Job Search Website To Date
2022-11-30
Employee Referral Program From Date
2024-01-01 00:38:51
Employee Referral Program To Date
2024-01-01 00:38:51
Local Ethnic Paper From Date
2022-11-09
Local Ethnic Paper To Date
2022-11-09
Radio/TV Ad From Date
2024-01-01 00:38:51
Radio/TV Ad To Date
2024-01-01 00:38:51
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
INDUSTRIAL AND SYSTEMS ENGINEERING
Foreign Worker Years of Education Completed
2012
Foreign Worker Institution of Education
RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY
Foreign Worker Education Institution Address 1
57 US HIGHWAY 1
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
NEW BRUNSWICK
Foreign Worker Education Institution State/Province
NJ
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
8901
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Christopher R Graff
Preparer Title
Attorney
Preparer Email
cgraff@clarklau.com
Employer Information Declaration Name
Katie Rossi
Employer Information Declaration Title
Senior Mobility Immigration Specialist