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.