Data Programmer/Analyst

Escondido, CA

TRI-AD is a total benefits administration firm that serves the unique needs and requirements of mid-market employers. Privately owned for more than 40 years, TRI-AD's hallmark has been the development of long-term and mutually beneficial relationships with our clients and a superior service experience for their plan participants. TRI-AD is not a volume shop or a "cookie cutter" benefits administrator. We partner with organizations that value high-touch service, flexibility and a willingness to adapt our service approach to the needs of our clients...not the other way around. TRI-AD's one-stop approach for all benefits administration needs ensures accountability, streamlined processes, ease-of-use and complete satisfaction for our clients and their plan participants.


Under general supervision, the Data Programmer/Analyst is responsible for the data management exchange function between TRI-AD and its external Clients.  This includes managing file exchanges for new client implementations, changes and ongoing electronic data interchanges.  This position will work with Clients to establish data requirements and program required data formatting specs, validation routines and work flow interchanges.  The Data Programmer/Analyst will also set up secure electronic transmission processes, develop reports, conduct research and troubleshoot data issues and assist with system configuration, testing and data import into various administration systems.  


  • Work with our client’s data management staff to review file specifications and requirements and establish mutually agreed upon detailed file specifications, file formats, and secure transmission processes
  • Implement electronic data exchanges with new clients and with third party partners & vendors
  • Manage ongoing file processing with a book of clients across a variety of service areas and file types
  • Creates reports, both custom and standard, as well as all required architecture, to ensure proper data integrity and transfer to clients and carriers
  • Configure file processing automation for importing and exporting to/from various trading partners and clients 
  • Research data issues and resolve as necessary
  • Work closely with software development team and end users to ensure business needs are being met 
  • Participate in status review and post-deployment review meetings
  • Assist with root cause analysis when necessary
  • Maintain up-to-date technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks and participating in professional associations
  • Participate with Production Support Team to redefine processes to increase efficiencies
  • Will serve a lead EDI role with clients so must be able to manage projects, take initiative and have good communicates skills.  Will be working with cross functional teams working together to serve our business clients
  • While performing the duties of this job, associate is regularly required to use hands and fingers to handle, feel or operate objects, tools or controls, and to reach with hands and arms. Associate is frequently required to stand, talk and hear
  • Lift 20 pounds
  • Additional hours may be required during peak periods


  • Associate’s degree or higher completed in an information technology field (or related field) or equivalent combination of education and experience.  Bachelor degree in information systems is preferred
  • 2 –3 years electronic data interchange (EDI) experience in data intensive environment 
  • Strong SQL server programming skills
  • Experience with SQL Server Reporting Services (SSRS) or other similar report writing tools
  • Experience with VisualCron a plus
  • Experience working in Windows and .Net platform environments
  • Familiarity with XML a plus
  • Substantial exposure to project-based work structures
  • Extremely client focused with responsive attitude and sense of urgency
  • Desire and ability to consistently produce high quality, accurate work
  • Excellent planning and organizational skills
  • Logical thinker, good problem-solving abilities
  • Excellent interpersonal skills and communication skills
  • Experience in the employee benefits industry a plus.
  • Strong knowledge of database structure and theory required
  • Strong knowledge of structured query language (SQL) required
  • Strong analytical skills required


  • Stability -- we've been in business for 44 years
  • Family-owned -- we won't be acquired anytime soon, and have a familial environment
  • Work-life balance -- we know you have interests outside of work, and we want you to have the time to pursue them
  • Massage therapists that come to the office biweekly
  • Salad bar in the office twice a month
  • Company-sponsored events monthly

Jim Reynoso

Director of Human Resources
use your email instead