Senior Data Modeling Analyst
$120.8k - $170.8k per yearCitigroup
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.
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)
- Bachelor’s degree/University degree or equivalent experience
- Master’s degree preferred
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’sEEO Policy Statement and the Know Your Rights poster.- ...looking for a Service Transition Analyst, Contact Centre to help define the target operating model and service transition for a... ...the Lead; assemble and validate data for the Lead's run-cost and resourcing... ...in live working sessions with senior stakeholders in the room....SeniorInternshipWork at officeRemote workRelocation2 days per week
$110.19k - $194.38k per year
...Description Position Summary The CX Intelligence Analyst transforms customer feedback, operational data, and business information into actionable insights... ...customer experience across multiple data sources and models. Design, develop, and maintain dashboards, scorecards...SuggestedFull timeRemote workShift work$60k - $75k per year
...Job Title : Customer Relation Data Analyst Location : Mississauga, ON Job Purpose: The Customer Relation Data Analyst is responsible for maintaining the accuracy and integrity of customer data, analyzing customer performance metrics, and providing actionable insights...SuggestedLong term contract$75.3k - $122.76k per year
...looking for a dynamic Financial Reporting, Senior Analyst to join our Team. In this role, the... ...entity-based and/or consolidated Financial Data/Statements Lead role in planning and executing... ...Excel skills (e.g. complex formulas, modeling, data analysis) required Strong...SeniorHourly pay- ...your team, we go there for you. Description The Senior Financial Analyst position is a collaborative role that will be aligned to a... ...projects, may include building detailed multi-year financial models of costs and benefits Work with the project team to...SeniorLong term contractWork at office
- ...Become a maker of possible with us. The Senior Financial Analyst plays an essential role in growing... ...for the business unit. Revenue and GP modeling - Work with Finance Business Manager... ...owners on their spending and outlook. Data submission - Data submission with quick...SeniorFull timeWork at officeLocal areaRemote workWorldwideShift work
- ...Zimmer Biomet seeks a Master Data Governance Lead Analyst to oversee day-to-day operations of SAP Master Data Governance across Material, Customer,... ...Material Master domain ~ Strong knowledge of SAP MDG data model, governance processes, and lifecycle management ~ Ability...
$93.5k - $110k per year
...future of financial empowerment. The Senior Financial Analyst is responsible for supporting the... ...processes through financial analysis and modeling. Calculate and analyze costs... ...reporting accuracy, controls, efficiency, and data integrity. Develop and maintain...SeniorWork at officeFlexible hours3 days per week- ...Citi's transformation. The Lead Business Analyst is an intermediate level role responsible for performing moderate to complex data analytics, reporting and process automation.... ...analytics, visualizations, and reports for senior management and the Board. Synthesize and...SeniorFull time
- ...We are looking for a Senior Data Architect to design the end-to-end data platform for APEX. The platform ingests contact centre telephony and... ..., data integrity standards, and the Gold-layer dimensional model. You will also partner with the existing CCARS pipeline team through...SeniorHourly payInternshipWork at officeRemote workRelocation2 days per week
$94.3k - $141.5k per year
...progress together. About the Team: The Senior Data Engineer is a strategic professional at... ...technology, applications development, and model development activities. Monitor and control... ..., and advise or coach new or lower-level analysts. Operate with a limited level of...SeniorFull time- ...Description Candu Energy Inc. is looking for a Senior Fuel Engineering Analyst to be a part of our team in the Fuel... ...in developing finite element models and performing stress analysis Excellent... ...organization. We connect people, data and technology to transform the world'...SeniorFull timeInternshipWork at officeRemote workFlexible hours
$55.5k - $120k per year
...profiles of clients within the portfolio. Utilizes financial models and analytical tools to assess client repayment capacity and recommend... ...returns on a proactive basis. Manages timely and accurate data entry into BMO's systems and leverages the data to support decision...SeniorLong term contractPermanent employmentFull timeContract workPart timeWork at officeWorldwide- ...go there for you. Description The Senior Manager, Data Services & Platform is a newly... ...observability, and testability Define data modelling standards in conceptual, logical, physical... ...(DP-600) and/or Power BI Data Analyst Associate (PL-300) Familiarity with Ataccama...SeniorWork at office
$94.3k - $141.5k per year
...The Senior Development Engineer in Test is a developing professional role. Deals with most problems independently and has some latitude... ...subfunction/ job family. Applies analytical thinking and knowledge of data analysis tools and methodologies. Requires attention to detail...SeniorFull time$90k per year
...Senior IT Analyst About Bothwell-Accurate Bothwell-Accurate Co. Inc. has been a leader in roofing, waterproofing, cladding and glazing services... ..., configurations, and replacements Maintain and monitor data backup, recovery, and business continuity processes Collaborate...SeniorBi-weekly payRemplacementPermanent employmentFull timeWork at officeMonday to friday- ...Data Analyst- Power BI, Tableau, SQL Role Description Key Responsibilities • Collect, process, and analyze data from various sources... ...etc.). • Familiarity with statistical techniques and data modeling. Skills • Strong problem-solving and critical-thinking...Permanent employment
- ...started. About the Role We are seeking a Senior Collaborative Planning Forecasting and Replenishment (CPFR) Analyst who will focus on building strong partnerships... ...lead S&OP processes, and manage communication, data development, and opportunity identification with...SeniorFull timeWork at office
- ...Hitachi Rail Canada is seeking an enthusiastic self-motivated Senior Security Analyst to work on our Canadian Rail Projects. As the successful... ...assessments, accident/injury trend analyses, security performance data and input from other groups to identify potential security...SeniorFull timeFor subcontractorInternshipLocal areaRemote work
- ...Novipro is looking for an AS400 Programmer Analyst to join a client in the retail industry... ...Permanent, full-time position. - Hybrid work model: 3 days onsite per week in Mississauga,... ...- Experience with system interfaces and data integration using SFTP, XML, SQL, ODBC, and...SeniorPermanent employmentFull timeNight shift3 days per week
- ...PipeStress, AutoPipe, Cesar II, MathCAD, ANSYS and LS-DYNA, etc.). Model complex piping and support arrangements using finite element... ...bill of materials, design specifications, technical specifications, data sheets, etc. Review 3D piping model and equipment layout. Prepare...SeniorInternshipFlexible hours
$121k - $137.5k per year
...a future of financial empowerment. We’re looking for a Senior IT Risk Analyst to join our growing team. In this role, you’ll partner with... ...application security, cloud environments, vulnerability management, data protection, and security monitoring. Support vendor risk...SeniorWork at officeFlexible hours3 days per week- ...be a part of a team that is redefining the future of media. Senior Analyst, Ecommerce & Digital Analytics About the Role TSC, the retail... ..., beauty, home and electronics, so every day brings new data and new questions to answer. Reporting to the Director of Planning...SeniorFull timeContract work
$45 per hour
Our client located in the heart of Mississauga is looking to hire a contract Senior Financial Analyst for 6 months (chance of extension or even converting to full time). Reporting to the Accounting Manager, the successful candidate will support the month end, quarter end and...SeniorFull timeContract workWork at office$141.6k - $212.4k per year
...This role is part of the Markets Data Risk Execution team, focusing on improving and enhancing... ...: Act as a Subject Matter Expert (SME) to senior stakeholders and operate with a limited... ...business decision-making, including data modeling and manipulation patterns Data Quality...SeniorFull time- ...today… DHL Express currently has an opening for a Sr. Pricing Analyst in Mississauga , ON . In this role you will be conducting pricing... ...Preferred skills: D atabase management (MS Access , SQL & Data Factory ) & Data visualization tools (Power BI, Power Pivots) Experience...SeniorLocal area
- ...PipeStress, AutoPipe, Cesar II, MathCAD, ANSYS and LS-DYNA, etc.). Model complex piping and support arrangements using finite element... ...bill of materials, design specifications, technical specifications, data sheets, etc. Review 3D piping model and equipment layout. Prepare...SeniorFull timeInternshipFlexible hours
- ...(AtkinsRéalis company) is currently looking for experienced Senior Feeder Piping Analyst/Engineer to join our engineering team. The work is in support... ...(for procurement, fabrication, and site installation), data sheets, system classification lists, code classifications, commissioning...SeniorPermanent employmentFull timeInternshipHome officeFlexible hours
- ...Your role Lead a team of designers and modelers in preparation of overall plant (Civil, Mechanical, Electrical and I&C, Process) 3D models and subsequent drawing output. The successful... ...Ensure all models, outputs and project data is correctly established and maintained in...Full timeInternshipWork at officeWork from homeHome officeFlexible hours
$81.6k - $115.2k per year
...and comprehensive BI reporting packages and dashboards utilizing data infrastructure, localized DataMart's and external data sources... ...or externally BREADTH & DEPTH: Work independently as the senior analyst / subject matter expert and may provide technical support to...SeniorFull timeTemporary workWork from home
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Modeling Analyst. Be the first to apply!
- business data analyst Mississauga, ON
- financial reporting analyst Mississauga, ON
- data analyst internship Mississauga, ON
- remote data analyst part time Mississauga, ON
- data analyst volunteer Mississauga, ON
- stage data analyst Mississauga, ON
- data analyst excel Mississauga, ON
- senior data analyst Mississauga, ON
- junior data analyst Mississauga, ON
- bilingual data analyst Mississauga, ON
