Remote SQL Developer responsible for developing and maintaining critical SQL code, schemas, ETL pipelines, and data transformations. Tasks include writing complex stored procedures, schema/index design, query tuning, backup/restore, processing varied source formats, validating data, supporting stakeholders, and contributing to data engineering tooling and deployment practices in an agile startup environment.
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
Similar Jobs
eCommerce • Software
Lead a distributed SQL team and own the end-to-end service model for custom analytics: intake, scoping, delivery, QA, documentation, and SLAs. Serve as a customer-facing technical lead, build scalable workflows and request taxonomy, partner cross-functionally, and balance customer delivery with internal platform priorities.
Top Skills:
BigQueryClickhouseGoogleHubspotJIRAKlaviyoLlmsMetaMobyPythonShopifySlackSQLTiktok
Artificial Intelligence • Information Technology • Consulting • Big Data Analytics
The Domo Developer will design and implement data analytics solutions using Domo, Power BI, SQL, and Snowflake, lead a team, and optimize data models and dashboards.
Top Skills:
DomoPower BISnowflakeSQL
Software
The role involves designing and implementing scalable backend services using Node.js and AWS, ensuring data integrity through SQL, optimizing system performance, and collaborating effectively with cross-functional teams in an agile environment.
Top Skills:
Api GatewayArchimateAws LambdaCi/CdDockerDynamoDBKubernetesNode.jsObject-Relational MappersOwaspRdsSQLUml
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
