Senior Data Engineer for the MDM Data Product Team at Avenga. Responsible for provisioning data from master data customer and product systems.
About the role
- Data Engineer focused on building and maintaining data pipelines using SQL Server and T-SQL. Designing data solutions for reporting and analytics from various internal and third-party systems.
Responsibilities
- We are seeking a Data Engineer with strong hands-on experience in Microsoft SQL Server, T-SQL, and data integration to design, build, and maintain reliable data pipelines and data solutions.
- The role will focus on ingesting data from internal systems and third-party platforms, including REST APIs, transforming and validating data, and delivering high-quality datasets for reporting, analytics, and operational use.
Requirements
- Design, develop, and maintain SQL Server databases, tables, views, stored procedures, and ETL/ELT pipelines.
- Write and optimize complex T-SQL queries for data extraction, transformation, reconciliation, and loading.
- Build and support integrations with RESTful APIs, including data ingestion, pagination handling, authentication, and error handling.
- Develop and maintain data interfaces between internal applications, external partners, and third-party systems.
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related discipline, or equivalent practical experience.
- Proven experience in a Data Engineer, SQL Developer, Integration Engineer, or similar role.
- Advanced knowledge of T-SQL, including joins, CTEs, window functions, stored procedures, functions, and query optimization.
- Good understanding of JSON, XML, CSV, and other interchange formats.
- Strong understanding of performance tuning, indexing, execution plans, and database best practices.
- Ability to document solutions clearly and communicate with technical and non-technical stakeholders.
Benefits
- Employee Assistance Program / Counselling
- On-site parking
- Training and development
- Company workwear provided
- Gym discount
- Free tea / coffee
- 1:30pm finish on Fridays
- Holidays 24 days + 8 bank holidays (FTE, pro-rated)
- Quarterly bonus scheme
- Specsavers vouchers
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Data Warehouse Modelling Engineer designing and maintaining data models using Data Vault 2.0 for iGaming industry. Collaborating with stakeholders and optimizing data models in a hybrid work environment.
Senior Data Engineer driving impactful data solutions for the climate logistics startup HIVED's core data platform. Collaborating with cross - functional squads to enhance analytics and delivery.
Data Engineer developing and maintaining CRE forecasting infrastructure for Cushman & Wakefield. Collaborates with senior economists and technical teams to ensure high - quality data solutions.
Data Engineer at PwC, engaging with Azure cloud services to enhance data handling and integrity. Responsibilities include pipeline optimizations, documentation, and collaboration with stakeholders.
Data Engineer Manager at PwC focusing on building data infrastructure and solutions. Leading data engineering projects to transform raw data into actionable insights and drive business growth.
Junior Data Engineer at OneMarketData focusing on data quality and integrity in financial datasets. Collaborating with senior analysts and assisting in data management and analysis tasks.
Data Engineer Manager leading robust data solutions for PwC's clients. Transforming raw data into actionable insights and coaching team members.
Senior Data Engineering Analyst developing and implementing data solutions. Collaborating in a diverse environment focused on data processing and analysis for clients' digital transformation.
Principal Software Engineer in Threat Data Platform developing AI - driven tools for threat intelligence automation. Collaborating on robust data pipelines for PANW’s product ecosystem.