Back to jobs

Database developer Smartstream TLM SME Senior Engineer

Mississauga Ontario Canada

Live, first seen by us 17 days ago
Pay
$94,300–141,500/yearAnnual period assumed — pay source
Primary Location Full Time Salary Range: $94,300.00 - $141,500.00------------------------------------------------------ Most Relevant Skills
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Time Type: Full time------------------------------------------------------ Primary Location Full Time Salary Range:
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design, develop and implement reconciliation technology solutions

  • Build and support cash, securities and inter-system reconciliation solutions

  • Support application support, production releases and process improvement

  • Contribute to project planning, requirements, testing and implementation

From the employer’s posting
contribute to the design, development, and implementation of technology solutions
Demonstrate hands-on experience building and supporting Cash, Securities, Internal, and Inter-System Reconciliation solutions
Participate in application support, production releases, and process improvement initiatives
Contribute to project planning, requirements analysis, testing, implementation, and stakeholder communication activities

What you’ll bring

All qualifications

Core experience

  • Bachelor’s degree/University degree or equivalent experience
Qualification wording
Bachelor’s degree/University degree or equivalent experience
Education & alternatives
Education: - Bachelor’s degree/University degree or equivalent experience This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
Apply at Citi

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 4, 202617 days ago
Recorded sightings
12
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 17

Similar jobs usually come down between day 6 and day 56.

At Citi, jobs usually come down by about day 14.

From 14,770 similar postings that came down, and 1,636 of Citi’s. Coming down is not always a hire.

Citi is hiring

459 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is steady
  • Takes jobs down quickly
  • 3% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PL/SQL
  • Shell
  • SQL
  • AutoSys
  • Oracle
  • SQL Server
Where the posting names them
- Work with industry-standard reconciliation platforms including SmartStream TLM Premium/TLM Recs, Recon Frontier, and Intellimatch. - Utilize strong technical skills in Oracle PL/SQL, MS SQL Server, Linux, and data analytics/reporting tools to support solution delivery and issue resolution. - Participate in application support, production releases, and process improvement initiatives using tools such as JIRA, DevOps, AutoSys, and Microsoft Office.
- 3+ years’ experience in managing and implementing successful projects - 3+ years’ experience with Oracle SQL and PL/SQL experience: analytical queries, stored procedures, packages, bulk-data processing, query tuning, and execution-plan analysis. - 3+ year experience with Unix/Linux shell scripting experience: batch processing, file handling, scheduling, monitoring, logging, error handling, and recovery.
- 3+ years’ experience with Oracle SQL and PL/SQL experience: analytical queries, stored procedures, packages, bulk-data processing, query tuning, and execution-plan analysis. - 3+ year experience with Unix/Linux shell scripting experience: batch processing, file handling, scheduling, monitoring, logging, error handling, and recovery. - Experience designing, configuring, testing, and optimizing TLM match rules across all applicable matching types.
- Utilize strong technical skills in Oracle PL/SQL, MS SQL Server, Linux, and data analytics/reporting tools to support solution delivery and issue resolution. - Participate in application support, production releases, and process improvement initiatives using tools such as JIRA, DevOps, AutoSys, and Microsoft Office. - Contribute to project planning, requirements analysis, testing, implementation, and stakeholder communication activities.

Your next step

Complete your application on citi.wd5.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities:

  • Support the delivery of Global Reconciliations technology initiatives and partner with business stakeholders to ensure successful project execution.
  • Collaborate with cross-functional teams across technology, operations, and vendor organizations to achieve project objectives.
  • Apply subject matter expertise in reconciliations and contribute to the design, development, and implementation of technology solutions.
  • Demonstrate hands-on experience building and supporting Cash, Securities, Internal, and Inter-System Reconciliation solutions.
  • Leverage knowledge of financial services and business processes to identify and implement effective technology solutions.
  • Work with industry-standard reconciliation platforms including SmartStream TLM Premium/TLM Recs, Recon Frontier, and Intellimatch.
  • Utilize strong technical skills in Oracle PL/SQL, MS SQL Server, Linux, and data analytics/reporting tools to support solution delivery and issue resolution.
  • Participate in application support, production releases, and process improvement initiatives using tools such as JIRA, DevOps, AutoSys, and Microsoft Office.
  • Contribute to project planning, requirements analysis, testing, implementation, and stakeholder communication activities.
  • Operate within Agile/Scrum delivery methodologies and support continuous improvement practices.
  • Demonstrate strong analytical, problem-solving, written, and verbal communication skills.


Recommended Qualifications:

  • 4+ years of relevant experience
  • 3+ years’ experience in managing and implementing successful projects
  • 3+ years’ experience with Oracle SQL and PL/SQL experience: analytical queries, stored procedures, packages, bulk-data processing, query tuning, and execution-plan analysis.
  • 3+ year experience with Unix/Linux shell scripting experience: batch processing, file handling, scheduling, monitoring, logging, error handling, and recovery.
  • Experience designing, configuring, testing, and optimizing TLM match rules across all applicable matching types.
  • Prior experience with TLM WebConnect, TLM View, and TLM Control Process Designer, including custom control-process development.
  • Strong knowledge of TLM backend tables, data structures, and end-to-end data tracing.


Education:

  • Bachelor’s degree/University degree or equivalent experience


This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.


------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Primary Location Full Time Salary Range:

$94,300.00 - $141,500.00

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Automated Processing and AI

We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.

Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.

------------------------------------------------------

This job opening is for an existing job vacancy.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

 

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.

About Citi

People
About 226,000 in 2025.Annual report (SEC Form 10-K)
Company
Listed as C.
H-1B visas
1 approved for new hires in fiscal 2025.US Citizenship and Immigration Services

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Primary Location Full Time Salary Range: $94,300.00 - $141,500.00------------------------------------------------------ Most Relevant Skills
Location & working pattern

Mississauga Ontario Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.