Fiscal Year

2022

Case Number

A-21250-40483

Case Status

Certified-Expired

Received Date

2021-09-24

Decision Date

2022-03-25

Refile

N

Original File Date

2022-01-01 11:09:52

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

OPTUMCARE MANAGEMENT, LLC

Employer Name Slug

optumcare-management-llc

Employer Address 1

9900 BREN ROAD EASTR120

Employer Address 2

Employer City

MINNETONKA

Employer City Slug

minnetonka

Employer State

MINNESOTA

Employer State Slug

minnesota

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

55343

Employer Phone

888-445-8745

Employer Number of Employees

320000

Employer Year Commenced Business

2019

NAICS Code

524114

FW Ownership Interest

N

Employer Contact Name

Jennifer Priebe

Employer Contact Address 1

9900 Bren Road East

Employer Contact Address 2

Employer Contact City

Minnetonka

Employer Contact State/Province

MINNESOTA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

55343

Employer Contact Phone

952-351-6302

Employer Contact Email

jennifer_priebe@uhg.com

Agent Attorney Name

Courtney Lewis

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

(469) 290-9510

Agent Attorney Address 1

2400 N Glenville Drive, Building A

Agent Attorney Address 2

,Ste 100

Agent Attorney City

Richardson

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

75082

Agent Attorney Email

clewis@BAL.com

PW Track Number

P10021013009832

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level II

PW Wage

90418.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-06-29

PW Expiration Date

2021-09-27

Wage Offer From

90418.00

Wage Offer To

140000.00

Average Salary

115209.00

Wage Unit of Pay

Year

Worksite Address 1

717 17th Street

Worksite Address 2

Worksite City

Denver

Worksite City Slug

denver

Worksite State

COLORADO

Worksite Postal Code

80202

Job Title

Data Analyst

Job Title Slug

data-analyst

Minimum Education

Bachelor's

Major Field of Study

See H.14

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

None

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

See H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

BACHELORS DEGREE OR FOREIGN EQUIVALENT IN INFORMATION TECHNOLOGY, INFORMATION MANAGEMENT, COMPUTER SCIENCE, OR A RELATED FIELD AND THREE YEARS OF EXPERIENCE INVOLVING THE FOLLOWING SQL; DOCUMENTING DETAILED REQUIREMENTS, DESIGN DOCUMENTS, AND WORKFLOWS IN SUPPORT OF BI OR SOPHISTICATED REPORTING CAPABILITIES; EXTRACTING AND MANIPULATING DATA FROM MULTIPLE DATA SOURCES USING PLSQL; SOFTWARE DEVELOPMENT LIFECYCLE SDLC METHODOLOGIES INCLUDING AGILE; HEALTHCARE DATA INCLUDING MEMBERSHIP ELIGIBILITY, ENCOUNTERS, PHARMACY, PROVIDER, AND CLAIMS DATA; NAVIGATING DATA TO PERFORM A WIDE RANGE OF ANALYSES; DESIGNING SCALABLE SOLUTION AND CREATING POST PRODUCTION VALIDATION SCRIPTS AND MAINTAINING SCHEMA DOCUMENTATION; MICROSOFT SQL SERVER MANAGEMENT STUDIO; INFORMATICA ANALYST TOOL TO PERFORM DATA PROFILING TO FIND THE CONTENT, QUALITY, STRUCTURE OF DATA SOURCES, DEFINE MANAGE RULES TO VERIFY DATA CONFORMANCE; CREATE ENTITYRELATIONSHIP DIAGRAM DATA FLOWS TO BUILD LOGICAL AND SWIM LANE BUSINESS PROCESSES; AND WORKING WITH DATA MODELS.br br OR FIVE YEARS OF EXPERIENCE INVOLVING THE FOLLOWING SQL; DOCUMENTING DETAILED REQUIREMENTS, DESIGN DOCUMENTS, AND WORKFLOWS Ei SUPPORT OF BI OR SOPHISTICATED REPORTING CAPABILITIES; EXTRACTING AND MANIPULATING DATA FROM MULTIPLE DATA SOURCES USING PLSQL; SOFTWARE DEVELOPMENT LIFECYCLE SDLC METHODOLOGIES INCLUDING AGILE; HEALTHCARE DATA INCLUDING MEMBERSHIP ELIGIBILITY, ENCOUNTERS. PHARMACY, PROVIDER, AND CLAIMS DATA; NAVIGATING DATA TO PERFORM A WIDE RANGE OF ANALYSES; DESIGNING SCALABLE SOLUTION AND CREATING POST PRODUCTION VALIDATION SCRIPTS AND MAINTAINING SCHEMA DOCUMENTATION; MICROSOFT SQL SERVER MANAGEMENT STUDIO; INFORMATICA ANALYST TOOL TO PERFORM DATA PROFILING TO FIND THE CONTENT, QUALITY, STRUCTURE OF DATA SOURCES, DEFINE MANAGE RULES TO VERIFY DATA CONFORMANCE; CREATE ENTITYRELATIONSHIP DIAGRAM DATA FLOWS TO BUILD LOGICAL AND SWIM LANE BUSINESS PROCESSES; AND WORKING WITH DATA MODELS.br br Any suitable combination of education, training, or experience is acceptable.

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

SWA Job Order End Date

2021-06-14

Sunday Edition Newspaper

Y

First Newspaper Name

Denver Business Journal

First Advertisement Start Date

2021-07-11

Second Newspaper Ad Name

Denver Business Journal

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-18

Employer Website From Date

2022-01-01 11:09:52

Employer Website To Date

2022-01-01 11:09:52

Professional Organization Ad From Date

2021-07-09

Professional Organization Advertisement To Date

2021-07-16

Job Search Website From Date

2021-07-09

Job Search Website To Date

2021-07-16

Employee Referral Program From Date

2022-01-01 11:09:52

Employee Referral Program To Date

2022-01-01 11:09:52

Local Ethnic Paper From Date

2021-07-16

Local Ethnic Paper To Date

2021-07-22

Radio/TV Ad From Date

2022-01-01 11:09:52

Radio/TV Ad To Date

2022-01-01 11:09:52

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

None

Foreign Worker Information: Major

Foreign Worker Years of Education Completed

Foreign Worker Institution of Education

Foreign Worker Education Institution Address 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

Foreign Worker Education Institution Postal Code

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Courtney Lewis

Preparer Title

Associate Attorney

Preparer Email

clewis@BAL.com

Employer Information Declaration Name

McDonnellPriebe CiaranJennifer

Employer Information Declaration Title

Immigration Team Leaders