This position is with the Product and Analytics group, part of the Enterprise Excellence organization.The Enterprise Excellence (EE) team is a group within the Operations and Technology (O&T) that designs solutions to enhance transparency; empowers Operations and Functions to improve processes; and evolves the organization through continuous improvement and simplification. The organization is responsible for defining, deploying, and driving alignment and progress against a firm-wide framework that reduces operational risk, standardizes workforce optimization, and improves process health.The Senior Database developer will play a key role in designing and developing solutions to support the data management, quality assurance, process mining and data analytics initiatives within the Product & Analytics group. They will work closely with Operations, Technology, Transformation, and Risk & Controls groups across all sectors of the bank to achieve tangible results aligned to the firm's strategic priorities. Key responsibilities include:Analyzing and translating the business requirements to design and develop robust and scalable database solutions. This includes aspects such as conceptualizing & developing the data models, the data transformations, data quality framework etc. for medium to high complexity use cases.Writing complex stored procedures to implement the business logic, along with enhancing & debugging the existing database code- with focus on automation, efficiency and error handling.Hands on experience in query performance tuning, database tuning involving complex PL/SQL code, tables, materialized views etc.Monitoring and controlling all phases of development process- analysis, design, development and testing as well as providing support to the business users.Ensuring essential procedures and best practices are followed along with due documentation- to help achieve higher operating standards & processes.Ability to operate with a limited level of direct supervision- exercising independent judgement, autonomy & proactivity.Provides the SME support to senior stakeholders & team members, while a mentor to the junior analysts.Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions.Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.Qualifications:Extensive hands-on experience with data modeling, database design and architecture.Experience with Oracle database PL/SQL & DBA experience to enable handling very large datasets efficiently.Good proficiency in scripting skills in Python and Linux shell are required.Experience with big data technologies (HDFS, Impala, Hive, pySpark etc.) is highly desirable.ETL tool exposure, preferably Talend, and good exposure to other database technologies like Snowflake, Teradata, Starburst etc. is a plus.Exposure and interest in futuristic technology, Gen-AI/ML is also a plus.Education:Bachelor's degree/University degree in computer science/engineering is required.Master's degree preferredThis job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.------------------------------------------------------Job Family Group:Technology------------------------------------------------------Job Family:Applications Development------------------------------------------------------Time Type:Full time------------------------------------------------------Primary Location:Tampa Florida United States------------------------------------------------------Primary Location Full Time Salary Range:$113,840.00 - $170,760.00In addition to salary, Citi's offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.------------------------------------------------------Anticipated Posting Close Date:Apr 22, 2024------------------------------------------------------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 reviewAccessibility at Citi.View the "EEO is the Law" poster. View theEEO is the Law Supplement .View theEEO Policy Statement .View thePay Transparency Posting
