Who we'd reach at CitiFound and reached by Power Apply
Best leadTeam lead
Runs the team day to day
Recruiter
In-house, owns the opening
Recent hire
Joined the team recently
From your own Gmail and LinkedIn.
About the role
This is a senior data modeling role at Citi for an analyst with six or more years of experience in data analysis, engineering or modeling, based in Mississauga, Ontario. The work focuses on redesigning Oracle database schemas and data models to support application modernization. The role works with business, architecture and development teams on future-state data architecture.
What you’ll do
- Analyze existing database schemas, table structures and data flows to find design gaps.
- Redesign and optimize data models to support application modernization.
- Create conceptual, logical and physical data models, data mappings and lineage documentation.
- Work with business, architecture and development teams to define scalable data solutions.
- Support data migration, data quality improvements and re-architecture work.
What they’re looking for
- At least 6 years of experience in data analysis, data engineering or data modeling.
- Strong SQL and database design skills.
- Experience analyzing and redesigning complex database schemas.
- Conceptual, logical and physical data modeling experience.
- Experience with data warehousing, data lineage and data mapping.
- Skill in database performance tuning and normalization or denormalization.
- Strong documentation, stakeholder management and analytical skills.
- Experience with a data modeling tool such as ERwin, ER/Studio or Oracle Data Modeler.
Nice to have
- Banking or financial services domain experience.
- Application modernization or legacy platform transformation experience.
- Data governance and metadata management experience.
- Basic Python for data analysis and automation.
- Understanding of cloud data platforms such as Snowflake, AWS or Azure.
What’s on offer
- Salary range of $120,800 to $170,800 per year, in CAD.
Skills
SQLData ModelingOracleData WarehousingData LineageData MappingDatabase Performance TuningERwinER/StudioOracle Data ModelerPythonSnowflakeAWSAzureData Governance
Questions about this role
How much does this role pay?
The posted salary range is $120,800 to $170,800 per year in CAD.
How many years of experience do I need?
The posting requires at least 6 years of experience in data analysis, data engineering or data modeling.
Do I need a degree?
A bachelor's degree or equivalent experience is listed, and a master's degree is preferred.