Oracle Database ETL Engineer – Assistant Vice President

Job description

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities. Responsibilities: Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems Ensure essential procedures are followed and help define operating standards and processes Serve as advisor or coach to new or lower level analysts Has the ability to operate with a limited level of direct supervision. Can exercise independence of judgement and autonomy. Acts as SME to senior stakeholders and /or other team members. 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: 5-8 years of relevant experience Experience in systems analysis and programming of software applications Experience in managing and implementing successful projects Working knowledge of consulting/project management techniques/methods Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements Education: Bachelor’s degree/University degree or equivalent experience This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required. Role Overview The Applications Development Lead Analyst – Data Engineer (C12) is a senior technical individual contributor/lead responsible for architecting, building, and optimizing scalable enterprise data pipelines, ingestion frameworks, and data platforms. This role provides technical leadership in data engineering, ensures strict adherence to Citi's enterprise data governance and data quality standards, and drives risk & control compliance, regulatory milestones, and modernization efforts across the data ecosystem. Key Responsibilities 1. Data Engineering, Architecture & Pipeline Development Pipeline Design & Build: Architect and implement robust, high-throughput batch and real-time streaming data pipelines (ETL/ELT) to support analytics, reporting, and operational systems. Technical Leadership & Standards: Provide technical oversight across multiple data engineering workflows, defining best practices for data modeling, partitioning, distributed computing, and code efficiency. System Modernization & Migration: Lead initiatives to retire legacy data infrastructure and accelerate adoption of cloud-native data platforms, lakehouse architectures, and modern compute engines. Performance & Reliability: Optimize complex queries, data transformation jobs, and storage layers; implement comprehensive automated testing and monitoring to prevent data pipeline outages and data drift. Qualifications & Competencies Technical Experience Data Processing & Frameworks: Advanced proficiency in Apache Spark (PySpark/Scala), Python, and SQL for large-scale distributed data processing. Streaming & Event-Driven Systems: Hands-on experience with Apache Kafka, Solace, or Apache Flink for real-time stream processing. Data Warehousing & Lakehouse: Solid expertise in modern data warehousing/lakehouse platforms (Snowflake, BigQuery, Databricks, Delta Lake, or Hive/Hadoop). Databases & Data Modeling: In-depth knowledge of relational (PostgreSQL, Oracle) and NoSQL (MongoDB, Cassandra) data stores, dimensional modeling, and schema design. Orchestration & DevOps: Experience with workflow orchestrators (Apache Airflow), container technologies (Docker, OpenShift/Kubernetes), and CI/CD pipelines Data Governance Tools: Familiarity with data quality tools, data cataloging (Collibra/Apache Atlas), and automated testing frameworks. ------------------------------------------------------ Job Family Group: Technology ------------------------------------------------------ Job Family: Applications Development ------------------------------------------------------ Time Type: Full time ------------------------------------------------------ Most Relevant Skills Please see the requirements listed above. ------------------------------------------------------ Other Relevant Skills For complementary skills, please see above and/or contact the recruiter. ------------------------------------------------------ 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’s EEO Policy Statement and the Know Your Rights poster.