Administrates, Develops and modifies ETL solutions on Data Stage. Designs data modelsused for reporting and analytics, develops ETL processes for data, and utilizesBI tools to satisfy end user data needs. Implements small projects orcomponents or large projects. Ability to solve medium to complex problems.
Provides technical oversight for development andimplementation of database objects used for Data Warehousing and BusinessIntelligence solutions.
Administration of Data Stage environment
Has installed high availability configurations
Has led full cycle implementation on a DataStage project
Proficient and go-to resource for data movementand Oracle PL/SQL.
Provides technical leadership to tuning,monitoring, and performance tasks related to Data Warehousing functions.
Develops or modifies data models, ETL processes,and BI tool solutions.
Ensures appropriate documentation for alldevelopment and modification.
Ensures integrity and security of institutionaldata.
24 X7 On call responsibilities.
Business Intelligence Tools: Has successfully used thetool in situations of medium complexity. Occasionally needs assistance frominternal technical support in usage of the tool. May have successfullycompleted in-depth training in core components of the skill. Able to install andupgrade the tool.
Data Marts: Has successfully appliedthe skill in situations of medium complexity. Occasionally needs assistancefrom internal technical support in its application, operation or practice. Mayhave successfully completed in-depth training in core components of the skill.
Data Warehousing: Demonstrates anunderstanding of design concepts, data organization, capabilities andlimitations. Worked with corporate, as well as local, data warehouse models.Has used at least one of the state-of-the-art data warehouse packages availablein practical application of moderate difficulty.
ETL/ETT/ETM Tools and Process: Uses Datastage tools andutilities to accomplish appropriate data warehouse tasks under the direction ofother team members. Has participated in the process of extracting data fromsimple operational data sources or external data sources, transforming basicdata which includes cleansing, aggregation, summarization, integration, as wellas basic transformation, and loading the data into some form of the datawarehouse. Has experience with at least one type of data warehouse such as ODS,enterprise data warehouse, data mart. Capable of applying new software featuresin one or more ETL/ETT/ETM tools or utilities.
OrganizationalImpact: Executes job responsibilities withthe understanding of how output would affect and impact other areas related toown job area/team with occasional guidance.
ProblemSolving/Complexity of Work: Analyzesmoderately complex problems using technical experience and judgement
Breath ofKnowledge: Has expanded knowledge gainedthrough experience within a professional area
TeamInteraction: Provides informal guidance andsupport to team members
Vanderbilt University Medical Center is a comprehensive health care facility dedicated to patient care, research, and biomedical education. Our reputation for excellence in these areas has made us a major center for patient referrals from throughout the Mid-South. Each year, people throughout Tennessee and the Southeast choose Vanderbilt University Medical Center for their health care because of o...ur leadership in medical science and our dedication to treating patients with dignity and compassion.The mission of Vanderbilt University Medical Center is to advance health and wellness through preeminent programs in patient care, education, and research.