Case Details

Case info Company Info HR Info Attorney Position Info Employee Info
Case info
  • Data Publish Year :2022
  • Case Number:A-22199-90355
  • Case Status:Withdrawn
  • Received Date:2022-07-18
  • Decision Date:2022-07-31
  • Refile:N
  • Original File Date:
  • Previous State Work Force Agency (SWA) Case Number Stete:
  • Schedule A or a Sheepherder Occupation :N
Company Info
  • 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 :
  • NAICS Code:522291
  • Foreign Worker Ownership & Interest:N
HR Info
Attorney
Position Info
  • 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
  • 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:Y
  • 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