BI Architect
Beijing
Responsibilities:
The BI Application Architect is an expert on the SOMC BI implementations and will own and drive the roadmap and strategy in the BI area. Responsibilities will include:
• Reviewing and participating as required in modifications & projects from an Architecture standpoint
• Reviewing RCA’s and taking action accordingly
• Initiating projects & modifications with Business Relation Management to improve reliability, security, flexibility, performance scalability and availability
• Proposing solutions to optimize overall Company costs, including application consolidation, re-use etc.
• Providing technical advice and guidance to Solution Managers
• Creating and maintaining roadmap for solution
• Interacting with SAP in order to maintain technical roadmap
• Keeping abreast of new technology and market trends
• Providing guidance and advice about integration capabilities to maintain strategic and consistent approach
Operational output
Examples of expected contributions:
Design drafts
• Business requirements translated into analytical models
• Implementation
• Data feed and data processing
Design reviews.
Analytical data models.
Application Management operational documents.
Process guidance of sourcing, development and testing of new solutions/functionality.
Supporting development projects with architecture competence.
Role requirements
Excellent understanding of all kinds of information models.
Excellent understanding of data warehouse concepts like ETL, data marts, aggregated models, dimension hierarchies.
Technical expertise allowing for designing and reviewing complex, high performance, large data volume business intelligence solutions.
Key technologies
SQL Server 2008 (RDBMS, SSAS, SSRS, SSIS)
.NET 2.0/3.5
Sharepoint 2007/2010
ProClarity
SAP Business Warehouse
Business Explorer
Business Objects
Background
Expert knowledge in relational database technology.
Solid experience of MS SQL Server.
Solid experience of SAP Business Warehouse.
Extensive experience of data modeling.
Extensive experience of software architecture.
Solid experience of concepts like KPI and scorecards.
Preferred experience of ETL software architecture.
Preferred experience in design of analytical models.
Preferred experience of MS Analysis Services and MS Reporting Services.
Preferred experience of .NET client applications.
Preferred experience of Cognos Planning (Analyst, Contributor)
Preferred experience of planning processes, financial processes (budget, forecasting) |