Data Engineer
Role details
Job location
Tech stack
Job description
We're looking for a talented Mid-Level Data Engineer to join us at a genuinely exciting moment in our data journey. You'll work with a robust, production-ready Azure data platform, enhancing and optimising our event-driven pipelines and analytical systems, while also playing a key role in designing and shaping our next-generation architecture using the latest Azure technologies.
This role gives you the best of both worlds: the satisfaction of improving a live, business-critical platform and the opportunity to help build a modern, future-proof data ecosystem. If you enjoy solving real operational challenges while also influencing greenfield design, you'll thrive here. It's ideal for someone who loves variety, values impact, and gets energy from seeing their work make a difference across the organisation, ETL development and maintenance
- Develop, maintain, and extend our C# ETL application codebase; adding new data flows, optimising existing, and improving reliability
- Work with Azure SQL Managed Instance - authoring and tuning SQL queries and scripts executed by the ETL layer
- Monitor and support Azure Data Factory pipelines, investigating and resolving failures promptly
- Participate in code reviews and contribute to engineering standards across the ETL codebase
- Investigate and resolve data quality issues across the ingestion-to-reporting pipeline
Event-driven ingestion
- Maintain and improve Event Hubs consumers and associated ingestion pipelines
- Ensure event data lands correctly and completely, with appropriate monitoring and alerting
- Semantic layer and reporting
- Make governed changes to Azure Analysis Services tabular models - new measures, hierarchies, and role-based access configurations
- Work with analysts and Power BI report authors to translate reporting requirements into well-modelled data
- Help define and document metric definitions in the semantic layer, reducing ad-hoc engineering requests
Architecture and modernisation
- Contribute to the evaluation and design of future architectures
- Support the gradual improvement of self-serve analytics capability for internal and client-facing consumers
Engineering practice
- Follow and help improve the team's CI/CD and deployment practices via Azure DevOps
- Contribute to documentation of data flows, dependencies, and transformation logic
- Participate in sprint ceremonies as part of a cross-functional scrum team
Requirements
Do you have experience in Scrum?, Essential
- C# - comfortable reading, writing, and debugging application code in a production codebase; data engineering context preferred but not required
- SQL - complex query authoring, performance tuning, understanding of execution plans
- Azure SQL Managed Instance or SQL Server - production familiarity
- Git-based workflows - branching, pull requests, code review in a team context
- Azure Event Hubs - working knowledge of event streaming concepts
- Azure Analysis Services or SSAS tabular models - able to make supervised changes to existing models
- Dimensional modelling concepts - star schema, fact and dimension design
- Experience with medallion architecture and lakehouse patterns
- Experience working on a platform undergoing active architectural evolution
Desirable
- Microsoft Fabric - hands-on or structured learning; a personal project counts
- Power BI - understanding how reports consume the semantic layer
- dbt Core
Benefits & conditions
Flexible working: We appreciate that individuals' situations can vary for childcare, studying or many other reasons. With that in mind, we can offer flexibility within hours to accommodate this.
Simply Health scheme: We have an excellent health scheme plan that allows employees to sign up for the following three months of employment. This includes financial support towards dentists, chiropractors, private appointments and many more.
Office close to the beach: Our Office is situated locally to the beach. In 2022 & 2023, we held our Kortext summer party at the beach, and it was an excellent setting for our remote and local staff to connect.
Hybrid working: Following Covid, we adapted to the times, offering remote/hybrid positions, allowing us to source talent outside Bournemouth and expand our business.
26 days Holiday: We start at 26 days of Holiday plus eight bank holidays, with an opportunity to increase to 29 days after five years (pro rata for part-time members)!
Learning and development: We offer a range of L&D, regular refresher training, coaching and mentoring, buddy programme, and many more!
Work environment
You will be expected to have a dedicated home office area to focus on work related activities and communicate effectively with customers and colleagues.
Equal Opportunities Employer
At Kortext, we're building a workplace where everyone feels valued, included, and empowered to thrive. We celebrate diversity and believe that different perspectives drive innovation. Whoever you are, wherever you're from, you're welcome here.
Reasonable Adjustments
We recognise that everyone is unique, and we encourage you to speak to us should you require any adjustments during the hiring process & your employment.
Job Types: Full-time, Permanent
Pay: £48,000.00-£52,000.00 per year