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.
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.
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.
Must have a criminal background check
Must have a conviction check:
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.
Administrative and Professional Faculty
If restricted or temporary, enter end date:
Exempt: Not eligible for overtime
Academic Year or Calendar Year:
If part time, enter Percent Time:
Commensurate with Experience
Business Intelligence Services
Location, if not Blacksburg:
M-F 8-5 PM
Job Posting Date:
Review Begin Date:
Job Close Date:
Restricted to university employees only?
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