Description
**Role description** **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 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.
**What are we looking for?**
We are looking for a **Data Engineer** with strong experience in **data migrations, SQL, Python, ETL/ELT pipelines, and AWS**, capable of delivering secure, high\-quality, and fully reconciled data solutions. Experience with large\-scale customer and financial data migrations is essential. **This is a 100% remote position based in Spain.**
**Required experience and skills**
* Strong SQL skills across data profiling, complex transformation, reconciliation, performance analysis and relational modelling.
* Strong Python or comparable data\-engineering experience for repeatable pipeline and validation development.
* Experience delivering large enterprise data migrations involving customer, contract, financial or transactional data.
* Hands\-on experience with ETL/ELT patterns, staging models, restartability, error handling, auditability and controlled reprocessing.
* Experience defining and automating data\-quality checks, reconciliation controls and migration evidence.
* Working knowledge of cloud data services and object storage, preferably in AWS.
* Experience with Git, CI/CD, environment promotion and automated testing for data pipelines.
* Understanding of privacy, security, retention and access\-control requirements for customer and financial data.
* Ability to collaborate with business owners, architects, developers and testers to resolve ambiguous or poor\-quality legacy data.
* Strong written and spoken English and the discipline to maintain clear technical and operational documentation.
**Key responsibilities**
* Profile source platforms and document data inventories, ownership, lineage, quality risks, retention constraints and extraction approaches.
* Design source\-to\-target mappings and transformation rules for customer, account, contract, product, tariff, premise or supply point, meter, read or usage, bill, payment, balance, debt, interaction and reference data.
* Build parameterised ETL/ELT pipelines for extraction, cleansing, standardisation, transformation, validation, loading and replay.
* Implement data\-quality controls for completeness, validity, uniqueness, referential integrity, effective dating, sequencing and cross\-domain consistency.
* Create reconciliation frameworks using record counts, control totals, financial balances, sampled journeys and exception reports across source, staging, target and downstream systems.
* Partner with Business Analysts and utility SMEs to define remediation rules, ownership and acceptable tolerances for legacy\-data issues.
* Support iterative migration rehearsals, defect analysis, reprocessing, performance tuning and evidence\-based readiness decisions.
* Engineer cutover loads, delta or change\-data capture approaches, freeze\-window controls, rollback support and restartable processing.
* Protect personally identifiable and financial data through least\-privilege access, encryption, masking, secure transfer, audit logging and controlled retention.
* Expose actionable pipeline metrics, logs, s and exception queues so failures can be diagnosed and recovered within the cutover window.
* Support operational and analytical integrations to data platforms, reporting services and downstream consumers without compromising the system\-of\-record controls.
* Document mappings, code, runbooks, reconciliation evidence, known exceptions and support procedures; transition ownership to production teams.
**What can we offer?**
* 23 days of Annual Leave plus the 24th and 31st of December as discretionary days!
* Numerous benefits (Health Care Plan, teleworking compensation, 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!**
**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.**
**Skills**
Snowflake, AWS, ETL
**About UST**
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future\-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.