Back to Job Search

SQL Programmer Analyst

  • Location: Fort Worth, 76177
  • Salary: 55.0
  • Job Type:Contract

Posted about 1 month ago

Very large 3PL (3rd Party Logistics) company and transportation management leader, is hiring a SQL Programmer Analyst for a 6-12 month contract role to diagnose, troubleshoot, and resolve some issues within the database and data coming from multiple sources to the Transportation Management Systems (TMS). Will work 100% remote for the entire length of this fulltime contract engagement  (Monday-Friday, 8:00 AM - 5:00 PM, somewhat flexible).  Must have excellent communication skills and the ability to do deep analysis and troubleshooting.

RESPONSIBILITIES

As the SQL Programmer Analyst on this team, you will troubleshoot and resolve issues within Transportation Management Systems (Freight) and applications.  You will be supporting and identifying root cause analysis and resolution of two separate issues regarding customer visibility to GPS pings and Geotab messages within a large transportation management system (TMS). These solutions utilize multiple systems so it is important this person can follow the data through the systems, start to finish in chronological order and pinpoint where the issues or gaps are occurring within the system causing the loss of GPS visibility of freight moving across the country. 

REQUIRED SKILLS

  • Must have the ability to work within Multiple applications.
  • Must have very strong SQL and SSIS experience to look up the output data as well as ability to read procedural language.
  • Data Collection and Analysis across multiple interfaces.
  • Experience working with the following Data Sources:
    • Databases
    • Interface files
    • Spreadsheets
    • Process Flow Diagrams (Visio)
    • Able to understand business process
  • Read and understand T-SQL
  • Write SQL queries to provide to report builders
  • Power BI Experience
  • SQL Server Management Studio
  • Read and Understand JSON formatting
  • Read and understand XML
  • Azure Exposure
  • Excel
  • Visio
  • Strong Data Analysis skill set
  • Strong Troubleshooting skill set
  • Report Writing
  • Effective communication both internal and external
  • Ability to Identify where gaps are and why data feeds are failing
PREFERRED SKILLS
  • Good understanding of the Transportation Management (Freight) Industry
  • Transportation / GPS Coordinates
  • Freight Verify / GEO Tab Messages