BI Solution Architect

Job Description

We are currently hiring for BI Solution Architect Fulltime position with our client.

#########NO THIRD PARTY SUBCONTRACTING for these positions#########

Job Title : BI Solution Architect

Location : Farmingham,MA

Job Type : Permanent Full Time

US Citizen/ Green Card Holder/EAD (GC) can apply for this Job

Required Skills:

• 9+ years of experience in the field of Data modeling and Data Architecture 

  Teradata based physical database design leveraging constructs such as Secondary/Join indexes, Statistics, Partitioned Primary Indexes.

• Design and develop load processes using BETEQ scripts & Teradata based load utilities (TPT, Fastload/Multiload) and queries with complex workloads and large transaction volumes.

• Expertise in ELT based data transformation to apply complex business rules to transform source data. 

• Identification and optimization of sub-optimal queries & load processes. 

• Adoption of features/best practices introduced in newer versions of Teradata. 

• Assist ETL & BI development teams in writing complex SQL in an efficient way leveraging Teradata best practices. 

• Ability to understand data and develop Subject matter expertise on complex applications. 

• Review logical and physical data models to support complex end user dashboard/reports and queries.

• Ability to drive and lead projects during the implementation, test and deploy phases proactively identify & mitigating technical issues. Ability to work in a matrix environment consisting of Solution, Business Intelligence, Data Integration & Quality Assurance teams and successfully collaborate to meet the project objectives 

• Developing and implementing Enterprise Data Warehousing (EDW), Data Warehouses (DW), Data Marts (DM), Decision Support Systems (DSS) and Operational Data Stores (ODS) etc..

• Developing and maintaining enterprise-wide data models, Logical Data Models (LDM), Physical Data Models (PDM)

• Excellent personal communication, leadership, and organizational skills 

• Retail related data warehousing experience a plus

• Excellent personal communication, leadership, and organizational skills 

• Retail related data warehousing experience a plus  

If you are interested, kindly respond with your updated word format resume with the following details.

Work Status: 

Best #:

Best Time to reach:

Expected Salary:

Availability to join:

Note: I choose to contact you either because your resume had been posted to one of the internet job sites, or you had previously submitted your resumes to E*Pro. I assumed that you are either looking for a new employment opportunity, or you are interested in investigating the current job market.

Thanks & Best regards,

Chandra kumar

E*Pro, Inc.,

Ph: 732-283-0499 X 272

www.eprocorp.com  

If you are not currently seeking employment, or if you would prefer I contact you at some later date, please indicate your date of availability so that I comply with your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices.

Qualifications

Additional Information

All your information will be kept confidential according to EEO guidelines.

Duration: 9 months

Interviews: 3/182015

Start Date: 3/31/2015

Rate : 50-60/hr on W2 - All Inclusive(Depending on experinece)