At a Glance
- Tasks: Design and implement cutting-edge reconciliation solutions using SmartStream TLM Premium.
- Company: Join a leading firm in Capital Markets with a focus on innovation.
- Benefits: Long-term contract, competitive pay, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on Agile methodologies and DevOps practices.
- Why this job: Be part of a high-performing team transforming reconciliation processes across the industry.
- Qualifications: Experience with SmartStream TLM and strong SQL skills required.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced TLM Consultant / Developer with deep expertise in Transaction Lifecycle Management (TLM) and Reconciliation platforms, specifically SmartStream TLM Premium 2.5 or higher. This role requires a strong technical consultant with extensive hands-on experience designing, developing, implementing, and supporting complex reconciliation solutions across Capital Markets environments. The successful candidate will play a critical role in delivering enterprise-grade reconciliation controls and automation solutions across multiple business functions and asset classes.
The ideal candidate will possess strong functional and technical knowledge of reconciliation processes including Nostro, Depot, Intercompany, Intersystem, FOBO, FOCL, Cash & Position reconciliations, alongside excellent Oracle SQL and Unix scripting expertise. This is a long-term programme within a high-performing delivery environment supporting strategic reconciliation transformation initiatives.
Key Responsibilities- Design, develop, configure, test, and deploy reconciliation solutions using SmartStream TLM Premium 2.5+
- Build and support sophisticated reconciliation controls across Capital Markets products and trade lifecycle events
- Work extensively with: SmartStudio, SmartSchema, Recon Admin, WebConnect, Control & CT tools
- Configure and support: Cash Reconciliations, Position Reconciliations, FOBO / FOCL reconciliations, Nostro reconciliations, Inter-system and Intercompany reconciliations
- Analyse business requirements and translate them into scalable TLM reconciliation solutions
- Develop complex SQL scripts, stored procedures, functions, triggers, and database objects within Oracle environments
- Perform backend analysis of TLM database table linkages for production issue investigation and resolution
- Automate exception management and break allocation processes within the TLM platform
- Conduct Unit Testing, SIT, UAT support, and production deployments
- Support production environments including incident management, root cause analysis, and issue remediation
- Monitor and troubleshoot TLM services, logs, interfaces, and batch processes
- Work closely with Operations, Finance, Middle Office, Technology, and Business stakeholders
- Participate in Agile delivery methodologies and DevOps-driven release cycles
- Contribute to process improvement and reconciliation optimisation initiatives
- Strong Mandatory Experience In: SmartStream TLM Premium 2.5 or higher, Transaction Lifecycle Management (TLM) Reconciliation solutions, End-to-end reconciliation build and implementation experience, Capital Markets reconciliation processes and controls, Exception management and reconciliation break automation, Oracle SQL and PL/SQL development, Unix / Linux shell scripting, Production support within mission-critical reconciliation environments
- SmartStream TLM Expertise
- Strong hands-on experience with: SmartStudio, SmartSchema, Recon Admin, WebConnect, Control & CT tools, TLM services configuration and troubleshooting, TLM database structures and table relationships, Reconciliation workflow configuration, Break management and matching rules, Reconciliation reporting and MI generation
- Database & SQL: Advanced Oracle SQL and PL/SQL, Stored procedures, Functions and triggers, Query optimisation and performance tuning, Complex joins and analytical SQL queries, Database troubleshooting and profiling, Oracle backup and recovery understanding
- Unix / Linux: Strong Unix/Linux administration exposure, Shell scripting (Bash/Korn Shell), Solaris/Linux environments, Log analysis and troubleshooting, Batch job monitoring, Vi editor proficiency, Server and application support understanding
- Strong understanding of: Capital Markets operations, Trade lifecycle management, Front-to-Back reconciliation processes, Cash and Position reconciliation controls, FOBO / FOCL processes, Settlement and accounting controls, Operational risk reduction through reconciliation automation
- Experience across asset classes including: Equities, Fixed Income, FX, Derivatives, Money Markets
- Any experience with the following would be advantageous: DevOps tooling (GitHub, Jenkins, CI/CD pipelines), Jira / Confluence, Reporting tools: BIRT, Crystal Reports, SAP BO, QlikView / QlikSense, Cloud technologies (preferably GCP), Python or Java development, VBScript / Perl / PowerShell scripting
TLM Consultant in Sheffield employer: Coltech
As a TLM Consultant at our Sheffield location, you will join a dynamic team dedicated to delivering innovative reconciliation solutions within a high-performing environment. We pride ourselves on fostering a collaborative work culture that encourages professional growth and development, offering extensive training opportunities and the chance to work on cutting-edge projects in Capital Markets. With a focus on employee well-being and a commitment to excellence, we provide a supportive atmosphere where your contributions are valued and recognised.
StudySmarter Expert Advice🤫
We think this is how you could land TLM Consultant in Sheffield
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join relevant online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio or a GitHub repository showcasing your projects related to TLM and reconciliation solutions. This gives potential employers a tangible look at what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common questions related to SmartStream TLM and reconciliation processes. Practice articulating your experience with SQL and Unix scripting, as these are key skills they'll be looking for.
✨Tip Number 4
Don't forget to apply through our website! We often have exclusive listings and it’s a great way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our team!
We think you need these skills to ace TLM Consultant in Sheffield
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to highlight your experience with SmartStream TLM Premium and reconciliation processes. We want to see how your skills match the job description, so don’t hold back on showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the TLM Consultant role. Share specific examples of your past work with TLM solutions and how you’ve tackled challenges in Capital Markets.
Show Off Your Technical Skills:Don’t forget to emphasise your technical expertise in Oracle SQL, Unix scripting, and any other relevant tools mentioned in the job description. We love seeing candidates who can demonstrate their hands-on experience with these technologies!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved!
How to prepare for a job interview at Coltech
✨Know Your TLM Inside Out
Make sure you brush up on your knowledge of SmartStream TLM Premium, especially version 2.5 or higher. Be ready to discuss your hands-on experience with reconciliation processes and how you've implemented solutions in Capital Markets environments.
✨Showcase Your Technical Skills
Prepare to demonstrate your Oracle SQL and Unix scripting expertise. Have examples ready where you've developed complex SQL scripts or automated reconciliation processes, as this will highlight your technical prowess.
✨Understand the Business Context
Familiarise yourself with the specific reconciliation processes mentioned in the job description, like Nostro and FOBO reconciliations. Being able to relate your technical skills to business outcomes will set you apart from other candidates.
✨Be Agile and Collaborative
Since the role involves working closely with various stakeholders and participating in Agile methodologies, be prepared to discuss your experience in collaborative environments. Share examples of how you've contributed to process improvements or worked within DevOps-driven cycles.
