Data Warehouse Architect

12 to 15 years of experience in the field or in a related areaPlans, develops, tests, and documents computer programs (specifically in data warehouse ETL: Extraction, Transform and Load), applying knowledge of programming techniques and computer systems. 

Evaluates user request for new or modified application software to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. 

Consults with team members and users to identify current operating procedures and clarify objectives. Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development.

Work involves assisting in analyzing systems outlines to develop programs for computer applications,writing solution programs, documenting the methods and procedures used in program development, and testing and correcting programs. 

Works under limited supervision with considerable latitude for the use of initiative and independent judgment. Designs technical data models and specifications for accomplishing user requirements in the business intelligence sphere. Converts project specifications, using specialized software, into sequence of detailed instructions and logical steps applying knowledge of computer programming techniques and computer languages. 

Performs unit testing to detect syntax or logic errors. Replaces, deletes, or modifies codes to correct errors. Analyzes, reviews and alters program to increase operating efficiency or adapt to new requirements. Writes documentation to describe program development,logic, coding, and corrections.

Assists business analysts and users to solve problems. Recreates steps taken by user to locate source of problem and corrects programs to fix errors. 

May provide technical assistance to program users. Will monitor performance of program after implementation and use knowledge of database tuning to improve substandard performance. Specializes in developing programs for data warehouse/business intelligence applications.

The contractor will work with the business analysts, BI architect, and developers on the data warehouse team and on the source systems team(s).

The tools and technologies used for this work are specialized, and the contractor will have the responsibility to mentor and lead other team members in the proper use of these tools and technologies,including developing, recommending, and communicating their best practices.

Extremely high level of expertise (12 or more years) with Oracle, including PL/SQL and SQL, performance tuning, and DDL operationsRequired 12 YearsExtremely high level of expertise (12 or more years) in data modeling and/or data warehouse schema design Required 12 Years

Ability to analyze and evaluate user requirements and the characteristics of source system data

Required 10 YearsAdvanced knowledge of ETL (Extraction, Transformation and Load)Required 5 Years

Documentation skills to produce program component specifications, requirement specifications, test plans, and user documentation Required 5 Years

Oracle Warehouse Builder expertise Required 1 Years