Reference # 19-00467 Title Data Warehouse Consultant
Location Phoenix, ARIZONA
Position Type Contract
Experience Level Contract
Start Date / End Date 29-07-2019 --- 29-01-2020
Description
Role and Responsibilities:
" Should work with multiple business groups to gather business requirements on analytics.
" Should work with DBA's and data architects to select correct data sources, follow established data integration standards and develop enterprise class data models, data transformation, data integration, and data warehouse/datamart solutions.
" Should develop accurate documentations on solution architecture and components.
" Should be able to provide production support on weekdays and occasionally on weekends.

Qualifications and Education Requirements
" Bachelor's Degree preferred.

Required Skills & Experience:
" Ability to interpret, analyze and implement business analytics requirements accurately.
" Advanced data modeling in data warehouse and datamarts.
" Advanced SQL skills, and ability to design and develop physical data model, optimal data structures, and data procedures on Microsoft SQL Server.
" Should independently work on tasks like database backup/restore, database security, and SQL Jobs setup.
" Must have strong background on data transformation and integration routines using Microsoft SSIS, and Stored Procedures.
" Ability to develop, maintain and administer reports on Microsoft SSRS
" Ability to troubleshoot and resolve issues on data integration, data warehouse/datamart and
" reports.

Preferred Skills:
" Python programming experience
" General understanding on web tier concepts like http/https, query string, and REST API.
" Certifications on Microsoft SQL Data warehouse