Principal Data Engineer (SQL/dbt)

We are still looking for the very Top Talentand 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 experiencedSenior / Principal Data Engineerwith deep expertise inSQL-based data engineeringto design optimize and deliver scalable data solutions. While part of the platform operates on Snowflake the majority of the work focuses oncomplex 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 optimizecomplex SQL-based data solutionsacross large and enterprise-scale datasets - Build and maintainrobust 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 usingAzure DevOpsfor automated build test and deployment - Apply strongGit-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 indata engineering and transformation design - Experience withdbtor similar transformation frameworks - Strong knowledge ofGit workflows and version control practices - Experience withAzure 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 toSnowflakeor 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 well 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 serverdatabase triggersdisaster recoverysql server profiler