SQL Senior Data Engineer (Hybrid)

Develop and optimize complex SQL transformations supporting analytics, reporting, and financial/regulatory requirements.

• Work with and enhance enterprise data models, including Data Vault, dimensional models, SCD, and 3NF structures.
• Ensure SQL code is performant, maintainable, and aligned with data architecture standards.
• Implement data quality controls, testing frameworks, and validation rules.
• Maintain documentation, data lineage, and metadata management practices.
• Design, build, and maintain SQL-centric ETL/ELT pipelines.
• Develop ingestion processes for batch, incremental, and near real-time data flows.
• Leverage Python when beneficial for automation, workflow optimization, and API integrations.
• Support BI initiatives by creating datasets optimized for Tableau, Power BI, or similar platforms.
• Partner with Finance, Risk, Compliance, and business teams to translate requirements into robust data solutions.

We are currently looking for a Senior Data Engineer with strong expertise in SQL development, data modeling, and stakeholder collaboration to join a strategic project within the banking sector.

Required to go to the client´s offices in central Madrid 3 days a week.

High English level is required., 5+ years of experience in Data Engineering or SQL-heavy backend development roles.

• Expert-level SQL skills, including complex querying, performance tuning, and optimization.
• Strong experience with enterprise data modeling methodologies such as Data Vault, Dimensional Modeling, SCD, and 3NF.
• Hands-on experience building scalable ETL/ELT data pipelines.
• Experience implementing data quality controls, testing, and monitoring frameworks.
• Strong stakeholder management and communication skills.
• Experience working in Agile environments.
• Fluent English (written and spoken).

Nice to have:

• Python development experience for automation and workflow enhancement.
• Experience with Tableau, Power BI, or other BI/analytics platforms.
• Banking, financial services, or other highly regulated industry experience.
• Knowledge of data governance, metadata management, and data lineage practices.
• Experience with core banking platforms such as Temenos T24/Transact, Temenos Triple´A, or similar solutions.

23 days of Annual Leave plus the 24th and 31st of December as discretionary days!

• Numerous benefits (Health Care Plan, Internet Connectivity, Life and Accident Insurances).
• `Retribución Flexible´ Program: (Meals, Kinder Garden, Transport, online English lessons, Health Care Plan…)
• Free access to several training platforms
• Professional stability and career plans
• UST also compensates referrals from which you could benefit when you refer professionals.
• The option to pick between 12 or 14 payments along the year.
• Real Work Life Balance measures (flexibility, WFH or remote work policy, compacted hours during summertime…)
• UST Club Platform discounts and gym Access discounts

If you would like to know more, do not hesitate to apply and we’ll get in touch to fill you in details. UST is waiting for you!

Otros detalles de la oferta

Data Vault Dimensional Modeling SCD 3NF

Base de Datos/DBA Analista

Nivel Profesional: Empleado

CVs inscritos en el proceso: 0 Nunca debes compartir tus datos bancarios ni fotos de tus documentos al solicitar un empleo. Si tienes alguna duda sobre un proceso de selección En esta oferta serás redirigido a la pagina web de la empresa. Completa el formulario en su web.

• Madrid (Híbrido) Ubicación

• Base de Datos/DBA Funciones

• Jornada completa Jornada

• Más de 5 años Experiencia

• Indefinido Tipo contrato

• Data Vault Dimensional Modeling SCD

Ofertas de empleo similares

Descripción de la oferta de empleo

We are still looking for the very Top Talent…and we would be delighted if you were to join our team!

More in details, UST is a multinational company based in North America, certified as a Top Employer and Great Place to Work company with over 35,000 employees all over the world and presence in more than 35 countries. We are leaders on digital technology services, and we provide large-scale technologic solutions to big companies.