{bc}
indeed

Senior Data Modeling Analyst

Citi
Mississauga, CAN
Full-time
Senior
Onsite
$120,800–$170,800
Discovered Today
Data analysis, engineering, or modelingSQLDatabase designDatabase schema analysis and redesignConceptual, logical, and physical data modelingData warehousing

Full Job Posting

Job overview

Senior data modeling analyst role focused on database schema analysis, enterprise data model redesign, and modernization.

The role supports application re-architecture and future-state data architecture, collaborating with business stakeholders, architects, and development teams.

Citi states the role is full time.

Responsibilities

  • Analyze database schemas, table structures, and data flows to identify current-state design gaps.
  • Redesign and optimize data models for 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 on scalable, maintainable data solutions.
  • Support data migration, data quality improvements, and re-architecture initiatives.

Must-have qualifications

  • At least 6 years of experience in data analysis, data engineering, or data modeling.
  • Strong SQL and database design expertise; experience analyzing and redesigning complex database schemas.
  • Conceptual, logical, and physical data modeling; data warehousing, lineage, and mapping.
  • Database performance tuning and normalization or denormalization techniques.
  • Strong documentation, stakeholder management, and analytical skills.
  • Experience with ERwin, ER/Studio, or Oracle Data Modeler.

Preferred qualifications

  • Banking or financial services experience; application modernization or legacy platform transformation experience.
  • Data governance and metadata management; basic Python and familiarity with Snowflake, AWS, or Azure.
  • Master’s degree preferred.

Education

  • Bachelor’s degree or university degree, or equivalent experience.
  • Master’s degree preferred.

Salary

  • Primary location full-time salary range listed as $120,800–$170,800; cadence is not explicitly stated.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Citi