Urgent opening of BI Analytics Data Architect in Denver, CO Job ID: SS_CO_0412

 

Hi, 

 

Here is an Urgent Direct Client Requirement from Sourcechip Inc.

  

Please reply me with some following details:-

 

Resume word format:

Complete Name:

Availability:

Rate:

Present Location :

Contact number :

Relocation (Y/N):

Email ID:

Visa Status:

 

Job Title:             BI Analytics Data Architect                              

Location:             Denver, CO

Duration:             6 months+

 

SUMMARY: The BI Data Architect is responsible for developing OLTP and dimensional data models to support operational and Business Intelligence systems. This individual will be part of a dynamic team that builds and implements Business Intelligence solutions that serve as key decision support systems for the leadership of the company.  A key for success in this role is a unique blend of technical skills, business knowledge, and strong interpersonal communication skills. This role provides the opportunity to work with a global view of the entire business.

 

ROLE AND RESPONSIBILITIES

• Data modeling and architecture experience implementing proper data structures for a reporting solution from enterprise OLTP systems
• Designs logical data models for small databases and applications as well as very large databases (VLDB)
• Understands CRM integration practices, risks and benefits
• Uses and understands BI reporting tools and ETL tools.
• Dimensional modeling and architecture experience implementing proper data structures for a reporting solution from an enterprise data warehouse a must using tools such as Oracle, Microsoft, and/or other BI tools
• Maintain and version control data modeling repositories
• Responsible for detail Data analysis and translates Business requirements into logical & physical data model.
• Works closely with the DBA to help insure the physical design meets the functional and performance requirements of the application.
• Experience re-engineering physical data structures, and recommends efficiencies as it relates to data storage and retrieval
• Full understanding and experience in implementing a data warehouse is a plus
• Full life cycle experience in Data Warehousing, Data Modeling, Data Integration, and Master Data Management
• Leads complex technical data warehouse discussions on modeling, integration, and overall technology solutions and design
• Ability to create robust, scalable, sustainable data architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources
• Excellent communication (written and verbal). 

 

QUALIFICATIONS AND REQUIREMENTS

• 2-3 years - Data Architecture / Modeling experience; delivering both logical models and physical designs with extensive experience with translating business needs into data requirements
• A degree in Computer Science, a related discipline, equivalent work experience of 10+ years overall IT or the equivalent combination of education, training and experience from which comparable skills can be acquired
• At least 5-7 years  experience with data modeling tools like ERwin, ER Studio, PowerDesigner, Oracle Designer and/or other modeling tools
• Experience with normalized OLTP,MDM  and DW Dimensional modeling techniques, Star & Snowflake schemas, modeling slowly changing dimensions and role playing dimensions, dimensional hierarchies, and data classification
• Experience with maintaining data dictionary and managing technical, process, and business metadata
• Experience with MPP platforms and column-store databases.
• Experience with NoSQL platforms that take on semi-structured and unstructured information.
• Experience with Hadoop/MapReduce/SQL-MR.

 

Thanks & Regards
 
Gyan
Sr.Technical Recruiter
Direct Number: 732-917-4861
SourceChip, Inc | www.sourcechip.net

A Minority Certified and Women Owned Certified Enterprise, (MBE & WBE)
______________________________________________________________________________________________________________________________________
The information in this message may be privileged, intended only for the use of the named recipient. If you received this communication in error, please immediately notify us by return e-mail and destroy the original and any copies. Any tax advice contained in this communication is not intended and cannot be used for the purpose of avoiding tax-related penalties.