13 days old
2018-04-122018-05-10

Data warehouse Solution Architect

Quincy, MA 02171
  • Job Code
    614242
  • Payrate
    $60 To $70

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.

Categories

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:

Data warehouse Solution Architect

Randstad Technologies
Quincy, MA 02171

Share this job

Data warehouse Solution Architect

Randstad Technologies
Quincy, MA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast