DWH Analyst (Business Objects) (SQL) (ETL)

DWH ANALYST (BUSINESS OBJECTS) (SQL) (ETL)

A DWH Analyst (Business Objects) (SQL) (ETL) required for an ASAP start with a major client in Amsterdam.

The DWH Analyst (Business Objects) (SQL) (ETL) will have the following skills and experience -

- Knowledge and experience with SQL tools (Toad, SQL developer) for analysis, testing, and ad hoc inquiries (MANDATORY)
- Knowledge and experience with Business Objects reporting tool (building, maintaining universe, improve response times, Datamodelling, ETL)
- Experience with tools like Service Now and HP ALM.
- Knowledge of Financial Regulatory Reporting and/or Head-Office reporting.
- Working experience in financial service sector, preferably with department like "Information Management"
- Experience in translating functional requirements into technical specifications
- Experience with providing first and second line support (via mailbox and telephone)
- Knowledge of ITIL v3 processes: incident, problem, change, configuration, release, capacity, security, test and service management
- Knowledge of and experience with (automated testing, regression testing, UAT)
- Affinity with user access management (validate user rights, analyse and deliver reporting requests related to audit or compliancy)
- Affinity with document processes and creating working instructions
- Understanding of (IT) datamodels, configuration and mapping tables
- Experienced with Agile/Scrum way of working

The DWH Analyst (Business Objects) (SQL) (ETL) will be responsible for -

- Continuity of the daily operational management, - daily data checks on the Finance data warehouse on integrity and consistency of the data
- Maintain and control daily data feeds
- Create ad hoc data extracts with the use of Business Objects and/or SQL for end-user reporting in an international oriented environment
- Maintain the current reporting environment (multiple tools, a.o. Business Objects)
- Support the end-user environment with first and second line support on the data processed in the data warehouse (ad hoc queries, data investigations)
- Participate in user acceptance testing and support end-users in testing
- Participate in change delivery process, co-operate with end users and test teams. The focus lies on content and timeframes.
- Safeguarding the design of the application model and data model. This includes adherence to and improvement of the architecture (principles), definitions and logical data model. Be able to implement these abstract matters in practice.

Please get in touch for an immediate response.