SQL Developer

This is a remote position.

At S5, we are on a mission to make Advanced Data Science consumable to Business Users. S5 is a SaaS software provider of AI/ML-powered products which transform planning and decision making capabilities across the digital supply chain for the Retail and CPG industries. To support our aggressive growth, we are actively seeking talent (at multiple levels) to join our team. The Role:S5 Stratos is seeking an experienced SQL developer who will be responsible for developing and maintaining mission critical code. The right person will have a proven ability to innovate and demonstrates a solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting. The right fit will embrace the challenge and opportunity of an informal, fast-paced startup environment with a flat organizational structure. What You’ll Do:Ability to write complex stored procedures, functions as well as support/enhance existing code

Ability to 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

Requirements

What We’re Looking For: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

Benefits

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. There’s never been a more exciting time to join our team! Job Type: Full-time

Originally posted on Himalayas