Data Manager – Brussels, Belgium

Data Manager

Start Date ASAP
Duration of the mission: 2 months

Within the team, the Data Manager takes care of setting up and maintaining the data environment; adding new sources as they come available; creating and implementing policies to ensure data security; optimising for performance and speed of existing data stack; propose new technologies and prepare for Big data.

Function description

  • Responsible for near real time analytics data warehouse layered architecture and implementation
  • Design, implement and maintain a data warehouse framework that helps the team to monitor the workflow execution, data import quality and system usage
  • Design, implement and maintain a security data model for the analytics data warehouse and reporting layer
  • Design, implement and maintain a data reporting layer for efficient reporting/fast querying in Tableau
  • Design standard ETL workflows for extracting data from different sources such as SQL Server, Oracle, Sybase, Flat Files and then transforming and loading into the Analytics data warehouse
  • Implement and maintain a standard ETL framework functionalities using Alteryx. This includes creation of various utility, batch processing macros, creation of standard templates for dimension, bridge, fact & reporting layer loads
  • Assist with the design of workflows/macros to perform client activity and behaviour analysis
  • Design, Develop and Maintain system monitoring dashboards in tableau
  • Guide the junior team members during the development & conducted various knowledge sharing sessions
  • Conduct analytics data warehouse performance tuning & indexing strategy implementation
  • Implement SQL Server Enterprise features such as Column store indexing to improve the data retrieval operations, Partition Switching feature to minimize the downtime and table compression techniques to reduce the data size on disc
  • Handle Code Integration, release preparation & performed release across different environments
  • Handle various adhoc data requests from different teams
  • Coordinate with different teams on liaising data feeds and their frequencies
  • Propose new technologies and prepare for Big data, including Hadoop.

Core competencies:

  • Drive for results – Delivers high quality work
  • Risk awareness – Demonstrates a good awareness of risk and fundamental risk concepts. Always considers risk in his/her daily activities
  • Corporate role model, integrity & ethics – Acts with discipline and high ethical standards
  • Team player & cross cultural awareness – Works effectively in a team. Collaborates and shares information and solutions with colleagues, with other teams and stakeholders
  • Client focus – Sees stakeholders as well as external clients as “customers”

Technical competencies:

  • Market, product & business – Is genuinely interested in financial markets and continually learning and staying abreast of new developments. Evidences a good appreciation of economics and market dynamics, with enough understanding to present views on market conditions and trends
  • Business risk – Understands the market, credit, operational, compliance, legal, regulatory and reputational risks of work she performs

Essential personal skills:

  • Diligence – Displays dedication and prioritises problems by considering the impact on the business; identifies quick-wins
  • Resilience – Stays calm and positive, controls his/her emotions in conflict or any situation of intense stress (due to market, time or client pressure).
  • Communication (Active listener and clear communicator) – Communicates clearly in both native and English languages. Communicates pro-actively with management, escalating issues as necessary.
  • Innovation – Thinks laterally to identify other sources of useful information and sees ways around obstacles and barriers.

Your profile

  • Education Master or PHD in Data Warehousing and Data Mining Certification
  • Expert / Certified in SQL Server 2014 Enterprise Edition, Alteryx Designer 10.0, Alteryx Server 10.0, Tableau 9, Sharepoint Proficient in “R”, and good understanding of Python, XML, C, C++, JS, D3, Java
  • Knowledge on Windows Server administration & Linux (Redhat)
  • Project management methodology (Prince2…)
  • Languages: French Yes, or Dutch, Dutch Yes, or French, English Proficient
  • At least 5-8 years of relevant experience
  • Knowledge on technical infrastructure
  • Good understanding on IT architecture
  • Strong knowledge in Data architecture, modelling, Data warehousing design, Star Schema and
  • Snowflakes Schema methodologies
  • Good knowledge on Data Mining techniques
  • Good knowledge of Databases including SQL Server
  • Experience on Data integration
  • Good knowledge of relational databases including SQL Server and analytics database like Teradata, Sybase IQ or Vertica
  • Knowledge on technical infrastructure
  • Expert / Certified in SQL Server 2014 Enterprise Edition, Alteryx Designer 10.0,  Alteryx Server 10.0, Tableau 9, Sharepoint
  • Proficient in “R”, and good understanding of Python, XML, C, C++, JS, D3, Java
  • Knowledge on Windows Server administration & Linux (Redhat)
  • Good understanding on IT architecture
  • Project management

Powered by WPeMatico