Role description
Who we are
At UST, we help the world's best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our clients to co-create lasting change. Together, with over 30,000 employees in 30+ countries, we build for boundless impact—touching billions of lives in the process. Visit us at UST.com.
Summary
UST is looking for an experienced SQL ETL Developer with strong expertise in Microsoft SQL Server, ETL/ELT development, T-SQL, and data integration. The ideal candidate will be responsible for designing, developing, and optimizing enterprise data pipelines, data migration solutions, and ETL processes to support business intelligence and analytics initiatives. This role requires hands-on experience in SQL performance tuning, data modeling, file transfer automation, and modern data engineering best practices.
The Opportunity
- Design and develop general and detailed technical design specifications for moderate to complex data integration solutions.
- Assist in migrating and integrating data and business processes from legacy systems to modern applications and platforms.
- Develop, maintain, and optimize Microsoft SQL Server objects, including:
- SQL Scripts
- Stored Procedures
- Functions
- Triggers
- Views
- Build scalable ETL/ELT solutions for data ingestion, transformation, cleansing, validation, and distribution.
- Design and implement enterprise data pipelines following data engineering and analytics best practices.
- Develop data models and support near real-time data processing solutions.
- Perform data validation, reconciliation, exception handling, and quality checks during data load processes.
- Optimize ETL package execution and SQL query performance for large-scale data processing.
- Design ETL workflows involving:
- File Transfers
- FTP/SFTP Integration
- Secure Data Exchange
- Import and export files using FTP and SFTP protocols.
- Debug, troubleshoot, and tune ETL processes to ensure efficient, reliable, and accurate data movement.
- Collaborate with Business Analysts, Data Architects, Developers, and QA teams to deliver high-quality data solutions.
- Prepare technical documentation, deployment guides, and support documents for ETL processes.
- Participate in Agile ceremonies, code reviews, and continuous improvement initiatives.
What You Need
- Strong hands-on experience with Microsoft SQL Server.
- Advanced knowledge of T-SQL, including:
- Stored Procedures
- Triggers
- Views
- Functions
- Complex SQL Queries
- Strong experience in designing and developing ETL/ELT solutions.
- Experience with data migration, data integration, and legacy system modernization.
- Strong understanding of data modeling, data warehousing, and ETL best practices.
- Experience implementing data validation, reconciliation, and error-handling processes.
- Strong SQL performance tuning and query optimization skills.
- Experience working with FTP and SFTP for secure file transfers.
- Experience designing automated data exchange workflows.
- Strong analytical, debugging, and troubleshooting skills.
- Experience working in Agile software development environments.
- Excellent communication and documentation skills.
- Experience with SSIS, Azure Data Factory, Informatica, Talend, or other ETL tools.
- Knowledge of cloud-based data platforms such as Azure, AWS, or Google Cloud Platform (GCP).
- Experience with data warehousing concepts and dimensional modeling.
- Familiarity with CI/CD pipelines and DevOps practices.
- Experience with Power BI, Tableau, or other Business Intelligence tools.
- Exposure to real-time or streaming data technologies.
- Knowledge of version control tools such as Git.
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Engineering, or a related technical discipline.
- Experience in enterprise data integration and SQL development projects is preferred.
- 5+ years of experience in SQL Development, ETL/ELT, and enterprise data integration.
- Proven experience developing scalable data pipelines and optimizing SQL Server-based applications.
- Experience supporting enterprise reporting, analytics, and data migration initiatives.
What We Believe
We're proud to embrace the same values that have shaped UST since the beginning. Since day one, we've been building enduring relationships and a culture of integrity. Today, those same values inspire us to encourage innovation, champion diversity and inclusion, and place people at the center of everything we do.
We will listen, learn, be empathetic, and help selflessly in our interactions with everyone.
Through business, we will better the lives of those less fortunate than ourselves.
We honor our commitments and act with responsibility in all our relationships.
Equal Employment Opportunity Statement
UST is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, citizenship status, or any other basis protected by applicable federal, state, or local law.
UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.
- To support and promote the values of UST.
- Comply with all Company policies and procedures.
Skills
Microsoft SQL Server, SQL, SFTP, ETL, FTP
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.
