Senior Data Warehouse Architect
Virginia Tech - Blacksburg, VA
Responsible for designing data warehouse models, tables, views and developing and implementing data migration processes. Designs and develops data warehouse reports, when applicable. Maintains implemented data marts by completing service requests, and fixing any problems that occur with nightly runs. Evaluates tools for data warehouse management and data access. Works with lead data warehouse architect to design for enterprise integration. Works with DBA to design tables effectively to support data access. Works with Data Warehouse Project Coordinator and Liaison to model and standardize data, capture and manage metadata. Functions as lead Data Stage Administrator.

Required Qualifications:
Bachelor’s degree in CE, CS, or IS; significant experience with large scale database development, and procedural language; strong technical / analytical skills. Extensive experience in programming, debugging, development, and analysis of automated processes required. Demonstrated use of business analysis and requirements gathering skills required. Excellent communication and interpersonal skills required along with the ability to work effectively in a team environment.

Preferred Qualifications:
Experience with Oracle design and development; development experience with one or more of the following:

-Experience with data extraction, transformation, and loading processes;
-Experience with ETL tools such as IBM Infosphere DataStage.
-Experience with data warehouse and star schema design.
-Higher education experience.
-Experience with data modeling tools such as Visio
-Experience with Oracle Data Base Administration.
-Working knowledge of Unix / Linux.
-Experience developing Business Intelligence applications, reports and dashboards.

Employment Conditions:
Must have a criminal background check

Must have a conviction check:
Yes

Describe Other:

Employment Comments:

How to Apply for this Job:
For a complete listing of position qualifications, and to apply, please visit www.jobs.vt.edu, and search for position 115599. Review of applications will begin on 01/29/2013.

Employee Category:
Administrative and Professional Faculty

Appointment Type:
Regular

If restricted or temporary, enter end date:

FLSA Status:
Exempt: Not eligible for overtime

Faculty Rank:
Lecturer

Tenure Status:
Non-Tenure Track

Academic Year or Calendar Year:
Calendar Year

Percent Employment:
Full-time

If part time, enter Percent Time:

Pay Range:
Commensurate with Experience

Department:
Business Intelligence Services

Location:
Blacksburg

Location, if not Blacksburg:
AISB

Work Schedule:
M-F 8-5 PM

Job Posting Date:
12/21/2012

Review Begin Date:
01/29/2013

Job Close Date:

Restricted to university employees only?
No

Diversity Statement:
Virginia Tech has a strong commitment to the principle of diversity, and in that spirit seeks a broad spectrum of candidates including women, minorities, veterans, and people with disabilities. Individuals with disabilities desiring accommodations in the application process should notify the hiring department by the application deadline.

Virginia Tech - 14 months ago - save job - block
About this company
61 reviews