BI Architect, Business Objects, MS SQL Server BI

Essential Duties and Responsibilities

* Interview key stakeholders, understand business needs, document findings, derive requirements, and make detailed implementation recommendation
* Develop enterprise information management (EIM) program and create standards
* Design and create enterprise data models (conceptual, logical, physical) for both OLTP and OLAP environments
* Create data integration standards and patterns
* Maintain ETL jobs that source data from various business and clinical systems
* Develop mission critical BI applications
* Business Objects BI 4.0 server administration
* Data warehouse system administration
* Troubleshooting data warehouse and Business Objects related issues

Required Skills

Candidates 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