FREEDOM FINANCIAL NETWORK, LLC

Business Intelligence/Data Engineer (PERM)

A-22209-96151 H-1B 2023 Certified
Salary

$86,632

Visa Type

H-1B

Job Title

Business Intelligence/Data Engineer (PERM)

Employee's Citizenship

INDIA

Graduate School

ARIZONA STATE UNIVERSITY

Case info

9 fields
Data Publish Year 2023
Case Number A-22209-96151
Case Status Certified
Received Date 2022-07-31
Decision Date 2023-04-24
Refile N
Original File Date -
Previous State Work Force Agency (SWA) Case Number Stete -
Schedule A or a Sheepherder Occupation N

Company Info

14 fields
Employer Name FREEDOM FINANCIAL NETWORK, LLC
Employer Address_Line 1 1875 S. GRANT STREET
Employer Address_Line 2 #400
Employer City SAN MATEO
State -
Employer State/ Province CALIFORNIA
Employer Country UNITED STATES OF AMERICA
Employer Postal Code 94402
Employer Phone No. 650-393-6400
Employer Phone Extent No. -
Total Number of Employees 2000
Employer Year of Commenced 2003
NAICS Code 522291
Foreign Worker Ownership & Interest N

HR Info

9 fields
Employer Contact Name Johanna Marroig
Employer Contact Address Line1 2114 South Freedom Way
Employer Contact Address Line2 Rio 1
Employer Contact City Tempe
Employer Contact State/ Provice ARIZONA
Employer Contact Country UNITED STATES OF AMERICA
Employer Contact Post Code 85281
Employer Contact Phone 602.732.3672
Employer Contact Email jmarroig@freedomfinancialnetwork.com

Attorney

11 fields
Agent/ Attorney Name Eric W Rathhaus
Agent/ Attorney Firm Name Law Office of Eric Rathhaus
Agent/ Attorney Phone 4155770920
Agent/ Attorney Phone Ext. -
Agent/ Attorney Address Line 1 484 Lake Park Avenue
Agent/ Attorney Address Line 2 No 50
Agent/ Attorney City Oakland
Agent/ Attorney State/ Province CALIFORNIA
Agent/ Attorney Country UNITED STATES OF AMERICA
Agent/ Attorney Postal Code 94610
Agent/ Attorney Email eric@ewrlaw.com

Position Info

