3 days old

Data Modeller

Irving, TX 75062

Citi's Institutional Clients Group (ICG) is comprised of diverse, talented professionals located in more than 100 countries, jurisdictions and territories globally. Citi's Banking, Capital Markets and Advisory (BCMA) is one of four divisions within ICG and provides comprehensive relationship coverage along with a full suite of products and services. In an effort to be the best possible financial partner to its institutional clients, the BCMA business strives to meet the demands w of Citi's global client base through debt capital raising, merger and acquisitions, and equity-related strategic financing solutions.

BCMA technology is focused on building a cross-functional team of talented individuals, creating a unique platform to deliver products that will disrupt the industry through technical innovation and creativity.

Our mission as a business focused technology organization is to provide best-in-class products and services to our global clients while solving our bankers biggest pain points.

**Why Citi?**

+ Over 200 years in business with a great team of creative, visionary and entrepreneurial thinkers.

+ Tremendous opportunities to advance, open to everyone across all levels. Learn and grow simultaneously!

+ We offer a unique journey of personal and professional development, accomplishment and satisfaction.

+ We value intelligence and a global mindset. There is a strong culture of empowerment here we embrace diversity.

+ We do our best to be flexible and may differ depending on the business or area.

+ Citi India supports would be and returning mothers with various childcare benefits.

+ Citi offers a robust training program. We continually reevaluate our training model to ensure that we are always offering the most relevant and best in class training.

+ At Citi, we value internal mobility. We want you to build a long-term career with us, so you can expect opportunities to move around the organization.

**Data Modeler/ Information Architect (AVP)**

**Job Description Summary** : The position is within ICG Technology, and we are seeking a Information/Data Architect with strong hands-on experience in developing Conceptual, Logical and Physical Data Model for BCMA Data Services. Candidate must have experience in developing large scale data models that fits multiple lines of business.


+ As a global team member, Identify data and information needs for BCMA Data Services

+ Develop conceptual, logical, physical models and metadata solutions

+ Design and maintain blueprint of the information architecture, data integrations and controls aligned to the renewed business strategy

+ Unify data concepts across disparate front office, credit risk, servicing and reporting functions of BCMA

+ Determine database structural requirements by analyzing client operations, applications and data from existing systems

+ Participate in requirement engineering and working groups and collaborate with business leads, operations, SMEs, technologists and governance teams

+ Define, model and rationalize target state architecture, socialize with key stakeholders and conduct walkthrough

+ Collaborate with Enterprise, Sector and Federated architecture team and adopt recommendations

+ Incorporate data standards and implement governance model

+ Develop data flows, ownership matrixes and data lineage

+ Implemented physical data model, contribute to the system and operational design, carry out optimization for usability and performance

+ Strictly follow Citis engineering standards and ensure these are followed across all modules in the project.

+ Ensure essential procedures are followed and help define operating standards and processes

+ Has the ability to operate with a limited level of direct supervision.

**Technology Skills:**

+ Must have expert level (hands-on) knowledge and understanding in with MS SQL Server/ Oracle and NoSQL

+ Data Modelling - dimensional/reporting, data warehousing and transactional use cases (Physical and Logical modelling)

+ Performance optimizations on SQL Server/ Oracle, SQL tuning and investigation of bottlenecks

+ Ability to translate architecture and low-level requirements to design and code using SQL

+ Hands-on MongoDB experience and how to design the best MongoDB schema for a given application will be added advantage

+ Knowledge on various Mongodb libraries and apis for different programming languages and platform

+ Demonstrate an understanding of the differences between typical relational and NoSQL database development and access methodologies

+ Must be able to design logical and physical data models for performance aligned to business use cases

+ Hands on SQL features - Indexes, Partitioning, Bulk loads, DB configuration, Security/Roles

+ Scale and optimize performance via schema design, query tuning, and index creation.

+ Knowledge of reporting and query tools and practices


+ 3-5 years hand-on experience in Data Architecture, Data Science and/or Data Modeling expertise

+ Financial industry knowledge in lending, risk management, servicing and risk/regulatory reporting

+ Product knowledge in commercial banking, capital and investment banking and markets

+ Extensive experience in relational/hierarchical/OLAP/Big Data concepts

+ Hands-on modeling and metadata management tools

+ Expertise in Data Management methodologies involving architecture, modeling, storage, security

+ Good understanding of data governance - defining strategy, developing goals, principles and policies

+ Prior experience in data integration, interoperability and data quality solutions.

+ Analytical and problem solver, excellent verbal, written and presentation skills

+ Working knowledge of modeling tools such as Magic Draw, Enterprise Architect


+ Bachelors degree/University degree or equivalent experience

+ Certification in Data Architecture / Modeling is a plus


**Job Family Group:**



**Job Family:**

Data Analytics


**Time Type:**

Full time


Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi) invite all qualified interested applicants to apply for career opportunities. 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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)** .

View the "EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) " poster. View the EEO is the Law Supplement (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pdf) .

View the EEO Policy Statement (http://citi.com/citi/diversity/assets/pdf/eeo\_aa\_policy.pdf) .

View the Pay Transparency Posting (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp\_%20English\_formattedESQA508c.pdf)


Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.


Posted: 2022-05-13 Expires: 2022-06-12

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Modeller

Irving, TX 75062

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast