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 cloud environment (GCP / Big Query and AWS / Redshift), which acts as a single point of truth for making data-driven business decisions. This position is ideal for someone who would like to improve their skill in data warehousing, reporting and GCP and AWS cloud services.

The candidate will be responsible for the operational aspect of the data warehouse environment, maintenance and support of the existing data warehouse load processes, ensuring that the environment of the data warehouse is healthy. Additionally, you will be involved in the data warehouse support process responding to business requests for ad-hoc reporting.

One of the responsibilities will be monitoring and optimising the cost for our GCP / AWS cloud data warehouse infrastructure, including management of software licenses and invoices. This candidate will be responsible for documenting infrastructure and support processes.

Main Activities / Key Responsibilities:

  • Establish a standard of best practices related to segregation of duties, data access, access to resources, technical documentation, server and system updates and system maintenance 
  • Continuous monitoring and assessment of systems performance against defined KPIs
  • Research and test new technologies that can be used to improve our data warehouse processes
  • Maintain and support data load processes ensuring the loads are stable and the data is delivered to business in stipulated time
  • Maintain clear communication to business units about data load failures, inconsistent data and successful loads to the respective distribution groups
  • Structure the team’s folder repository appropriately for data warehouse administration and support process
  • Troubleshoot and resolve issues with the data warehouse and external data feeds
  • Work closely with data warehouse and BI developers on performance improvements of data load processes and reports performance
  • Development of data warehouse ETL/ELT jobs
  • Support and assist business users in data extract/reporting requests
  • 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 technical and 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 technological and soft skills perspective

Technical Skills required:

  • Excellent command of “spoken” English
  • More than 4 years of Data Warehouse and reporting focused work experience
  • Hold an academic degree in a quantitative discipline such as statistics, computer science or mathematics
  • Experience in ETL/ELT development is required
  • Experience in SQL query writing and optimisation experience is required
  • Experience in database and server administration will be considered an asset
  • Experience with GCP/AWS platform services will be considered an asset
  • Experience with troubleshooting problems related to databases, software applications and servers
  • Experience in business analysis and requirements gathering from business users
  • Knowledge and understanding of data warehouse concepts (such as Kimball or Inmon methodologies)
  • Ability to obtain, analyse 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

Technical skills desired:

  • Experience with scripting and programming languages like python would be considered an asset
  • Work experience on supporting a data warehouse system would be considered an asset 
  • Experience within the iGaming industry would be considered an asset

Benefits

  • Competitive Salary
  • Company Bonuses
  • Being in an international team working with the UK, Malta and Sweden
  • Flexible vacation periods and +5 bonus vacation days to your legal annual leave rights (including the first year)
  • Budget for international conferences
  • Good hardware options to work with (2 external monitors, standing desk option, etc.)
  • Dealing with new technologies
  • Flexible and relaxed working environment
  • Kitchen and open fridge for breakfast, cookies, fruits, mostly organic food
  • Central location access to the subway, main bus routes, and highway
  • Good coffee and best siders 🙂
  • During the pandemic period, we have been working remotely from home, providing you with office chairs and monitors. After pandemic times we are planning to continue working remotely with some occasional office days.

Do this position and our workplace sound like it would suit you? Great!

Just send your application and CV in English to contact@frontech.com.tr