SQL Database Engineer

Based in London and reporting into the Director of Business Intelligence. We are seeking a SQL Database Engineer with a passion for learning and problem-solving. You will be part of a team who will be responsible for rapidly building out a full scale enterprise level Datawarehouse / lake, aligned with our data-driven roadmap strategy. The candidate will have hands-on experience in managing structured and unstructured databases, including MS SQL Server, Google BigQuery or similar products. This role will require you to work closely with various teams, manage data warehouses, and integrate data solutions that drive business insights. You will be empowered to experiment and learn as you grow in your role.

• Design, implement, and maintain efficient database systems using MS SQL Server, Google BigQuery, or other structured/unstructured database solutions.
• Develop and optimize complex SQL queries, stored procedures, and views for reporting and data integration.
• Manage data warehouses, ensuring data integrity, security, and availability.
• Collaborate with cross-functional teams to develop and implement APIs to interface with databases and other applications.
• Perform data migration, transformation, and normalization between systems.
• Continuously identify areas for database performance improvement and proactively address bottlenecks.
• Troubleshoot and resolve database-related issues in a timely manner.
• Keep up with industry trends and best practices to enhance data management strategies.
• Actively participate in team discussions, contributing ideas and learning from mistakes to improve systems.

Essential Experience:

• Experience as a SQL Database Engineer or similar role.
• Database Expertise: Proficiency in MS SQL Server and Google BigQuery or similar databases (both structured and unstructured data).
• Experience with other database platforms such as PostgreSQL, MongoDB, or NoSQL.
• Strong Familiarity with ETL processes, data pipelines, and cloud infrastructure.
• API Knowledge: Experience with APIs and integration into database systems is a must.
• Data Warehousing: Strong experience in managing and maintaining data
• Knowledge of data security and compliance regulations.
• Strong understanding of performance tuning and database optimization.

About you:

• Problem Solving: A proactive attitude toward finding solutions and resolving issues.
• Learning Mindset: Willingness to make mistakes, experiment, and learn from them.
• Communication Skills: Ability to effectively communicate technical concepts to non-technical stakeholders.
• Proven track record of ideating, executing, and building out Datawarehouse’s and Data lakes
• Knowledge of the Hotel Industry and experience working within hospitality is beneficial, especially in the areas of booking engine optimisation, upselling, and digital guest experience.
• Experience working across complex businesses and managing different stakeholders

What’s in it for you…

• The opportunity to join an innovative, fast-growing, international group that’s committed to not just building new hotels but building a global brand.
• The chance to challenge the norm and work in an environment that is both creative and rewarding.
• Become part of a team that’s very passionate about creating great hospitality experiences and building a portfolio of brands.
• Great discounts across the entire Ennismore family.
• A competitive package and plenty of opportunity for development.