23 days old

Datawarehouse Architect

Quincy, MA 02171
  • Job Code
  • Payrate
    $70 To $75

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.


Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Datawarehouse Architect

Randstad Technologies
Quincy, MA 02171

Share this job

Datawarehouse Architect

Randstad Technologies
Quincy, MA

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
th -
Overall Rating: /199
Median Salary:

Work Environment
Powered ByCareerCast