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.