Our insanely fast-growing greater Detroit-area technology client is in need of an experienced Data Warehouse Analyst to join its rapidly expanding team. The successful Data Warehouse Analyst will with directly business units in order to document the systems and processes currently and to-be used for the company s data warehouse. The goals of this role include helping to build definitions and fact tables, run books and data dictionaries in living form in keeping with constantly changing business needs
Document ETL tasks for migrating data from a source system to a target destination system in conjunction with Data Warehouse Developers.
Gather requirements, business process and documentation from business SMEs for building fact tables, developing logical and physical data models, and help to define database standards.
Identify, understand, and map key business metrics and how those lead to or represent success
Work with internal Project Managers to downstream escalations, priorities, and upcoming builds/needs.
Perform analysis on new and existing systems - identify areas of opportunity or redundancy.
Develop subject matter expertise of business processes and applications to be a more effective partner.
Drive consistency in definitions, write dictionaries, and run books and build out fact tables.
Serve as source of truth for training and internal education on all data warehouse tasks, processes outputs, and structures.
Understanding of Data Warehouse, star schema, and fact/dimension data model.
Ability to communicate effectively with both technical and non-technical business groups - including the ability to translate business process/requirements into technical terms.
Strong time management.
Proven ability to develop and nurture relationships across several business units to include technical and non-technical folks alike.
Expertise in documenting business processes.
Expert in identifying success metrics and understanding their impacts.
Experience with triaging problems under pressure and determining root cause to drive resolution.
Experience preparing technical reports by collecting, analyzing, and summarizing information and trends.
About Vivo Having been in business since 2006, Vivo is a full-service recruiting and consulting company, specializing in mid to senior level technology resources. Our brand promise is simple: we get people. We get that our clients don t want to waste time and that our candidates and employees thrive when given honest feedback and an opportunity to grow.
Whether you re onsite at our Pleasanton headquarters or working for one of Vivo s clients the best brand names out there our promise to you is unwavering: we will treat you like you are our most important employee.
Do you think you get people get what they really need, and get how to deliver? We re not perfect but we re accountable. We re not in 32 countries, but we are in the heart of it all. So, if you are looking for a flexible, fun and high-energy work environment, along with the opportunity to work with some of the world s technology leaders, we can t wait to talk to you.