Fiscal Year

2022

Case Number

A-21222-29625

Case Status

Withdrawn

Received Date

2021-09-29

Decision Date

2021-12-21

Refile

N

Original File Date

2022-01-01 10:39:20

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

FISCALNOTE

Employer Name Slug

fiscalnote

Employer Address 1

1201 PENNSYLVANIA AVE NW, 6TH FLOOR

Employer Address 2

Employer City

WASHINGTION

Employer City Slug

washingtion

Employer State

DISTRICT OF COLUMBIA

Employer State Slug

district-of-columbia

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

20004

Employer Phone

202-793-5300

Employer Number of Employees

515

Employer Year Commenced Business

2013

NAICS Code

511210

FW Ownership Interest

N

Employer Contact Name

Kaitlin M Hass

Employer Contact Address 1

1201 Pennsylvania Ave NW, 6th floor

Employer Contact Address 2

Employer Contact City

Washingtion

Employer Contact State/Province

DISTRICT OF COLUMBIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

20004

Employer Contact Phone

(202) 793-5300

Employer Contact Email

kaitlin.hass@fiscalnote.com

Agent Attorney Name

Wen Chen

Agent Attorney Firm Name

Azarmehr Law Group

Agent Attorney Phone

(512) 732-0055

Agent Attorney Address 1

2720 Bee Caves Road

Agent Attorney Address 2

Agent Attorney City

Austin

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

78746

Agent Attorney Email

wen@algvisas.com

PW Track Number

P10020352968289

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

134722.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-06-14

PW Expiration Date

2021-09-12

Wage Offer From

144200.00

Wage Offer To

0.00

Average Salary

144200.00

Wage Unit of Pay

Year

Worksite Address 1

1201 Pennsylvania Avenue NW

Worksite Address 2

6th Floor

Worksite City

Wanshington D.C.

Worksite City Slug

wanshington-dc

Worksite State

DISTRICT OF COLUMBIA

Worksite Postal Code

20004

Job Title

Senior Business Intelligence Developer

Job Title Slug

senior-business-intelligence-developer

Minimum Education

Bachelor's

Major Field of Study

See H14

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 H14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree in Computer Science, Software Engineering, Electrical Engineering, Computer Engineering, or a related field or the foreign equivalents;br 5 years with data engineering, including designing and building data warehouse and datamarts, and ETL and ELT pipelines for integration with internal systems to ingest data into data warehouses, including tools such as STITCH, DBT, and AIRFLOW;br 5 years of experience with business intelligence and analytics technology tools for reporting and analysis, including performing data manipulation, cleaning, and construction of dashboards, like LOOKER;br 5 years of experience with database administration experience with relational and nonrelational databases, including Query and table building with varieties of POSTRESSQL, SQLSERVER, and MYSQL;br 3 years of experience with software development and scripting experience with python and Javascript; andbr Any experience with management and use of cloud computing services, such as those in AWS, including REDSHIFT and LAMBDA.

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

2021-06-29

SWA Job Order End Date

2021-08-03

Sunday Edition Newspaper

Y

First Newspaper Name

The Washington Post

First Advertisement Start Date

2021-07-11

Second Newspaper Ad Name

The Washington Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-18

Employer Website From Date

2021-06-29

Employer Website To Date

2021-08-03

Professional Organization Ad From Date

2022-01-01 10:39:20

Professional Organization Advertisement To Date

2022-01-01 10:39:20

Job Search Website From Date

2021-06-29

Job Search Website To Date

2021-08-03

Employee Referral Program From Date

2022-01-01 10:39:20

Employee Referral Program To Date

2022-01-01 10:39:20

Local Ethnic Paper From Date

2022-01-01 10:39:20

Local Ethnic Paper To Date

2022-01-01 10:39:20

Radio/TV Ad From Date

2022-01-01 10:39:20

Radio/TV Ad To Date

2022-01-01 10:39:20

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2013

Foreign Worker Institution of Education

THE UNIVERSITY OF FLORIDA

Foreign Worker Education Institution Address 1

106 GRINTER HALL, 1523 UNION ROAD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

GAINESVILLE

Foreign Worker Education Institution State/Province

FL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

32611

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Wen Chen

Preparer Title

Associate Attorney

Preparer Email

wen@algvisas.com

Employer Information Declaration Name

Kaitlin M Hass

Employer Information Declaration Title

People Compliance Process Improvement Manager