Senior BI and Data Engineer

Location: Malta, office-based or hybrid. Applicants must already be based in Malta. Relocation is not offered. Reports to: CTO and CEO. The CEO sets business priorities; the CTO provides technical direction. About Blokotech Blokotech develops technology platforms for online casino and sportsbook operators. Our data supports both the operators using our platform and the management, commercial and financial decisions behind our own business. We are looking for a Senior BI and Data Engineer to make that data reliable, accessible and useful, while improving the performance and efficiency of our reporting infrastructure. The role You will build and maintain the pipelines, reporting models, dashboards and exports used by Blokotech management and our operator clients. A central part of the role is enabling these users to answer routine questions independently through reliable self-service tools, clear metric definitions and practical documentation. Your responsibilities will also include validating revenue-share calculations, supplier charges and invoices, investigating discrepancies and ensuring reported figures can be traced back to their underlying transactions. This is a hands-on senior role covering data engineering, business intelligence and historical data management. PostgreSQL and AWS S3 are already part of our infrastructure. Metabase is our reporting tool, and previous experience with it is an advantage. Previous BI or data engineering experience in the iGaming industry is essential. Key responsibilities Data engineering and reporting infrastructure Develop and optimise SQL and PL/pgSQL procedures, functions and transformations for reporting, aggregation and data preparation. Build and maintain reliable ETL/ELT pipelines combining gaming, player, wallet, payment, bonus and sportsbook data. Design reporting tables, data marts and historical datasets that provide consistent foundations for analysis. Improve processing efficiency through appropriate incremental loads, partitioning, batching and aggregation. Optimise PostgreSQL reporting workloads and work with Engineering to control their impact on transactional systems. Business intelligence and self-service reporting Create and maintain Metabase dashboards, reporting models, reusable queries and scheduled reports for internal teams and operator clients. Translate business requirements into documented metrics, including GGR, NGR, turnover, deposits, withdrawals, bonus costs and player activity. Validate metric definitions with the relevant business owners and apply them consistently across dashboards, reports and exports. Develop reusable reporting tools, documentation and user guidance that reduce reliance on manual requests. Maintain appropriate access controls and segregation of client data across reporting environments and exports. Financial and commercial reconciliation Build and maintain checks for revenue-share calculations, supplier charges and invoices against source data and agreed commercial rules. Reconcile gaming and financial reports with underlying transactions, investigating discrepancies and documenting their causes. Account for transaction statuses, settlements, rollbacks, corrections, reporting cut-offs, currencies and time zones. Provide clear supporting datasets and traceable calculations so Finance, Commercial and Operations can verify reported figures and investigate differences. Data exports and historical storage Build reliable CSV and Parquet exports for scheduled deliveries, large-volume extraction and downstream analysis. Develop and maintain historical archiving workflows on AWS S3, including lifecycle policies, approved retention requirements and retrieval processes. Validate exports and archived datasets through completeness checks and reconciliation with source data. Document and test retrieval procedures, balancing storage efficiency with the practical need to access historical information. Reliability and continuous improvement Implement data quality checks, pipeline monitoring, failure alerts and safe reprocessing. Maintain version-controlled code and test changes before deployment. Document data sources, transformations, metric definitions and reporting dependencies. Identify opportunities to reduce manual reporting, improve query performance and control processing and storage costs. Maintain a clear delivery backlog, communicate dependencies and risks, and agree priorities with the CEO while coordinating technical implementation with the CTO. Essential experience and skills Previous BI or data engineering experience in the gaming or iGaming industry, working with online casino, sportsbook or gaming platform data. Advanced SQL and PostgreSQL skills, including PL/pgSQL, complex joins, window functions, stored procedures, materialised views and query optimisation. Proven experience building and maintaining data pipelines, reporting models and analytical datasets. Experience delivering dashboards and self-service reporting through Metabase or another established BI platform. Proficiency in Python for data processing, automation and pipeline development. Practical experience with Amazon RDS for PostgreSQL and AWS S3. Experience generating, validating and processing CSV and Parquet files at scale, including an understanding of compression, partitioning and file sizing. Experience with historical data exports, archiving and retrieval workflows. Strong understanding of gaming and financial data, with the ability to reconcile reports against source transactions and investigate differences. Ability to work independently, manage competing requirements and explain findings clearly to technical and business stakeholders. Preferred experience Hands-on experience administering and developing reporting in Metabase, including permissions and query performance. Reporting across multiple operators, brands, jurisdictions and currencies. AWS Glue, Athena, Redshift or comparable analytical platfor