Systems Analyst

About This Opportunity

CTI Staffing is partnering with a leading financial services organization to find a Data Conversion Systems Analyst for their retirement/defined contribution conversion team based in Smithfield, RI.

This team is responsible for onboarding incoming retirement plan data — taking external records from new plan sponsors and accurately mapping them into the organization's internal systems. It's detail-intensive, high-accountability work that sits at the intersection of data analysis and the retirement/investment domain, partnering closely with on-shore and off-shore development teams to deliver conversions on time and on budget.

What You'll Do

• Receive inbound external data records and create the technical conversion specifications that map them to internal system formats
  
• Serve as the primary liaison and advocate for on-shore and off-shore developers throughout each conversion
  
• Contribute technical detail to conversion strategy documents that augment business requirements
  
• Support the accurate creation, validation, and loading of data into production systems
  
• Provide systems support and mentorship to the broader project team
  
• Manage multiple concurrent conversion projects against timeline and budget goals
  
• Troubleshoot data feeds and resolve conversion issues end to end
  
• Own the quality and accuracy of your deliverables under senior mentorship
  

Requirements

What You Bring

Must-Have:

• 3+ years demonstrable experience with data conversion implementation — analysis, design, mapping, problem resolution, and planning
  
• Hands-on experience building data mapping specifications between external sources and a target system
  
• Background in Financial Services, Banking, 401(k), Defined Contribution, Mixed Election, or Retirement funds
  
• Specialist-level Microsoft Excel, with a solid grasp of Word and Access
  
• Strong analytical and troubleshooting skills across multi-source data feeds
  
• Ability to manage multiple concurrent projects with full accountability for deliverables
  

Nice-to-Have:

• Experience with data transmission protocols (SFTP, TSO, etc.)
  
• Solid grasp of the investment industry
  
• SQL and relational database experience
  
• Experience with EDI transaction sets (e.g., ANSI X12 834) and file formats (flat file, CSV, fixed width)
  
• Bachelor's degree
  

Technical Environment:

• Microsoft Excel, Word, Access
  
• SQL / relational databases
  
• Data transmission protocols (SFTP, TSO)
  
• Conversion mapping and data-comparison tooling
  

What Success Looks Like:

• Running multiple concurrent conversions independently within the first 3–6 months
  
• Producing clean, accurate mapping specs that load right the first time
  
• Becoming a trusted liaison between business and on/off-shore development teams