Other Alternate Level of Education:3 years of university study
Acceptable Years of Experience:2
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:12
Accept Alternate Job Title:See H.14
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Minimum Requirements Requires a Bachelors degree or foreign equivalent in Business Administration, any STEM degree field, or a related field and one 1 year of related work experience in the job offered or in a related occupation. In the alternative, the employer will accept three 3 years of university study and two 2 years of related work experience. Candidate must also have one 1 year of related work experience involving each of the followingbr br Assessing the current state process and transforming the existing Business Intelligence solution to a digital, state of the art Business Intelligence solution using Enterprise Data Warehouse;br Strategizing, planning, designing, and implementing an Extract Transform Load ETL solution to modernize the reporting capabilities including designing ETL jobs to transform data using IBM DataStage, Capturing Change Data CDC, and Slowly Changing Dimensions SCD;br Establishing traceability and implementing a Business Intelligence solution to facilitate federal, management, and operational reporting;br Creating change requests, estimates, and tracking risks during product development life cycles utilizing JIRA and JAMA;br Designing and creating PowerBI and Tableau based Dashboards to facilitate daily operational reporting and construct dimensional data structures for reporting Data Warehouse to facilitate predefined Business Intelligence reporting and selfservice reporting;br Creating adhoc reports based on the ondemand needs of users using IBM Cognos Query Studio and SQL Reports;br Writing and validating SQL queries on reporting and transaction database tables utilizing Oracle SQL Developer;br Utilizing Data Integration and delivery, Data Warehousing, Requirements and Scope Management, Business Intelligence, ETL Design, and Dimensional Modeling to implement a BI solution to facilitate federal, management and operational reporting;br Designing, delivering, and monitoring operational dashboards leveraging data to highlight operational efficiency and weaknesses across Agile development sprints; andbr Leveraging MS product suite Office 365, SQL Server Integration Services, SQL Server Reporting Services, Power BI, Team Foundation Server for Product and Project Management to track risks issues during product development life cycles with ability to view client and case data, and instant access to mission critical data alerts and notifications for faster resolution of issues.br br Any suitable combination of education, training, or experience is acceptable.br br 80 travel required nationally.br Telecommuting permitted.
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-09-23
Job Oder End Date:2021-10-28
Sunday Edition Newspaper:Y
First Newspaper Name:Tennessean
First Advertisement Start Date:2021-09-26
Second Newspaper Name:Tennessean
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-10-03
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-09-22
Employer Website to Date:2021-12-02
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-09-23
Job Search Website to Date:2021-10-07
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-09-22
Employee Referral Program to Date:2021-10-13
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:
Local Ethnic Newspaper to Date:
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:TEXAS AM UNIVERSITY COMMERCE
Foreign Worker Education Instution Address Line 1:2200 CAMPBELL ST
Foreign Worker Education Institution Address Line 2:
