Principal Data Engineer (SQL/dbt) - Remote

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 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.

What we look for?

We are seeking a highly experienced Senior / Principal Data Engineer with deep expertise in SQL-based data engineering to design, optimize, and deliver scalable data solutions.

While part of the platform operates on Snowflake, the majority of the work focuses on complex SQL development, data modelling, and performance optimization across large-scale datasets. The role requires strong engineering discipline along with experience in modern CI/CD practices using Git and Azure DevOps.

Key Responsibilities:

Design, develop, and optimize complex SQL-based data solutions across large and enterprise-scale datasets

Build and maintain robust data models and transformation logic, ensuring performance, accuracy, and maintainability

Troubleshoot and optimize query performance using advanced SQL techniques (joins, CTEs, window functions, execution plan analysis)

Develop and maintain transformation frameworks using dbt where applicable

Implement CI/CD pipelines using Azure DevOps for automated build, test, and deployment

Apply strong Git-based development practices (branching, code reviews, version control)

Support data platform components including Snowflake where required, but not as the primary focus

Collaborate with stakeholders to translate business needs into scalable and efficient data solutions

Ensure solutions are production-ready, including monitoring, stability, and support handover

Mandatory requirements:

Expert-level SQL skills (mandatory, primary skill)

Complex query writing and optimization

Data modelling (dimensional, normalized/denormalized)

Performance tuning on large datasets

Strong experience in data engineering and transformation design

Experience with dbt or similar transformation frameworks

Strong knowledge of Git workflows and version control practices

Experience with Azure DevOps pipelines / CI-CD automation

Strong analytical and problem-solving capabilities

Ability to work across full lifecycle (development to production support)

Nice to have:

Exposure to Snowflake or similar cloud data platforms (nice-to-have, not primary requirement)

Understanding of cloud-based data architectures

Familiarity with test automation and data validation approaches

¿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.

Skills

sql server,database triggers,disaster recovery,sql server profiler,

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.