Job Requirement Detail
Company : Optghar
Req/job Title : Data Analytics
Job Ref No : 5905
Post Date : 02/15/2019
Country : USA
Job State/Province : California
Job City : Poway
PrimarySkill : BUSINESS INTELLIGENCE OR REPORTING TOOLS Jobs
Experience : 0 - 5
OtherSkill : SQL
Subject : Entry Level Data Analytics Job
Description :

Responsibilities:

·              Help write and optimize in-application SQL statements.

·              Ensure performance, security, and availability of databases.

·              Prepare documentations and specifications.

·              Handle common database procedures such as upgrade, backup, recovery, migration, etc.

·              Write TSQL scripts and objects such as stored procedures, user-defined functions, views, indexes per business requirements.

·              Create ETL SSIS packages to migrate data from OLTP sources to OLAP destinations through available tasks and transformations in SSIS.

·              Design and create user interactive reports in SSRS, Power BI and Tableau.

·              Profile server resource usage, and optimize and tweak as necessary.

·              Collaborate with other team members and stakeholders.

Benefits:

·         Visa Sponsorship

·         Travel Expenses

·         Relocation Assistance

·         Project Guarantee

 

Qualifications:

·         BS or MS of degree in Computer Science, Information Technology, Engineering or related field is required

·         Proficiency with SQL and its variation among popular databases

·         Skilled at optimizing large complicated SQL statements

·         Capable of configuring popular database engines and orchestrating clusters as necessary

·         Ability to plan resource requirements from high level specifications

·         Good communication skills