Job description

Position: Senior SQL Developer/ADF About Us vineyard vines is a highly successful, privately held, American clothing and accessory retailer founded in 1998 on Martha’s Vineyard by brothers, Shep & Ian Murray. With Shep & Ian still at the helm today, vineyard vines has experienced exponential year over year growth and now operates over 125 retail locations including an outlet division, a successful e-commerce business, domestic distribution center, and expanding corporate headquarters. In addition, vineyard vines is also carried in major department stores as well as numerous specialty boutiques across the US. At vineyard vines we pride ourselves on Shep & Ian’s philosophy that “every day should feel this good” and “if you’re doing what you love, you’ll be successful”. Now is an exciting time to join vineyard vines. To keep-up with our growing and evolving business needs, we need smart and talented individuals to join on our crew to help us to drive the good life! About The Position Vineyard Vines is seeking candidates for a Senior SQL Developer/ADF role on our IT team. This role will report to the Vice President, IT Solution Delivery & Support. You will be a key member of our team, responsible for day-to-day operations and support of our PLM (Product Lifecycle Management) Data Hub and all of its interfaces to/from upstream and downstream systems. These interfaces include data flows with our Centric PLM platform for product development, our GX Lynx platform for direct (i.e., Factory) purchase orders and product costing & sizing, our Blue Yonder MMS platform (ERP functionality), our Salesforce Commerce Cloud online digital shopping & selling platform, our BlueCherry wholesale order management platform, our NuOrder online wholesale shopping & selling platform, our Blue Yonder allocations platform and our Databricks/Power BI enterprise business intelligence platform. Going forward there are likely to be additional interfaces added to this important PLM Data Hub as well. You will collaborate closely with cross-functional teams, business stakeholders, and external partners to ensure a smooth, effective and efficient flow of product, purchase order and supplier related data to these critical internal systems. You will also be responsible for solution delivery enhancements for this platform and its interfaces. This will include requirements analysis, design, development, testing and deployment work. What You Bring • Strong experience in Azure SQL Database including developing and maintaining the application • Designing and implementing database schemas, complex stored procedures, functions, views, sequences and triggers using SQL • Optimizing database performance by tuning SQL queries and SQL code • Developing and executing test plans to ensure the quality and accuracy of SQL code • Proven experience in designing, developing, and deploying data integration solutions using Azure Data Factory • Strong understanding of data engineering concepts, ETL principles, and data modeling. • Experience with data integration techniques for both structured and unstructured data. • Experience with Rest API for data integration. • Proficiency in Azure cloud services, including Azure Blob Storage, Azure Service Bus, and Azure Data Factory. • Solid programming skills in languages such as Python and C# Every Day Will Feel This Good Because • We have a fun entrepreneurial culture filled with truly “good” people • We have flexible working hours to accommodate your personal life • We have multiple company outings as we believe spending time with the crew outside of work is part of the good life • We offer a generous employee discount so you can rep our lifestyle on-and-off the boat • We offer a competitive salary package, 401-K, commuter benefits, and paid-family leave • We’ll invest in your career. Our company is continuing to grow and we’ll give you the opportunity to do the same. You’ll have access to a number of professional development opportunities so that you can keep up with the company’s evolving needs. Why Join Us Joining our team presents a unique opportunity to make a significant impact on our company's integration landscape and future vision. You will have the chance to improve our processes for getting the right products to market on time, meeting the dynamic needs of a business provides both core and seasonal variety to meet the needs of our customers. We offer a competitive compensation package, a collaborative work environment, and a commitment to professional growth and development. If you are a motivated and forward-thinking data engineering professional excited about driving change and innovation, we encourage you to apply and be a part of our transformation journey.

Requirements