smart-working-solutions - Senior Data Engineer (Remote, Contractual) [TH003]

• Manage and optimise Snowflake data warehouses. • Overhaul Snowflake warehouse performance through materialisation strategies, dynamic tables, and clustering optimisation. • Build scalable ETL/ELT pipelines using dbt, Airflow, Fivetran, and AWS DMS. • Build ingestion pipelines using DMS and Fivetran. • Develop modelling layers in dbt using medallion architecture principles. • Transform raw data into clean, reliable, and business-ready models using dbt and AI-assisted tooling for documentation and testing. • Integrate data from multiple sources, including CRM systems, payment platforms, gaming platforms, and other operational systems. • Own initiatives focused on data quality improvements and monitoring, including anomaly detection and automated alerting. • Monitor and optimise platform performance, cost efficiency, and security. • Work closely with cross-functional teams across product development, data, operations, and analytics functions. • Collaborate with the data science team and support colleagues with reporting and analytics activities when required. • Support the organisation’s move towards real-time data ingestion and ETL using technologies such as DMS, Kafka, and Kinesis. • Help mentor other engineers within the team. • Contribute to the team's AI strategy and promote effective use of AI tools across engineering workflows. • Produce and maintain clear, comprehensive documentation to support scalability, transparency, and long-term platform sustainability. • Communicate effectively with both technical and non-technical stakeholders and proactively raise blockers when encountered.