BI Solution Architect

E*Pro Inc; Framingham (MA); On-site; USD 68,880 - 82,656; Full time

Job summary

A technology consulting firm in Framingham, MA, is seeking a BI Solution Architect to join their team. The successful candidate will have over 9 years of experience in data modeling and architecture, preferably with Teradata. This role requires strong leadership skills and the ability to work collaboratively with various teams including Business Intelligence and Data Integration. The position is full-time and offers a competitive hourly rate based on experience. Excellent communication skills are essential.

Qualifications

• 9+ years of experience in Data modeling and Data Architecture.
• Ability to lead projects during the implementation and deployment phases.
• Experience with Teradata and load utilities.

Responsibilities

• Design and develop data load processes.
• Optimize queries and load processes.
• Collaborate with BI development teams efficiently.

Skills

Data modeling and Data Architecture

Teradata physical database design

Load processes using BETEQ scripts

Expertise in ELT based data transformation

SQL writing efficiency with Teradata best practices

Developing and implementing Enterprise Data Warehousing

Excellent communication skills

Job description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com.

Job Description

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

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 & mitigate 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)
• 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

Additional Information

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

Duration: 9 months

Start Date: 3/31/2015

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

Job Location

Farmingham, MA