Position Title: SQL Developer-Analyst The SQL Server Developer-Analyst will play a key role in the development and support of SQL Server (T-SQL) related development projects and application support related issues. The individual will be reporting to the Director – Technical solutions and will be working from our Atlanta (John’s Creek), GA IT office (at least 2-days a week). Team Overview The Distribution Systems – Technical Solutions Development (DEV) team’s mission is to enable our distribution capabilities and drive client engagement through technology, information design, and process improvements that deliver our products, services, and brand promise to customers and prospects. More specifically the DEV team drives the vision, strategic development, implementation, and on-going support of Distribution Systems (Manhattan SCALE WMS) and associated applications / tools across businesses and regions. This team also manages client information (MS SQL Server) and reporting. Role Responsibilities Create, maintain, optimize SQL Server objects (Tables, Views, Stored Procedures, Triggers, Scheduled Jobs etc.) and ETL processes. Work with all levels of development from analysis through implementation and support. Resolve end user reported issues through collaboration with IT and Operations. Participate in project meetings, providing input to project plans and providing status updates. Analyze Database structures and relationship of the Manhattan SCALE system (Warehouse/Distribution, Trading Partner, Billing, Labor management system) to establish knowledge of data for accurate retrieval and use in T-SQL queries. Guidance will be provided to learn and understand the Manhattan SCALE system. Writing and maintaining technical documentation based on business and functional requirements. Collaborate with Other IT team members/end users to understand/gather requirements and ensure proper testing and validation. Work Conditions Minimal travel when new warehouses or major client implementations go live (<10%). Small office environment with 10-15 other IT team members. Sitting for extended periods of time. Dexterity of hands and fingers to operate a computer keyboard, mouse, and to handle other computer components. Lifting and transporting of moderately heavy objects, such as computers and peripherals. Need to be based after hours, weekends, and on-call support of new/major implementations. Benefits: When you join ID Logistics, you become part of a company committed to Investing in our Employees. This commitment is the foundation for the ID Logistics benefits program. As an Employer of Choice, ID Logistics invests in you by providing a comprehensive benefits program that offers a valuable, affordable benefit plan package that includes medical, dental, vision, employer paid life insurance, 401(k) with employer match, generous paid time off along with other supplemental benefits. Medical, Dental, Vision (1 day of the next month of hire) (Options available) 401K with matching program STD, LTD Vacation and sick time Friendly and Open-Door culture Safety of our associates has always been Our #1 priority. We are aggressively responding to COVID-19: Take temperatures with a no-touch thermometer at the start of the shift Increased cleaning routines and periodically deep clean Provide associates with appropriate PPE Maintain an ample supply of antibacterial lotion throughout the building Practice social distancing Expect our associates to maintain cleanliness, social distancing, and use PPE Required Skills 3 years of working experience in general database development using MS-SQL Server. Focus will be on writing optimal T-SQL queries, stored procedures, views, reading query plans, tuning indexes and troubleshooting issues. Good problem solving, analytical and communication abilities Ability to focus on development & design details and quality verification. Ability to work on tasks across various fast-paced projects. Ability to take responsibility for all work activities and personal actions Ability to seek clarification/guidance (functionality/requirements/priority) from senior team members/managers BA/BS in Computer Science or related field Additional Skills Experience with MS SSRS Experience with MS SSIS Experience with BI tools such as Tableau, Power BI etc. Knowledge of Distribution/Warehousing and Transportation will be a plus Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled