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
Learn more about this Employer on their Career Site
