Teklysium offers more than just technical and strategic expertise. We are also focused on creating the technology experiences of tomorrow through cutting-edge innovations and delivering unprecedented service experiences that are faster, smarter and more personalized.

Responsibilities:

Manage the Agency factors production cycle which includes Freddie, Fannie, and Fed data boarding, quality control, Autosys batch jobs monitoring, and report distribution. Long hours are required on the 4th and 25th business days of the month.
Work closely with Research and trading desks to capture requirements and provide ad-hoc mortgage analysis. This includes the construction of SQL queries, calculating prepayment speeds, generating cash-flows, providing loan performance and stratifications.
Construct complex SQL queries to pull data from Sybase and SQL Server database repositories containing over 7 terabytes of data.
Investigate data quality issues and provide remedy expeditiously
Support price/cashflow calculators based on Intex API
Build data tools, OLAP cubes, middle-ware components to facilitate and simplify access to SPDG data.

Required Skills:

Must have worked with Agency (Freddie, Fannie, Ginnie) Pass-through, CMO, and loan level data. Vendors who provide this data include SIAC, eMBS, CPRCDR.COM, and CoreLogic. Will be asked if you know how to calculate CPR and CDRs.
Expertise in C development.
Strong Perl development.
C# Programming
Expertise in Sybase & MS SQL Server is a must. Must have strong data skills. Database optimization is necessary
Unix and Windows expertise is required
Expertise in Intex desktop/Intexcalc and CMOSUBs is a must

NICE TO HAVE

Autosys Scheduling

All your information will be kept confidential according to EEO guidelines.