Data Analyst

Company Description

VUI since 2004 has been helping clients improve their business, environmental and social performance. We do this by applying innovative processes, market intelligence and fresh thinking.

Job Description

Title: Data Analyst 

Location: Cincinnati OH

Type: Fulltime// Permanent//Onsite

Compensation: Base Salary + Benefits + relocation expenses (if required)

Interview Process: Phone and Skype Hire

Description:

 ESSENTIAL DUTIES & RESPONSIBILITIES 

• Gathering Requirements and design of technical specification documents.   

• Identify Use cases from requirements and write Use Case Specifications

• Create Mapping documents, ETL technical specifications and various documents related to data migration. 

• Write complex SQL Queries to test the Datastage ETL process   

• Ensuring project delivery on committed date 

• Reviewing designs with the rest of the project team as appropriate 

• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement

• 

TECHNICAL FUNCTIONAL SKILLS:

• 6+ years of experience in System Analysis, Design, Development, and implementation. 

• MUST have Good SQL knowledge to do data analysis and must have Data Modeling/Data wearhouse/Datamart design knowledge. Having ETL (Datastage preferable) knowledge is plus. 

• Experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, 

• Cursors and other database objects using SQL, PL/SQL. 

• Experience in creating DDL, DML and Transaction queries in SQL. 

• Experience in full life-cycle database including data architecture, logical and physical design, data modeling, and implementation. 

• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access. 

• Experience in design of Data Warehouse/Data Mart, Star Schema, 

Snowflake, Erwin & Slow changing dimensions. 

• Familiar with Data warehousing tools.

• Used ETL tools as Datastage. 

• Experience in Unit Testing, System Testing and User Acceptance Testing, creating test cases using Mercury Testing Tools. 

• Excellent verbal and written communication skills.

GENERIC MANAGERIAL SKILLS:

• Work as team player 

• Excellent communication and interpersonal skills

Qualifications

Data Analyst

Additional Information

If available please contact me for more details at 856-842-1988 ext-112