Data Warehouse Developer

Location
Malta
Salary
35,000 - 55,000
Contact
Giada Pietribiasi
Job Ref
732212
  • iGaming well-established organisation
  • Latest technologies
  • Professional Development

Description As our new Data Warehouse Developer you will be a part of the team responsible for maintenance and further development of the existing company data warehouse system in the cloud environment (AWS), which acts as a single point of truth for making data-driven business decisions. The work will consist of data modeling and data transformation design, development of new and improving existing data load processes, ensuring that the data warehouse has the best architecture, data quality and that the system is performant, scalable & maintainable while processing high volumes of data and executing complex ETL and reporting queries. As part of your responsibilities, you will also be expected to review and develop further current technology stack and ensure the use of industry and business best practices.
  
What will you get up to day to day?
  • Propose and build re-usable solutions, develop and maintain processes while applying best practices to maintain Data Load to/from upstream/downstream systems
  • Design and extend further existing data warehouse model
  • Design and develop: - Data load ETL / ELT processes with large and complex data sets, making sure the solution is maintainable, built with reusable components and with optimal performance - Reporting layer data sources and BI reports for data delivery to business - Data/reports delivery automation - Integration/data load processes from/to different upstream/downstream systems
  • Follow and apply best practices while building the data model, data warehouse data load processes, and reporting framework maintaining efficiency and robustness of the process.
  • Design data structures and data load processes for optimal performance and scalability
  • Focus on data quality assurance, verification of accuracy and consistency of data
  • Maintain and support data load processes ensuring regular loads on time
  • Troubleshoot and resolve issues with the data warehouse and external data feeds
  • Support, assist, establish and maintain appropriate communication channels with business users in the context of company data assets
  • Performing ad hoc data analyses when required
  • Maintain and promote collaboration with other technical teams responsible for upstream/downstream systems
  • Maintain transparent communication within the team / other business departments within the company
  • Participate in brainstorming meetings to discuss existing issues and new ideas
  • Participate in daily / weekly team meetings
  • Develop further current skill set both from a technological and soft skills perspective
Requirements What experience do you bring?
  • 4+ years of extensive Data Warehouse/Data Integration focused work experience
  • Hold an academic degree in a quantitative discipline such as statistics, computer science or mathematics
  • Strong experience in designing and managing large Data Warehouse, minimum 1TB
  • Advanced knowledge and understanding of data warehouse concepts (such as Kimball or Inmon methodologies)
  • Strong experience in business analysis and requirements gathering from business users
  • Experience with columnar databases such as Amazon Redshift, Big Query or similar is desired
  • Experience with AWS or GPC cloud platform services is desired
  • Experience with big data solutions in cloud environment will be considered an asset
  • Extensive hands on experience using one of the mainstream data integration products such as Talend or similar
  • Experience in managing semantic layer of Business Intelligence/Analytical platforms such as Tableau or similar is desired
  • Extensive experience in SQL query writing and optimization experience
  • Strong experience of the mainstream DBMS like MySQL, PostgreSQL etc.
And what kind of person are you?
  • Ability to obtain, analyze and synthesize information from multiple sources
  • Strong problem-solving skills
  • 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
  • Keen attention to detail and data quality
  • Fluent in English
& then some nice to have...
  • It would be a great asset if you have previously worked with big data solutions in a cloud environment and on supporting a Data Warehouse system within the iGaming industry.
  • Knowledge of Python or have experience in supporting a data warehouse system would be considered a plus!
Apply now Subscribe to job alerts
Giada Pietribiasi
Associate Consultant
Share this job

Back to search results

Back to search