Data Engineer

Avenga; Köln; Vor Ort; EUR 50.000 - 70.000; Vollzeit

Zusammenfassung

A global tech firm in Köln is seeking an experienced Data Engineer to support development and optimization of data workflows. The ideal candidate will have strong SQL Server skills, expertise with T-SQL, and experience in database management. This role involves implementing schemas and partitioning strategies, as well as supporting testing and production rollout. Join a diverse workplace committed to equal opportunities and fostering creativity.

Qualifikationen

• Strong hands-on experience with SQL Server development.
• Advanced T-SQL skills including stored procedures and functions.
• Experience handling XML data in SQL Server.

Aufgaben

• Implement database schemas, tables, indexes, and partitions.
• Develop stored procedures for data capture and conversion.
• Support testing, stabilization, and production rollout.

Kenntnisse

SQL Server development

T-SQL

XML handling

Query optimization

Batch processing

Database validation

Jobbeschreibung

This is us

At Avenga, we believe that human creativity empowers technology that matters. Operating globally, our 6000+ specialists provide a full spectrum of services, including business and tech advisory, enterprise solutions, CX, UX and UI design, managed services, product development, and software development.

This is the job

We are looking for an experienced Data Engineer with strong MS SQL Server skills to support the development, optimization, and maintenance of key data processing workflows.

This is you

• Strong hands‑on experience with SQL Server development
• Advanced T‑SQL (stored procedures, functions, transactions)
• XML handling in SQL Server
• Query optimization and indexing
• Partitioning and large‑table management
• Understanding of batch processing and data pipelines
• Experience with database‑level validation and integrity checks

Nice‑to‑have skills

• Experience debugging data issues in integration environments
• Support for performance testing and tuning
• Familiarity with production support and stabilization activities

This is your role

• Implement database schemas, tables, indexes, and partitions
• Develop stored procedures supporting data capture, conversion, batching, batch handoff to application layer
• Implement XML parsing and transformation logic
• Support handling of duplicate messages, late‑arriving data, corrections and reprocessing
• Implement performance optimizations and partitioning strategies
• Support testing, stabilization, and production rollout
• Assist QA and operations teams during testing and defect resolution

At Avenga, everyone matters. We provide equal opportunities in recruitment, career development, and leadership, regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. We are committed to fostering a work environment where our diverse community of employees, candidates, and business partners actively shapes our growth. By bringing together people from different backgrounds and experiences, we build a workplace where everyone feels free to be themselves while honoring the boundaries of others.