Citi Applications Development Sr. Programmer Analyst - Data Modeler in New Castle, Delaware
Primary Location: United States,Delaware,New Castle
Education: Bachelor's Degree
Job Function: Technology
Shift: Day Job
Employee Status: Regular
Travel Time: No
Job ID: 18061026
Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients.
Citi’s Mission and Value Proposition at http://www.citigroup.com/citi/about/mission-and-value-proposition.html explains what we do and Citi Leadership Standards at http://www.citigroup.com/citi/about/leadership-standards.html explain how we do it. Our mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. We strive to earn and maintain our clients’ and the public’s trust by constantly adhering to the highest ethical standards and making a positive impact on the communities we serve. Our Leadership Standards is a common set of skills and expected behaviors that illustrate how our employees should work every day to be successful and strengthens our ability to execute against our strategic priorities.
Diversity is a key business imperative and a source of strength at Citi. We serve clients from every walk of life, every background and every origin. Our goal is to have our workforce reflect this same diversity at all levels. Citi has made it a priority to foster a culture where the best people want to work, where individuals are promoted based on merit, where we value and demand respect for others and where opportunities to develop are widely available to all.
Citi’s Institutional Clients Group(ICG) is comprised of diverse, talented professionals globally located in more than 100 countries and territories, collectively representing an unparalleled international network of financial skills and capabilities serving targeted clients. Our clients are top corporations, financial institutions and governments in countries around the world and our mission is to help them achieve their goals. We do so by providing strategic, financing and operational insights and executing tailored product/service solutions, both across our borders and domestically. The ICG responds to clients' changing needs through its long-established relationship coverage approach that provides client solutions utilizing all of Citi's relevant capabilities, including the broadest possible access to financial markets globally. No other institution can match our combination of global insights, client relationship management services, geographic reach and local and cross-border product expertise.
The ICG technology is organized into Markets and Securities Services(MSST), Treasury and Trade Solutions(TTS) , Citi Private Bank(CPB) and Information Services Group(ISG).
Trade Transaction Services (TTS) Trade Technology organization supports the Global Trade Services, Trade Finance and Supply Chain management segment of the TTS Treasury and Trade business.
CITI- with the largest trade services network in the world offers a broad range of solutions that meet our global trade customer’s needs. From risk mitigation to financing, settlement to information, CITI’s trade experts and four, regional processing centers offer around –the-clock operations support and deliver world-class solutions to suppliers, buyers and Financial Institutions. International trade is the cross-border movement of goods and services that develop from a business transaction between a buyer in one country and a seller in another country.
Work with application development teams in designing new data structures and modifications to existing structures.
Review data models and data structures developed by data modeling team and application development teams.
Review SQL developed by development teams in terms of standards, best practices and performance impacts.
Review DWH ETL mapping documents.
Develop deployment data definition language(DDL) scripts.
Perform deployments across all environments.
Identify/Fix SQL performance issues.
Support development teams on all misc. needs including: Access/Privilege Requests, Tablespace Assignments, Space Capacity Analysis.
REQUIRED SKILLS (in order of importance)
2+ Years Data Modeling(Preferably on Large Scale DWH).
Experience in ERWIN.
Experience in tuning SQL.
Understanding of Logical vs. Physical Modeling.
Expert experience and working knowledge of Oracle (10g or above preferred).
Experience with Physical Data Model Deployments, script development.
Experience with Analytical and Operational Data Store Modeling.
Experience with Dimensional Data Modeling at an enterprise level.
Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.