2,457,899open jobs
150,086companies
315,454added this week
Browse all
Salary
$84k – $119k per year
Location
Hybrid (Mississauga, Canada)
Seniority
Senior · 6+ years exp
Visa
Sponsors visas in Ireland, United States, United Kingdom; no register of this country names it
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 21, 2026. First seen by Alion on Nov 20, 2026. Citi scores A on the Alion truth index.

Overview
Company
Impact
Profile match
Citi is one of the largest banks in the world, tracing its lineage to the City Bank of New York founded in 1812 and taking its modern shape through the 1998 merger that created Citigroup. Its most distinctive asset is a cross-border payments and treasury network unmatched by any competitor, moving trillions of dollars a day for multinational corporations, governments and other banks across roughly ninety countries. Alongside that institutional franchise it runs markets and investment banking, wealth management and a United States personal bank, and has spent recent years simplifying itself by exiting consumer operations across Asia, Europe and Latin America.

The Senior Data Modelling Analyst is responsible for analyzing existing oracle database schemas, data structures, and data flows to identify design gaps and opportunities for modernization. The role drives the redesign and optimization of enterprise data models, supporting application re-architecture and future-state data architecture initiatives. The successful candidate will collaborate with business stakeholders, architects, and development teams to define scalable, maintainable, and efficient data solutions, while ensuring data quality, integrity, and alignment with enterprise standards.

Responsibilities:

  • Analyze existing database schemas, table structures, and data flows to understand current-state architecture and identify design gaps.

  • Redesign and optimize data models to support application modernization and future-state architecture.

  • Create conceptual, logical, and physical data models, data mappings, and lineage documentation.

  • Collaborate with business, architecture, and development teams to define scalable and maintainable data solutions.

  • Support data migration, data quality improvements, and re-architecture initiatives through strong data modelling and SQL expertise.

Recommended Qualifications:

Must Have

  • 6+ years of experience in Data Analysis, Data Engineering, or Data Modelling

  • Strong SQL and database design expertise·

  • Experience analyzing and redesigning complex database schemas

  • Conceptual, Logical, and Physical Data Modelling

  • Data Warehousing, Data Lineage, and Data Mapping

  • Database performance tuning and normalization/denormalization techniques

  • Strong documentation, stakeholder management, and analytical skills

  • Experience with any of the data modelling tools such as ERwin, ER/Studio, or Oracle Data Modeler

Nice to Have

  • Banking or Financial Services domain experience·

  • Application modernization or legacy platform transformation projects·

  • Data Governance and Metadata Management·

  • Basics of Python for data analysis, automation and understanding of Cloud Data Platforms (Snowflake, AWS, Azure)

Education:

  • Bachelor’s degree/University degree or equivalent experience

  • Master’s degree preferred

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:

$120,800.00 - $170,800.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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,457,899 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Remote, many countries
Similar stack
Same company
Mississauga
$55k – $77k per year · Hybrid · Full-Time · 2+ years exp · Mississauga
Python
JavaScript
Java
C#
Java
Maven
DevOps
CI/CD
Git
GitHub
QA
Selenium
Cucumber
Playwright
Apply
Hybrid · Full-Time · Master's Degree · Toronto
Python
SQL
SAS
AI/ML
Time Series
Analytics
Tableau
Alteryx
Cognos
Apply
Remote (Canada) · Full-Time · Toronto
Python
SQL
AI/ML
AI Agents
Apply
$66k – $70k per year · Hybrid · Full-Time · 3+ years exp · Vancouver
Python
SQL
Databases
Databricks
AI/ML
Claude
Prompt Engineering
AI Agents
Gemini
LLM
LLM Guardrails
Analytics
A/B Testing
Apply
Hybrid · Full-Time · 3+ years exp · Mississauga
Assembly
Fortran
MedTech
Verification & Validation
Apply
Remote (likely EAEU) · Full-Time
Python
JavaScript
Analytics
Microsoft Excel
Apply
Remote (LATAM)
SQL
AI/ML
dbt
AI Agents
Machine Learning
Apply
In office · Mississauga
Apply
Hybrid · 6+ years exp · Mississauga
Apply
In office · 5+ years exp · Bachelor's Degree · Mississauga
Apply
$74k – $83k per year · In office · 5+ years exp · Mississauga
Apply
$48k – $69k per year · In office · Full-Time · 3+ years exp · Bachelor's Degree · Mississauga
Apply
See all jobs
This is one of many
2,457,899 more open roles from verified company boards, updated every day.