BI and Data Warehouse Analyst
Under direction of the IT Business Intelligence Manager and other members of the BI team, the successful will be responsible for eliciting business requirements from business users and translating them into technical specifications used in the design, development and maintenance of the decision support systems. This will include the development of mapping specifications, report specifications and test plans. Proposed Job Duties Continuously discuss with the business partners, IT development team members, data architects and the cloud SaaS vendor to document the requirements for a data warehouse model design. Analyze the current database structures and interface mechanisms to understand the functionalities. Collaborate with the Business Intelligence Architect and data modelers in the translation of business requirements into a dimensional data model and related metadata. Assist in source definition for the data warehouse attributes. Map attributes to source including identification and documentation of transformation algorithms as necessary. Document findings in the metadata repository. Design ETL jobs to extract data out of vendor's cloud system and from the existing EIAS database. Design and implement ETL jobs to feed UC campuses with EIAS data. Design new reports out of the data warehouse database. In today’s job market, “who you know” matters more than ever – and that’s why you should get to know Volt. We’re one of the world’s largest recruiting companies, yet our success is built one successful placement at a time. Each of our recruiters has niche industry expertise, committed to connecting top talent with respected companies. For more opportunities, connect with us online at volt.com/NorCal. Volt is an equal opportunity employer. Requirements: Bachelors Degree in Information Systems or a related field, or an equivalent combination of education and experience.li> 5 years demonstrated success in data warehouse design, analysis in large, complex business intelligence systems using best practice, standards, tools and techniques. Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms and complex business concepts in technical terms. Strong interpersonal skills; ability to work on cross-functional teams. Intermediate level experience in Kimball Dimensional Design Techniques. Self motivated and independent, able to work with a minimum of supervision and able to work well with stakeholders and project staff. Extensive experience in building enterprise conceptual and logical data models, data profiling, data modeling, data mapping and metadata efforts and data quality initiatives. Intermediate level knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing, business intelligence and decision support systems. Experience with IBM DataStage, QualityStage, FastTrack and Business Glossary preferred. Experience with report development with Crystal Reports or SAP Business Objects Location: Oakland, CA Type: CONTRACT Duration: 180 - 365 Days Pay Rate: DOE Contact: Volt Technical Resources 100 1st Street, Suite 200 San Francisco, CA 94105 PH: 415/536-5804 FX: 415/536-5839 Keywords: IT
|
Oakland
|
Expired |
BalkanBrothers
Logo Designer
View profile
Rebecca Mayglothling
Creative Writer
View profile
Alexander von Ness™
Graphic Designer
View profile
Related projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."