Datawarehouse Architect

  • location: Quincy, MA
  • type: Temp to Perm
  • salary: $70 - $75 per hour

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.


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


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


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


Bachelors degree or higher in Computer Science or related field.

get jobs in your inbox.

sign up

related jobs

    Security Architect

  • location: Boston, MA
  • job type: Contract
  • salary: $85 - $90 per hour
  • date posted: 5/3/2018