Randstad Data warehouse Solution Architect in Quincy, Massachusetts

Data warehouse Solution Architect

job details:

  • location:Quincy, MA

  • salary:$60 - $70 per hour

  • date posted:Thursday, April 12, 2018

  • job type:Contract

  • industry:Information Technology

  • reference:614242

job description

The Data warehouse Solution Architect is a senior staff member with knowledge and experience

sufficient to qualify them for overall accountability for the DW effort. Their role is to ensure that

functional design and implementations are consistent with the current and that future state. DW

solution architects should be able to get in front of the customers, translate their business

problems into practical solutions. They should also be able to help the clients with strategic

services like feasibility study, writing estimates, data governance and organizational issues.

Other responsibilities include designing and developing Extract Transformation and Load (ETL)

solutions on multi terabyte databases, mentoring ETL developers and resolving technical issues.

The role also requires a good understanding of ETL/ELT and Business Intelligence toolsets to

ensure database design meets reporting needs. Strong communication skills with an ability to

help business define requirements are also essential to this role.

Responsibilities

? Design, develop and implement Business Intelligence solutions that align with the

objectives of the company.

? Translate detailed business requirements into optimal database and ETL solutions.

? Extract, Transform and Load (ETL) design and development on multi terabyte database

environment.

? Define and deliver consistent ETL standards, methodologies, guidelines & techniques.

? Diagnose complex problems, including performance issues, and driving to resolution.

? Collaborate with Business Analysts to develop coordinated plans to meet business

requirements.

? Assist business analysts and end users across all functional areas in identifying long-term,

strategic data needs for the enterprise, defining how the data is related to the business

processes and developing a conceptual and functional model of the data

? Develop a strong understanding of health care data.

? Assist in evaluating new technologies for future state of DW.

Required Technical Skills

? Minimum 8 years of industry experience in data warehouse environment.

? Minimum 5 years of experience in architecture and ETL design using tools Informatica,

Oracle Data Integrator (ODI) or IBM Datastage.

? Minimum 5 years of experience with data warehouse development on a major RDBMS

(Oracle, DB2, SQL server).

? At least 3 years hands on Oracle Data Integrator (ODI) development experience required.

? Minimum of 2 years development on Netezza Data warehouse appliance.

? Experience in creating technical design and implementing ELT/ETL solution for multi-

terabyte Data Warehouse.

? Extensive experience with SQL required including SQL query optimization.

? Experience mentoring development team members.

? Excellent verbal and written communication

Education

? Bachelors degree or higher in Computer Science or related field.