SQL Senior Data Engineer (Hybrid - Madrid)
Summary
Senior Data Engineer at UST (IT services firm) for a strategic banking-sector project in Madrid. Day to day: building complex SQL transformations and ETL/ELT pipelines, enterprise data modeling (Data Vault, dimensional, SCD, 3NF), data quality controls, and BI datasets, with Python for automation. Hybrid — 3 days/week at the client's central Madrid offices; fluent English required.
What we look for? 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.
⚙
Key Responsibilities: 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.
Mandatory requirements: 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.
¿What can we offer? -✈️ 23 days of Annual Leave plus the 24th and 31st of December as discretionary days! -❤️ Numerous benefits (Heath Care Plan, Internet Connectivity, Life and Accident Insurances). - `Retribución Flexible´ Program: (Meals, Kinder Garden, Transport, online English lessons, Heath 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!
In UST we are committed to equal opportunities in our selection processes and do not discriminate based on race, gender, disability, age, religion, sexual orientation or nationality. We have a special commitment to Disability & Inclusion, so we are interested in hiring people with disability certificate.