BI Operation and Support Specialist

REF.NR.: 9283JK/OJ

INDUSTRY: Food industry

LOCATION: Lausanne and region

START: ASAP

DURATION: 12 months+

ROLE:

Within the Business Intelligence Department, the BI Operation and support specialist will ensure the run of all the BI services, monitoring the application, supporting the business and ensuring the 2nd and third level of support

MAIN RESPONSIBILITIES:

Operation Manager
. Own the production
. Gate Keeper Production
. Monitor up/down, and analyze the trends high-level
. Log incidents

Run - Incident Manager
. Manage incident life cycle
. Ensure the incident creation
. Identify the product impacted
. Assign the incident
. Follow up/Escalation
. Close the incident

Run - BI support and services
. Support the business to understand the available BI products
. Understand possible discrepancies highlighted by the business and explain it when it's possible
. Analyze the assigned incidents
. Propose corrections
. Develop patch to fix the incidents
. Propose BI enhancements

Run - Database administrator (*Environment manager)
. The database administrator (DBA) monitors the physical data that the project is adding to the existing BI environment. The DBA works closely with the metadata manager to evaluate how the BI is being altered and ensures efficient performance of the BI environment
. Design, implement, and tune database schemas
. Conduct regular performance testing and tuning
. Manage storage space and memory

KNOWLEDGE AND PROFESSIONAL SKILLS:

. Experience as IT Operation Manager
. Very good skills in DBA
. Experience and expertise in ETL development
. Very good ODI Skills
. PSQL expertise
. Good knowledge in Kimball's methodology
. Cognos 8 Reporting tools (Cubes and ad hoc reports)
. CRM and campaign tool like Neolane, Siebel, Data Mining tool like SPSS an asset
. Very good English skills