Overview
-
Model, develop, document and maintain database related best practices and system recommendations.
-
Participate in the research and resolution of database problems.
-
Implement and maintain smooth operation and physical design of databases.
-
Development and maintenance of ad-hoc data aggregations and analysis.
-
Facilitate technical design of complex data sourcing, transformation and aggregation logic, ensuring business analytics requirements are met
-
Optimization and improvement of scalabilty of systems
-
Expansion of the automated release process (continuous integration) and quality assurance
-
Excellent command / highly proficient in spoken and written English
-
Knowledge of SQL and data warehousing concepts
-
You are able to find your way around BI areas including ETL design, analytics and reporting
-
Experience in writing complex and optimised SQL’s, creating stored procedures, database scripts.
-
Knowledge of data warehousing techniques such as performance optimisation, data re-use, indexing, partitioning, Star transforms, aggregations, OLAP, etc.
-
Knowledge of Data Quality and Data Profiling.
-
You are used to taking responsibility and working in a dynamic team
-
You build on your solid experience in working with Linux every day
-
You want to advance your career and put your personal touches on a fast-growing software solution
-
PowerBI knowledge is a plus
Tech-Stack:
-
Redshift, MySQL and AuroraDB in the Amazon AWS Cloud
-
Atlassian development tools (Bitbucket, Confluence, Bamboo, Jira)