PURPOSE:<br><br>As an expert in systems software engineering, undertakes complex projects requiring specialized technical knowledge. Makes well‑thought‑out decisions on complex or ambiguous engineering issues, handles conflicting direction, and resolves conflict. Ensures that system improvements are successfully implemented and monitored to increase efficiency. Makes complex modifications to existing software to fit specialized needs and configurations. Establishes and communicates common goals and direction for the team. Acts as a source of direction, training, and guidance for less experienced staff. Monitors project schedules and costs. Plans, conducts, and supervises assignments. Reviews progress and evaluates results. Recommends changes in procedures. Reviews progress with management. Operates with substantial latitude for unreviewed action or decision.<br><br>JOB RESPONSIBILITIES:<br><br>Possesses and applies comprehensive knowledge of the field of specialization to the completion of complex assignments; may cross fields.<br><br>Maintains excellent business communication with Analysts, Business Owners, and Technical Staff.<br><br>Provides analysts, management, and business owners/users with status reports, problem logs (issue logs), and service request status on all tasks in the work group. Oversees time spent by others in the work group.<br><br>Evaluates alternative approaches in design of application systems, including assessment of risks and benefits associated with each alternative.<br><br>Participates in the implementation of new systems including the integration of the new system; verifies installed systems to ensure that they adequately meet user requirements.<br><br>Plans, conducts, and supervises others in the development of specifications, coding of new programs, physical design of data records, data files, and databases; creates new data structures and job streams; and modifies existing programs, data structures, and job streams.<br><br>Plans, conducts, and supervises others in the development of test cases and test plans; creates unit and system test environments and conducts unit and system tests for new or modified programs and job streams.<br><br>Submits program and design work for review by technical and user staff and leads review of others’ work; validates the application of sound analysis, programming, and design techniques with high proficiency.<br><br>Oversees preparation and maintenance of program and system documentation using established department artifact standards and methodologies; mentors junior associates in proper documentation techniques.<br><br>Adheres to department standards, guidelines, and systems development methodologies for all assigned tasks and mentors others in their use.<br><br>Leads analysis and development of technical solutions to resolve problems; includes and guides other team members in problem‑solving activities.<br><br>Understands project management methodology and leads resource planning, estimation, and responsibility assignment process.<br><br>Designs, develops, and optimizes complex T‑SQL stored procedures, functions, indexes, views, and ETL routines in Microsoft SQL Server for high‑volume transactional and reporting workloads; implements query tuning, indexing strategies, and execution‑plan analysis to meet SLAs.<br><br>Builds Python services, scripts, and automation to support integrations, data pipelines, quality checks, and operational tooling; applies packaging, virtual environments, and unit testing to ensure maintainability and reliability.<br><br>Creates, documents, and tests RESTful integrations using Postman collections and environments; automates collection runs for regression testing and CI pipelines and publishes living API documentation for consumers.<br><br>Implements and supports Enterprise Transportation Management System (TMS) integrations and configurations—covering order tendering, routing/planning, shipment execution, EDI (204/214/990/997, etc.), freight audit & pay, and carrier onboarding—ensuring data integrity across ERP/WMS and partner networks.<br><br>Collaborates with DBAs, Integration, and Transportation Operations to triage production issues, perform root‑cause analysis, and execute corrective actions without disrupting DC/transportation operations.<br><br>JOB REQUIREMENTS:<br><br>Education/Certification:<br><br>Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field preferred; equivalent experience considered.<br><br>Experience:<br><br>6–8 years relevant software engineering experience preferred, including ownership of production systems.<br><br>3+ years hands‑on Microsoft SQL Server development (T‑SQL, performance tuning, indexing, query plan analysis).<br><br>3+ years professional Python development for services, data pipelines, or automation.<br><br>2+ years building and testing REST APIs; 1+ year using Postman for manual and automated API testing.<br><br>2+ years implementing or supporting Enterprise TMS platforms (e.g., Blue Yonder, Manhattan, Oracle, SAP TM, MercuryGate) and integrating with ERP/WMS and carrier/EDI networks.<br><br>Knowledge:<br><br>Expertise in at least one programming language and strong proficiency in a second; able to mentor others and teach best practices.<br><br>Deep knowledge of Microsoft SQL Server, including database design, normalization/denormalization strategies, transaction isolation, locking behavior, and performance diagnostics (DMVs, Query Store, Extended Events).<br><br>Solid Python language fundamentals (packaging, venv/conda, logging, typing, testing) and common libraries for services and data work (e.g., requests, pandas, FastAPI/Flask where applicable).<br><br>Understanding of REST API design principles (resource modeling, versioning, idempotency, pagination) and API documentation standards (OpenAPI/Swagger).<br><br>Proficiency with Postman collections/environments, pre‑request/test scripts, Newman CLI, and CI integration for automated API regression testing.<br><br>Transportation and logistics domain concepts: order lifecycle, routing & planning, tendering, appointment scheduling, EDI transaction sets (204/210/214/990/997), shipment status events, freight audit & pay.<br><br>Integration patterns for TMS↔WMS/ERP (files, APIs, message queues), data validation, and operational monitoring/alerting.<br><br>Strong computer skills and proficiency with Microsoft Office applications.<br><br>Expert knowledge of program design, coding, testing, and documentation.<br><br>Skills/Abilities:<br><br>Excellent written and verbal communication; strong customer focus; effective with geographically dispersed teams.<br><br>Ability to manage competing priorities and deliver within agreed timelines.<br><br>Analytical and conceptual skills to define technical needs and solve complex problems.<br><br>Hands‑on debugging and performance tuning across application, database, and integration layers.<br><br>Creation of high‑quality technical artifacts: ERDs, sequence/flow diagrams, API specs, runbooks, and test plans.<br><br>Familiarity with source control (Git), CI/CD practices, and environment promotion.<br><br>PHYSICAL ENVIRONMENT / DEMANDS:<br><br>Some travel may be required.<br><br>Most work is performed in a temperature‑controlled office environment.<br><br>Incumbent may sit for long periods of time at desk or computer terminal.<br><br>While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.<br><br>Incumbent may use calculators, keyboards, telephone, and other office equipment in the course of normal workday.<br><br>Stooping, bending, twisting, and reaching may be required in completion of job duties.<br><br>The above statements are intended to describe the general nature of the work performed by the employees assigned to this job. All employees must comply with Company policy and applicable laws. The responsibilities, duties, and skills required of personnel so classified may vary within each department and/or location.<br><br>UNFI is an Equal Opportunity employer committed to creating an inclusive and respectful environment for all. All qualified applicants will receive equal consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity or expression, national origin, disability, protected veteran status, or other protected ground. Accommodation is available upon request for candidates taking part in all aspects of the job selection process. - M/F/Veteran/Disability. VEVRAA Federal Contractor.<br><br><strong>Compensation:<br><br></strong>UNFI anticipates paying the above-referenced pay rate (or within the above-referenced pay range) for this position. Actual Pay, where applicable, will depend on a number of factors, including, but not limited to, education, experience, training, and any requirements under applicable collective bargaining agreements. UNFI is committed to transparency in pay in compliance with applicable state and local laws.<br><br><strong>Benefits:<br><br></strong>For Washington positions (or positions that may be performed remotely from Washington), for Washington-specific paid time off details.<br><br>Candidates hired into this position will also be eligible to participate in the following benefits programs: Paid Time Off; Sick Time; paid holidays and parental leave; 401K Program; medical, dental, vision, life, and accidental death/dismemberment insurance; short-term and long-term disability insurance program, Flexible Spending Account and/or Health Savings Account, subject to meeting the eligibility requirements and the terms and conditions of these programs, and subject to any requirements under applicable collective bargaining agreements.<br><br>UNFI’s compensation, benefits, and paid time off policies are subject to change in the Company’s sole discretion, consistent with applicable law. This job posting should not be construed as an offer of employment with certain terms, nor should it be construed as a guaranteed minimum.<br><br>Qualified applications with arrest or conviction records will be considered for employment in accordance with the <em>Los Angeles County Fair Chance Ordinance</em> and the <em>California Fair Chance Act</em>.