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.
