Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy, LLP
Agent/ Attorney Phone:2122302877
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:1400 BROADWAY
Agent/ Attorney Address Line 2:Floor 9
Agent/ Attorney City:New York
Agent/ Attorney State/ Province:NEW YORK
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:10018
Agent/ Attorney Email:jnieves@fragomen.com
Position Info
Prevailing Wage Track Number:P10021074145450
Prevailing Wage SOC Code :15-2041
Prevailing Wage SOC Title :Statisticians
Prevailing Wage Skill Level:Level I
Prevailing Wage:58906
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-08-12
Prevailing Wage Expiration Date :2022-06-30
Wage Offer From:120000
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:2608 SE J St.
Worksite Address Line 2:
Worksite City :Bentonville
Worksite State:ARKANSAS
Worksite Postal Code:72716
Job Title:Senior Manager II, Energy Services Texas Retail Energy
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Business, Finance, or related field
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :None
Other Alternate Level of Education:
Acceptable Years of Experience:6
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:48
Accept Alternate Job Title:Experience in utility operations, renewable energy, or related experience.
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Must have experience with Develop and finetune statistical models for load forecasting using parametric and nonparametric models such as KNearest Neighbors, multiple linear regressions, and other techniques; Improve forecast accuracy by analyzing factors, errors and fitness using data analysis libraries in Python and R; Develop and manage Microsoft SQL Server ETL packages Extract Transform and Load for data capture using SSIS; Perform data management activities on SQL server using SQL Server Data Tools and Management Studio; Design, build, and manage complex queries using SQL objects such as stored procedures, user functions, indexes, tables, and views; Design and migrate existing Excelbased reports to Data visualization tools using PowerBI and perform calculations using DAX scripts; Develop KPIs and create drilldown reports, dashboards using Microsoft PowerBI; Perform objectoriented programming to develop windows application using C# on .Net framework; Integrate discrete data sources from Vendor support platforms, databases, file shares using SSIS, API Webservices SOAP XML, Data Manager and custom programs developed in C#, Visual Basic Applications Excel macros, and Python; Create a road map and architecture to move the current process to CloudBased services Microsoft Azure. Analyze internal and external systems using internal Security Risk and Compliance Review tool to assess the impacts to architecture, data elements and security; and Manage Microsoft Azure and Office subscription tools to support users as well as data needs. Employer will accept any amount of experience with the required skills.br br Continuation of Section H.4. H.8 H.10 Minimum education and experience required Bachelors degree or the equivalent in Business, Finance, or related field plus 4 years of experience in utility operations, renewable energy, or related experience; OR 6 years of experience in utility operations, renewable energy, or related experience.
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:2021-10-01
Job Oder End Date:2021-11-01
Sunday Edition Newspaper:Y
First Newspaper Name:Arkansas Democrat Gazette
First Advertisement Start Date:2021-09-19
Second Newspaper Name:Arkansas Democrat Gazette
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-09-26
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-09-17
Employer Website to Date:2021-09-28
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-09-20
Job Search Website to Date:2021-09-27
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-09-21
Local Ethnic Newspaper to Date:2021-09-21
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:MARKETING
Year of Compelted Education:2017
Foreign Worker Istitution of Eduation:CLEMSON UNIVERSITY
Foreign Worker Education Instution Address Line 1:105 SIKES HALL
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:CLEMSON
Foreign Worker Educatution Institution State:SC
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:29634
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :N/A
Foreign Worker Alternate Education and Experience :N/A
