Description
Required SkillsCandidates must have demonstrated proficiency in the following:
- Must have strong communication, collaboration, interpersonal, and organizational skills.
- Hands-on experience in mapping disparate data into a corporate data model.
- Hands-on ETL experience including sourcing data from SaaS data sources.
- Performing data warehouse maintenance activities such as ETL loads, data warehouse backups and recoveries, database loading, BI reporting, capacity planning, security administration for user accounts and enforcing data warehouse security.
- Monitoring and analyzing the performance of data warehouse systems.
- Providing technical assistance to service desk and end users regarding data warehouse issues and problems.
- Responsible for physical database design and implementation by creating and documenting database tables, views, data elements, shared data rules, data marts, data cubes, and reports.
- Building and maintaining a corporate information factory that include structured and non-structured data.
- Installing, deploying, maintaining, and upgrading data warehouse systems that include Business Objects BI 4.0 server and backend Microsoft SQL database.
Required Experience
Five or more years work experience with creating and maintaining information architecture and master data management. Hands-on experience in creating, troubleshooting, tuning, and maintaining data warehouse systems, database administration, and systems administration.
- Work with executive sponsors and domain experts in defining information architecture
- Create and manage a master data management program
- Business Objects Server BI 4.0 Administration, Universe management, ETL, and Reporting.
- Microsoft SQL Server Administration
- SSIS, SSAS, SSRS
- Scripting Language(s)
- Data warehouse solution development
- ETL development and administration
- Database Administration
- Maintaining an established work schedule and providing assistance outside of usual work hours, including nights, weekends, holidays as required.
Preferred Experience
- Web Portal Integration
- SharePoint 2010, 2013
- Microsoft SQL Server 2012, Polybase
- Big Data, Hadoop
Required Education
- Bachelor's degree or equivalent in a related field of study
To find out more about Real please visit www.realstaffing.com