Data Warehouse Architect in Malta
We are looking for a Data Warehouse Architect to join the BI team at a market-leading iGaming company based in Malta. This organisation is enjoying tremendous business success as it gains further market share as well as being the envy of many competitors. Reporting into the Head of BI, the Data Warehouse Architect will have the opportunity to work on different projects and tasks that reach across the entire organization.
You will be responsible for the Data Management side (Data Warehouse, Data Integration, Data Quality Processing, Master Data Management, Metadata management, Predictive Analytics Automation & Data Processing) of a new BICC Function. In a fast moving environment, you will be responsible for turning requirements specifications into a fully functioning data warehouse using an agile methodology. You will be responsible for the development and delivery using Multidimensional Modelling and Columnar databases with data transformation tool.
Work within a multi-disciplinary team to deliver a state of the art Data Warehouse using up to the minute technologies, design and development methods
Develop and manage a multi layered Data Warehouse which will contain a traditional ODS, Intelligent predictive data models, High performance Metric and dimension structures
Manage the data capture, loading, transformation and data integration processing using a cutting edge data integration toolset
Manage the scheduling of the data processing to automate the extraction and processing and exporting of data to downstream systems at different intervals.
Manage the Performance of the Columnar Database from both a data loading and user query perspective
Work with the BI Architect to design and deliver user facing data models that promote speed, accuracy and ease of use. These robust data models will be designed to respond to the needs of a sophisticated Semantic Layer in our Analytical toolset
Work with the BI Architect to deliver intelligent data models to allow the business to examine subject areas such as the propensity to churn and Lifetime Value.
Work with the BI Architect to design and deliver data models that will provide an array of sophisticated metrics for the end users and Bi Analysts to consume via their visualisation tools
Automate Predictive Analytical processing developed by our BI Analysts using our Predictive workflow tool
Obtain an understanding of the data sets used in the gaming industry
Keep up to date with the latest trends and technology developments in the Data Warehouse industry
Skills & Experience Required –
Hold an academic degree within in a quantitative discipline such as statistics, computer science or mathematics
Extensive hands on experience using one of the mainstream data integration products such as SAP Data Services (BODI), Microsoft SSIS, Oracle ODI or Warehouse Builder, Informatica or IBM Datastage
Experience in managing a data warehouse that supports Ad Hoc queries from a semantic layer such as Micro-Strategy, Business Objects or Tableau
Comfortable working in a fast paced environment whilst interacting with a variety of different disciplines
Proven ability to prioritise and deal with problems systematically and provide clear communications regarding the issues, resolution times and solutions Ability to work autonomously within an Agile IT development team
Extensive SQL query writing and optimisation
Experience of MySQL and/or Postgres is essential
Knowledge of a scripting language would be considered an asset
Good communication skills
Person specification –
Fluent in English
Strong work ethic
Positive ‘can do’ attitude
Excellent attention to detail
Produce accurate work consistently
Strong problem solving skills
Flexible to business demands
Good presentation skills
Experience within the iGaming industry is preferred
For further information about this role, email firstname.lastname@example.org.