Sql Lavoro a distanza e a domicilio

Hybrid Data Engineer Data Engineer

Alliants · United Kingdom · Hybrid

About the job

👋 We’re Hiring a Data Engineer📍 Location: Hybrid (Remote + Southampton HQ + Travel)💸 Salary: Competitive + BenefitsAt Alliants, we're on a mission to transform every customer engagement into something exceptional. We believe in working together to push the boundaries of company culture and create future-proof customer experiences.Are you passionate about creating meaningful customer experiences and helping organisations deliver on their brand promises?Join us as a Data Engineer in our growing Data team! 🚀The RoleTo design, manage, optimise, and improve data architecture across the business, including AXP (SaaS) and services projects. This role will encompass database administration, data engineering, and data governance responsibilities to ensure data integrity, performance, security, and compliance.The position will focus on designing and implementing robust data pipelines, ETL processes, and data integration solutions to support both internal analytics and client-facing data products and service projects. The role will drive the development of scalable, efficient, cost-effective and reliable data infrastructure that enables data-driven decision-making and enhances the value of our data assets.Primary ResponsibilitiesWorking cross-department to ensure data engineering and architecture best practices are implemented through the following:

  • Data Integration and ETL: Design and implement data integration solutions and ETL processes to support both internal analytics and client-facing data products.
  • Data Architecture: Design and implement scalable data architectures. Select and configure databases for optimal performance, security and cost-effectiveness across various environments.
  • Cross-functional Collaboration: Work closely with development, data science, and DevOps teams to align data architecture with application and analytical requirements.
  • Database Performance and Security: Ensure database performance, security, and reliability for both the AXP application and client projects. Work with developers and data scientists to optimise data structures.
  • Performance Tuning: Monitor and optimise database queries and data pipelines. Utilise Rails' Active Record, custom SQL queries, and other data engineering techniques to ensure efficient data retrieval and manipulation.
  • Data Security and Governance: Implement security measures to protect sensitive data, including encryption and access controls. Develop and maintain data governance frameworks to ensure data quality and compliance.
  • Schema Management: Manage database schema changes efficiently using Rails migrations and other tools. Ensure smooth migrations without affecting application availability.
  • Backup, Recovery, and Disaster Planning: Establish comprehensive strategies for data backup, recovery, and disaster planning across all data systems.
  • Capacity Planning and Scaling: Assess and plan for future data growth. Develop strategies for scaling data infrastructure to handle increased load and complexity while minimising cost.
Essential Skills And Experience
  • 5+ years of experience in database administration and data engineering roles.
  • Proficiency in SQL and experience with various languages including Rails, ORM (Active Record) and Node.js
  • Strong knowledge of data modelling, ETL processes, and data warehousing concepts.
  • Experience with cloud-based data solutions (AWS and Azure).
  • Understanding of AWS services for data storage, management, transfer, indexing and caching, such as RDS, Glue, Kinesis, Redshift, Athena, ElastiCache, OpenSearch, etc.
  • Familiarity with data governance principles and practices.
  • Knowledge of data security best practices and compliance requirements.
  • Proven track record in performance tuning and query optimization.
Nice To Have
  • Experience with big data technologies (Hadoop, Spark).
  • Knowledge of machine learning and AI concepts.
  • Familiarity with containerisation and orchestration tools (Docker, Kubernetes).
This position requires a versatile professional who can bridge the gap between traditional database administration and modern data engineering practices while also implementing robust data governance frameworks.Who are Alliants and what do we do?Alliants, established in 2009, is dedicated to producing customer engagement technologies and services that pave the way for a more human, sustainable, and promising future for hospitality.At Alliants, we are all in for our people and our industry.What’s in it for you?We Know We All Work Better In An Autonomous, Collaborative, Diverse And Equitable Space. To Support You In Becoming The Best Version Of Yourself, We Offer You💷 A competitive salary🎁 Up to 10% annual bonus⚖️ Remote & flexible working🏖️ 25 days holiday + public holidays✈️ Digital Nomad: travel abroad while working for 30 days a year📈 Generous level of stock options🏥 Private healthcare👪 Life Insurance🥡 Monthly takeaway allowance🧓🏽 Pension with matched employer contribution🛍️ Customised onboarding kit🎒 £1,500 training and development budget each year🌳 To celebrate you joining the team we will plant a Great Oak treeAlliants celebrate diversity and are committed to creating an inclusive environment for all employees.Alliants are the trusted digital partner of choice across the world's most respected hospitality, travel and retail brands.As global market pacesetters, we lead and innovate with unparalleled expert knowledge and resources.