Senior Data Engineer

Serko is an NZX50, global business travel and expense company, with our Headquarters based in Parnell, Auckland. As the 2020 HI-Tech Company of the Year, we're a SaaS that is diverse, close-knit group where everyone's opinion matters. We’re already the established leader in Australasia and revolutionizing the way people do business travel in the USA and Europe - and we’re growing Our purpose is to "**Bring People Together**", coupled with a vision to "**Create a Connected, Frictionless Travel Experience**". While the world of business travel is changing, we’re preparing companies for this with intelligent technology that helps them ensure the continued safety and wellbeing of their travelers. **Requirements**: The Data Engineer is responsible for implementing solutions to ever-changing data needs covering various data/database platforms and tools. This role ensures best practices are implemented to ensure systems are highly available, secure, optimal and scalable. We are looking for someone who has a very strong SQL Server background (Microsoft SQL Server, Azure SQL, SQL Managed Instances), who have been working in the role of DBA or SQL Developer, and who is looking to advance their career and grow with us in the field of database administration and data engineering in the near future. **What you will be doing** - Perform DBA-like operational tasks that include fulfilling database-related service requests, monitoring and improving our Cloud-based SQL environments, and resolving incidents with the help of software engineers. - Perform T-SQL development tasks such as creating new or optimising existing T-SQL code (queries, stored procedures, functions), and reviewing and approving T-SQL code written by software engineers. - Participate in initiatives such as regular database performance improvement, process improvement, automation, and data security review. - Contribute to other projects that includes tasks such as creating data pipelines, building a data model, and creating reports. - Mentor and coach other engineers at any level. - Adhere to SQL and data engineering best practices. - Collaborate with various stakeholders to bring better tooling and automation opportunities related to database infrastructure. - Participate in an on-call roster (roughly one week for 4 weeks). **What would you bring to the role** - A strong understanding of SQL Best Practices and the ability to communicate such. - Experience working in an agile software company. - Experience in monitoring and tuning T-SQL stored procedures and functions. - Experience in typical DBA operation tasks. - Experience working on Cloud (Azure, AWS, etc). - Experience in some scripting language (PowerShell, Python, Bash, etc). - Experience or knowledge in PostgreSQL is a plus. - Experience or knowledge in CD/CI or model-based database deployments is a plus. - Experience or familiarity in NoSQL Database (Cosmos DB, MongoDB etc.) is a plus. - Experience with modern practices and techniques (e.g. infrastructure automation, CD/CI) is a plus. - Keen interest in what’s happening in the data platform space (SQL, NoSQL, data warehousing). We don’t expect you to have hands-on experience with leading-edge technologies, but it would be good to understand how you keep up to date with any new trends. **Benefits** It's important to us that our people can bring their whole selves to work. Join our team and we have the following on offer for you It's important to us that our people can bring their whole selves to work. Join our team and we have the following on offer for you - A competitive base salary and opportunity to take part in our employee incentive share scheme, kiwisaver (or global equivalent) and life insurance - Flexible and hybrid working arrangements, where you get to choose how to best structure your day and week so you can be at your best - A focus on both wellbeing and doing, including: - Wellbeing & volunteer days, focused meeting free time - Discounted Southern Cross health insurance (NZ), free flu shots, and access to a confidential support, guidance and counselling service