PURPOSE:
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.

JOB RESPONSIBILITIES:
Possesses and applies comprehensive knowledge of the field of specialization to the completion of complex assignments; may cross fields.
Maintains excellent business communication with Analysts, Business Owners, and Technical Staff.
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.
Evaluates alternative approaches in design of application systems, including assessment of risks and benefits associated with each alternative.
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.
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.
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.
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.
Oversees preparation and maintenance of program and system documentation using established department artifact standards and methodologies; mentors junior associates in proper documentation techniques.
Adheres to department standards, guidelines, and systems development methodologies for all assigned tasks and mentors others in their use.
Leads analysis and development of technical solutions to resolve problems; includes and guides other team members in problem‑solving activities.
Understands project management methodology and leads resource planning, estimation, and responsibility assignment process.
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.
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.
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.
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.
Collaborates with DBAs, Integration, and Transportation Operations to triage production issues, perform root‑cause analysis, and execute corrective actions without disrupting DC/transportation operations.

JOB REQUIREMENTS:
Education/Certification:
Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field preferred; equivalent experience considered.

Experience:
6–8 years relevant software engineering experience preferred, including ownership of production systems.
3+ years hands‑on Microsoft SQL Server development (T‑SQL, performance tuning, indexing, query plan analysis).
3+ years professional Python development for services, data pipelines, or automation.
2+ years building and testing REST APIs; 1+ year using Postman for manual and automated API testing.
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.

Knowledge:
Expertise in at least one programming language and strong proficiency in a second; able to mentor others and teach best practices.
Deep knowledge of Microsoft SQL Server, including database design, normalization/denormalization strategies, transaction isolation, locking behavior, and performance diagnostics (DMVs, Query Store, Extended Events).
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).
Understanding of REST API design principles (resource modeling, versioning, idempotency, pagination) and API documentation standards (OpenAPI/Swagger).
Proficiency with Postman collections/environments, pre‑request/test scripts, Newman CLI, and CI integration for automated API regression testing.
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.
Integration patterns for TMS↔WMS/ERP (files, APIs, message queues), data validation, and operational monitoring/alerting.
Strong computer skills and proficiency with Microsoft Office applications.
Expert knowledge of program design, coding, testing, and documentation.

Skills/Abilities:
Excellent written and verbal communication; strong customer focus; effective with geographically dispersed teams.
Ability to manage competing priorities and deliver within agreed timelines.
Analytical and conceptual skills to define technical needs and solve complex problems.
Hands‑on debugging and performance tuning across application, database, and integration layers.
Creation of high‑quality technical artifacts: ERDs, sequence/flow diagrams, API specs, runbooks, and test plans.
Familiarity with source control (Git), CI/CD practices, and environment promotion.

PHYSICAL ENVIRONMENT / DEMANDS:
Some travel may be required.
Most work is performed in a temperature‑controlled office environment.
Incumbent may sit for long periods of time at desk or computer terminal.
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.
Incumbent may use calculators, keyboards, telephone, and other office equipment in the course of normal workday.
Stooping, bending, twisting, and reaching may be required in completion of job duties.

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.