89 fields
Prevailing Wage Track Number P10021063120860
Prevailing Wage SOC Code 15-1132
Prevailing Wage SOC Title Software Developers, Applications
Prevailing Wage Skill Level Level II
Prevailing Wage 86632
Prevailing Wage Unit of Pay Year
Prevailing Wage Source OES
Prevailing Wage Other Source -
Prevailing Wage Determination Date 2021-07-29
Prevailing Wage Expiration Date 2022-06-30
Wage Offer From 87000
Wage Offer To 125000
Wage Offer Unit of Pay Year
Workstie Address Line 1 2114 S Freedom Way
Worksite Address Line 2 Rio 1
Worksite City Tempe
Worksite State ARIZONA
Worksite Postal Code 85281
Job Title Business Intelligence/Data Engineer (PERM)
Minimum Education Master's
Other Degree/ Diploma -
Major Field of Study Bus. Anal., CS, CE, EE, or related data engineering field
Required Training N
Required Training Month -
Required Field of Training -
Required Experience Y
Required Expreience Months 24
Accept Alternate Field of Study N
Accept Alternate Major -
Alternate Combination of Education/ Experience N
Required Alternate Level of Education -
Other Alternate Level of Education -
Acceptable Years of Experience -
Accept Foreign Educationa Y
Acceptable Alternate Occupation Y
Acceptable Alternate Occupation Month 24
Accept Alternate Job Title job offered or related data engineering role
Normal Requirements of Job Opportunity Y
Required Foreign Language N
Specific Skills EXPERIENCE MUST INCLUDE 1. 2 years of experience developing and maintaining endtoend business Intelligence platforms, including replication of data, transformation of data, modeling, and presetting data in a visualization tool; 2. 2 years of experience in building and enhancing data warehouses; 3. 2 years of experience creating data models using snowflake schema and star schema with Microsoft SQL server Analysis services, ER Studio, or similar tool; 4. 2 years of experience creating reports such as drill down, drill through and sub reports using reporting tools like Tableau, Looker, SQL Server, Reporting Services, or Business Object; 5. 2 years of experience developing and supporting tabular and multidimensional data cubes; 6. 2 years of experience creating objects, stored procedures, Functions, performance optimization using Microsoft SQL Server; 7. 2 years of experience using SQL server integration services to integrate pulled data from different sources like MySQL, Salesforce, Excel Files into a SQL serverGoogle BigQuery destination; 8. 2 years of experience creating supporting data warehouse and reports using SQL Server, SQL Server Analysis Services, and SQL Server Integration Services; 9. 2 years of experience in translating business questions to technical specifications 10. 2 years of experience of active participation in project scrums and discussions with users, team lead, DBAs and technical manager to fully understand the requirements of a BI system which is later used by developers in the team to design BI software solutions; 11. 2 years of experience building data warehouses and publishing models using MS SQL DB, Congnos, or Google Big Query.
Combination Occupation N
Offered to Applied Foreign Worker Y
ForeignWorker Live on Premises N
Live in Domestic Service Worker N
Employment Contract -
Professional Occupation Y
College/ University Teacher N
Competitive Process -
Basic Recruitment Process -
Teacher Select Date -
Teacher Publish Journal Name -
Additional Recruitment Information -
Job Oder Start Date 2022-02-03
Job Oder End Date 2022-03-31
Sunday Edition Newspaper Y
First Newspaper Name Arizona Republic
First Advertisement Start Date 2022-02-06
Second Newspaper Name Arizona Republic
Second Advertisement Type Newspaper
Second Ad Start Date 2022-02-13
Job Fair From Date -
Job Fair to Date -
On Campus Recruiting from Date -
On Campus Recruiting to Date -
Employer Website from Date -
Employer Website to Date -
Pro. Org. Ad from Date -
Pro.Org. Ad to Date -
Job Search Website from Date 2022-02-04
Job Search Website to Date 2022-02-09
Private Employment Firm from Date -
Pricate Employment Firm to Date -
Employee Referral Program from Date -
Employee Referral Program to Date -
Campus Placement from Date 2022-02-04
Campus Placement to Date 2022-02-11
Local Ethnic Newspaper from Date 2022-02-17
Local Ethnic Newspaper to Date 2022-02-23
Radio/TV Ad from Date -
Radio/TV Ad to Date -
Employer Received the Payment N
Payment Details -
Bargaining Representative Notified N/A
Posted Notice at Worksite Y
Layoff in Past Six Months N
US Worker Considered -
Country of Citizenship INDIA
Foreign Worker Birth Country INDIA
Class of Admission H-1B

Employee Info

24 fields
Foreign Worker Education Master's
Foreign Worker Education Other -
Foreign Worker Major BUSINESS ANALYTICS
Year of Compelted Education 2016
Foreign Worker Istitution of Eduation ARIZONA STATE UNIVERSITY
Foreign Worker Education Instution Address Line 1 W. P. CAREY SCHOOL OF BUSINESS, E LEMON ST
Foreign Worker Education Institution Address Line 2 -
Foreign Worker Education Institution City TEMPE
Foreign Worker Educatution Institution State AZ
Foreign Worker Education Institution Country UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code 85287
Foreign Worker Training Completion N/A
Foreign Worker Required Experience Y
Foreign Worker Alternate Education and Experience N/A
Foreign Worker Alternate Occupation Experience Y
Foreign Worker Experience with Employer N
Foreign Worker Employer Pay for Education N
Foreign Worker Currently Employed N
Employer Completed Application N
Preparer Name Eric W Rathhaus
Preparer Title Attorney
Preparer Email eric@ewrlaw.com
Employer Information Declaration Name Khalif Nuriddin
Employer Declaration Title HR Coordinator