Developsand modifies Business Intelligence solutions under occasional guidance. Designsdata models used for reporting and analytics, develops ETL processes for data,and utilizes BI tools to satisfy end user data needs. Implements small projectsor components of large projects. Ability to solve medium to complex problems.
Collaborative, open team room work spaceenvironment. Expected to be an individual contributor while workingcollaboratively with team members, manager and other internal resources.
Duties and responsibilities
Business Intelligence Tools:
Hassuccessfully used the tool in situations of medium complexity. Occasionallyneeds assistance from internal technical support in usage of the tool. May havesuccessfully completed in-depth training in core components of the skill. Ableto install and upgrade the tool.
Hassuccessfully applied the skill in situations of medium complexity. Occasionallyneeds assistance from internal technical support in its application, operationor practice. May have successfully completed in-depth training in corecomponents of the skill.
Demonstratesan understanding 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:
Usesone or more ETL/ETT/ETM tools and utilities to accomplish appropriate datawarehouse tasks under the direction of other team members. Has participated inthe process of extracting data from simple operational data sources or externaldata sources, transforming basic data which includes cleansing, aggregation,summarization, integration, as well as basic transformation, and loading thedata into some form of the data warehouse. Has experience with at least onetype of data warehouse such as ODS, enterprise data warehouse, data mart.Capable of applying new software features in one or more ETL/ETT/ETM tools orutilities.
Profile ofan Ideal Candidate
2Years of experience is necessary
SQL,PL/SQL experience in Oracle Data Warehouses preferred
ETL tools experience, such as OracleData Integrator, IBM DataStage preferred
BI Tool experience with OracleBusiness Intelligence preferred
About Vanderbilt Benefits
Vanderbilt University offers a competitive, flexiblebenefits package including health, dental, vision, life, accidental death &dismemberment, disability insurance, paid time off, and a 403(b) retirementplan with employer match. Vanderbilt offers tuition assistance to employees,spouses, and dependent children.
VanderbiltUniversity, located in Nashville, Tennessee, is a top-15 private researchuniversity offering a full range of undergraduate, graduate and professionaldegrees. Vanderbilt is situated on a 330-acre campus near the thriving citycenter, serving more than 12,000 students and employing almost 7,000 facultyand staff. The university's students, staff, and faculty frequently citeNashville and the surrounding area as one of the many perks of being a part ofthe Vanderbilt community. Vanderbilt University is a place where your expertisewill be valued, your knowledge expanded, and your abilities challenged. It is aplace where your diversity is sought and celebrated. Vanderbilt was recentlynamed as one of ‘America's Best Large Employers’ and the top employer inTennessee and the Nashville metropolitan area in 2018 (Forbes).
Commitmentto Equity, Diversity and Inclusion
Vanderbilt University is committed to achieving thegoal of a diverse and inclusive academic community of faculty, staff, andstudents. We seek individuals who are committed to this goal and our campusvalues.
Internal Number: 1900565
About Vanderbilt University
Vanderbilt University is a center for scholarly research, informed and creative teaching, and service to the community and society at large. Vanderbilt will uphold the highest standards and be a leader in the quest for new knowledge through scholarship, the dissemination of knowledge through teaching and outreach, and the creative experimentation of ideas and concepts. In pursuit of these goals, Vanderbilt values most highly intellectual freedom that supports open inquiry, equality, compassion, and excellence in all endeavors.