SQL/ETL Developer

Company Description

S5 is a next-generation retail AI company that helps global brands and retailers drive smarter, faster, and more profitable decisions, from assortment planning to allocation and pricing. We’re product-first, insight-led, and focused on building a world-class team across the US and India.

We work with some of the largest and most respected retailers in North America and Europe, and we're backed by people who understand what it takes to build category-defining platforms. This role presents an opportunity to help build our India operations from the ground up, the right way.

Role Description

This is a full-time on-site role for a SQL/ETL Developer located in the Dallas-Fort Worth Metroplex.

•

Write complex stored procedures, functions as well as support/enhance existing code

• Create/modify database schema, tables, indexes, etc.
• Knowledge of Indexes, cursors, triggers, stored procedures
• Experience working with partitioned tables and other database design patterns
• SQL Database backup, restore experience with working knowledge of log shipping, log mirroring
• SQL code optimization, tuning with ability to work with large datasets
• Extensive knowledge of Data transformation and validation
• Responsible for creating the table structures and will process data that is required to run business critical software applications
• Ability to process source data with various file formats such xml, csv etc
• Infrastructure or Product life cycle management domain knowledge
• Work with stakeholders to assist with data-related technical issues and support data infrastructure needs.
• Ability to understand requirements provided by Business Analysts and translate into ETL and query requirements
• Apply best practices for testing and deployment in an agile environment.

• Contribute to shared Data Engineering tooling \& standards to improve engineering productivity across the company

Qualifications

• Minimum 3 years SQL developer experience, developing / maintain SQL code
• Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting
• Prior experience working with Tier-1 technology consulting firms is a huge plus
• Proven hands-on experience building complex ETLs in a business environment with large-scale, complex datasets
• Scripting experience in python and bash shell
• Proficiency with Git
• Experience with error handling and data validation
• Experience working in GCP or other cloud platforms
• Bachelors in Computer Science, Engineering or similar
• Must be eligible to work in the US

What’s in it for you?

At S5, you will get an opportunity to truly innovate while working with some of the smartest brains in the industry to solve existing and emerging business problems. Additionally, you will play a key role in defining the next generation work culture and work ethic to solve problems that others thought - simply impossible.