World Wide Technology Senior Data Warehouse Business Analyst in St. Louis Missouri United States
Senior Data Warehouse Business Analyst Location: St. Louis, MO - HQ Department: Information Technology
of openings: 0
World Wide Technology (WWT) is a global systems integrator and supply chain solutions provider that brings an innovative and proven approach to how organizations around the world evaluate, architect and implement technology.
Based in St. Louis, WWT works closely with industry leaders such as Cisco, HP, EMC, NetApp, Citrix, VMware and Dell, focusing on three market segments: Fortune 500 companies, Service Providers and the Federal Government. WWT employs over 2,500 people and operates more than 1.5 million square feet of state-of-the-art warehousing, distribution and integration space strategically located throughout the U.S. WWT is proud to announce that it has been named on the FORTUNE “100 Best Places to Work For®” list for the past three years.
We are looking for smart, passionate IT professionals.
World Wide Technology (WWT) Data Warehouse Analysts work in a very dynamic and challenging environment designing and implementing our Enterprise Data Warehouse. There are no skill silos here. Our analysts utilize a broad range of technical and functional skills while working with a wide range of corporate stakeholders to understand business processes, create functional-technical designs and models, and work closely with ETL developers to ensure proper implementation. Looking for an opportunity to break out of a strictly functional or a highly technical role and want an opportunity where there is a perfect marriage between the two? Look no further. WWT Data Warehouse Analysts are encouraged and provided opportunities to to expand their technical knowledge with tools and technologies (such as Oracle Data Integrator) that have relevance in our technical environment.
As a member of our Data Warehouse team you will:
• Be equal member of a cohesive and selfless team. • Take complete ownership of your data warehouse designs and information solutions with the goal of exceeding customer expectations. • Work closely with business aligned IT Analysts and members of the business community to gain knowledge and experience in a wide range of complicated and challenging business processes. • Based upon your understanding of the business process, design Fact and Dimension tables as well as innovative solutions to complicated data issues which enhance traditional star-schema data structures. • Debug any issues in production environment and be part of the Data Warehousing production support team. • Work in an agile team - plan, prioritize, design, test and coordinate end to end delivery of ETL solutions.
At World Wide Technology, we believe in empowering people. If you seek a position that breaks the traditional analyst role; a position that offers you the opportunity to help build an Enterprise Data Warehouse from the ground up; a position that will challenge and expand your skill set, then our team may be the place for you.
Qualified applicants will:
• Have BS/BA degree with 4 years data warehousing experience. • Have extensive experience in Oracle database. • Have experience working with and understanding complex business processes to create functional-technical data warehousing requirements. • Have working experience with dimensional models (star-schema). • Have excellent SQL skills with working PL/SQL knowledge. • Have strong analytical and problem solving capabilities. • Ability to predict future data requirements and design robust data models. • Be able to work on above and beyond technical and process initiatives. • Be open to new technologies, industry trends and ability to adopt latest design methodologies. • Have strong debugging skills for production support • Embrace the WWT culture and values.
Your design shows who you are! (While the position is primarily that of a Business Analyst; understanding dimensional modeling is a key requirement)
There is a widget order processing system. Send us a brief description or diagram of the design (along with your resume) that describes the order process in the form of a dimensional model. In your dimensional model, how would one handle a transactional architecture where a Widget can belong to two or more Item Categories (or groupings) simultaneously? Be creative!
WWT offers a competitive salary, training, and excellent benefits. For more information, please visit our corporate web page at www.wwt.com.
Equal Opportunity Employer Minorities/Women/Veterans/Disabled