Runs the team day to day
In-house, owns the opening
Joined the team recently
From your own Gmail and LinkedIn.
About the role
This is a senior, full-time hybrid role in Mississauga, Ontario, Canada, for analysts with at least six years of experience in data analysis, data engineering or data modeling. The job centers on examining existing Oracle database schemas and data flows, finding design gaps, and redesigning enterprise data models to support application modernization. You would work with business stakeholders, architects and development teams to define scalable, maintainable data solutions.
What you’ll do
- Analyze current database schemas, table structures and data flows to find design gaps.
- Redesign and tune data models to support application modernization and future-state architecture.
- Produce conceptual, logical and physical data models, data mappings and lineage documentation.
- Partner with business, architecture and development teams to define data solutions.
- Support data migration, data quality work and re-architecture initiatives.
What they’re looking for
- At least 6 years 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, with data warehousing, lineage and mapping.
- Database performance tuning, and normalization and denormalization techniques.
- Strong documentation, stakeholder management and analytical skills.
- Experience with a data modeling tool such as ERwin, ER/Studio or Oracle Data Modeler.
- A bachelor's degree or equivalent experience. A master's degree is preferred.
Nice to have
- Banking or financial services domain experience.
- Application modernization or legacy platform transformation work.
- Data governance and metadata management.
- Basic Python for analysis and automation, and familiarity with cloud data platforms such as Snowflake, AWS or Azure.
What’s on offer
- Base salary range of CAD 120,800 to 170,800 per year.
- Hybrid working arrangement.
- Citi global benefits program referenced in the listing.
Skills
Questions about this role
Is this role hybrid?
Yes. The listing is hybrid and based in Mississauga, Ontario, Canada.
How much does it pay?
The salary range is CAD 120,800 to 170,800 per year.
How many years of experience do I need?
At least six years in data analysis, data engineering or data modeling.
Do I need a degree?
A bachelor's degree or equivalent experience is required, and a master's is preferred.