Systems Analyst

CTI Consulting • Smithfield, RI

20d • Onsite

About The Position

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.

Requirements

• 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 Haves

• 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

Responsibilities

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level