Fiscal Year

2023

Case Number

A-22041-10245

Case Status

Certified

Received Date

2022-02-15

Decision Date

2023-01-26

Refile

N

Original File Date

2023-01-01 08:10:59

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

COLMENA CAPITAL INC.

Employer Name Slug

colmena-capital-inc

Employer Address 1

1201 EAST WILMINGTON AVENUE

Employer Address 2

SUITE 115

Employer City

SALT LAKE CITY

Employer City Slug

salt-lake-city

Employer State

UTAH

Employer State Slug

utah

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

84106

Employer Phone

8019611121

Employer Number of Employees

16

Employer Year Commenced Business

2008

NAICS Code

531390

FW Ownership Interest

N

Employer Contact Name

Shannon K Stearman

Employer Contact Address 1

1201 East Wilmington Avenue

Employer Contact Address 2

Suite 115

Employer Contact City

Salt Lake City

Employer Contact State/Province

UTAH

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

84106

Employer Contact Phone

8019611121

Employer Contact Email

[email protected]

Agent Attorney Name

Roger Y Tsai

Agent Attorney Firm Name

Holland Hart LLP

Agent Attorney Phone

(303) 295-8171

Agent Attorney Address 1

555 17th Street

Agent Attorney Address 2

Suite 3200

Agent Attorney City

Denver

Agent Attorney State/Province

COLORADO

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

80202

Agent Attorney Email

[email protected]

PW Track Number

P10021120277436

PW SOC Code

13-2011

PW SOC Title

Accountants

PW Skill Level

Level III

PW Wage

70533.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-10-14

PW Expiration Date

2022-06-30

Wage Offer From

75190.08

Wage Offer To

0.00

Average Salary

75190.08

Wage Unit of Pay

Year

Worksite Address 1

1201 East Wilmington Avenue

Worksite Address 2

Suite 115

Worksite City

Salt Lake City

Worksite City Slug

salt-lake-city

Worksite State

UTAH

Worksite Postal Code

84106

Job Title

Senior Accountant

Job Title Slug

senior-accountant

Minimum Education

Master's

Major Field of Study

Accounting, Finance or Real Estate Finance

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Accounting, Finance, or Real Estate Finance

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Minimum Qualificationsbr br Experience in the real estate, financial services, or construction industry, including demonstrated ability to review and interpret financial provisions of leases and contracts, and operating agreements.br Experience with United States Generally Accepted Accounting Principles US GAAP.br Experience preparing financial statements for tax preparation.br Experience modeling various equity structures and waterfalls.br Experience with pivot tables in Microsoft Excel, VLOOKUP functions, scenario analysis tools, and sensitivity analysis.br Experience in investor relations including calculating returns and distributions and communicating this information to investors.br Experience in construction loan draw accounting and submitting bank draws.br Must be willing to work nights and weekends, when necessary.br br From H.12 Business Necessity Statementbr H.12. Colmena Capital has a business necessity to hire Senior Accountants with Masters degrees and three years of experience or Bachelors degrees and five years of postdegree progressive experience. The Senior Accountant must have the relevant education required in addition to a high level or prior experience and knowledge in real estate, financial services, or the construction industry, including demonstrated ability to review and interpret financial provisions of leases and contracts, and operating agreements. The Senior Accountant is not only expected to have advanced experience preparing complex financial statements for tax preparation, but they also must have experience working with several of the following technologies and tools Equity Structure Modeling, Waterfalls, Microsoft Excel Pivot Tabels, VLOOKUP functions, among others. This would not be possible hiring a person without at least a Masters degree and 3 years or experience or a Bachelors degree and five years of experience.br br Company Profilebr Colmena Capital is a real estate development and investment company. Since its inception in 2008, Colmena Capital has experienced outstanding growth and has developed, codeveloped and invested in real estate projects that represent a portfolio value of more than 1.6 Billion exceeding six million square feet and 12,000 apartment units. The managing partners of Colmena Capital have more than 65 combined years of real estate experience, including development, acquisition, management, tenant representation, and disposition. Colmena Capital has successfully developed, owned, and managed properties in multiple real estate classes, including multifamily apartments, commercial office, student housing, research parks, retail, hotel, industrial warehouses, and mixeduse properties.

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-11-01

SWA Job Order End Date

2021-12-06

Sunday Edition Newspaper

Y

First Newspaper Name

Salt Lake Tribune

First Advertisement Start Date

2021-11-07

Second Newspaper Ad Name

Salt Lake Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-11-14

Employer Website From Date

2021-11-01

Employer Website To Date

2021-12-06

Professional Organization Ad From Date

2023-01-01 08:10:59

Professional Organization Advertisement To Date

2023-01-01 08:10:59

Job Search Website From Date

2023-01-01 08:10:59

Job Search Website To Date

2023-01-01 08:10:59

Employee Referral Program From Date

2023-01-01 08:10:59

Employee Referral Program To Date

2023-01-01 08:10:59

Local Ethnic Paper From Date

2021-11-11

Local Ethnic Paper To Date

2021-11-11

Radio/TV Ad From Date

2021-11-10

Radio/TV Ad To Date

2021-11-10

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

ACCOUNTING

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

THE UNIVERSITY OF UTAH

Foreign Worker Education Institution Address 1

201 PRESIDENTS CIR

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SALT LAKE CITY

Foreign Worker Education Institution State/Province

UT

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

84112

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Roger Y Tsai

Preparer Title

Attorney

Preparer Email

[email protected]

Employer Information Declaration Name

Shannon K Stearman

Employer Information Declaration Title

VP of Operations