Data Analyst/Developer, Citi

Citi

Location:
Singapore, Singapore

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

We are seeking a highly experienced and strategic Senior Data Analyst/Developer with over 12+ years of progressive experience, possessing a robust background in data analysis, business intelligence, and a deep understanding of data warehousing concepts, including PL/SQL, ETL processes, IBM DataStage, and Enterprise Application Integration (EAP). The ideal candidate will be a critical thinker with exceptional analytical skills, capable of translating complex data into actionable insights for business stakeholders. The successful candidate will be instrumental in Data Analysis for Genesis Application which delivers Regulatory & Consent Order items for Regulatory & Fed Reports. This role requires not only strong technical acumen but also significant experience in leading data initiatives, mentoring junior analysts, and influencing data strategy.

Job Responsibility:

Lead complex data analysis initiatives to identify trends, patterns, and anomalies in large datasets
Develop sophisticated reports, dashboards, and analytical models to provide actionable insights that drive business decisions across various departments
Collaborate extensively with business stakeholders (e.g., product managers, marketing, finance, operations) to deeply understand their analytical needs and business questions
Work closely with Data Engineers and ETL developers to identify, source, and ensure the availability and quality of necessary data
Leverage deep knowledge of ETL processes, particularly with IBM DataStage, to understand data lineage, transformations, and potential impacts on data analysis
Understand how data flows through various enterprise applications via EAP layers
Design, develop, and maintain advanced business intelligence solutions, including interactive dashboards and automated reports, using industry-leading BI tools
Provide technical guidance, mentorship, and support to junior data analysts
Champion data quality and integrity
Optimize complex SQL queries and data extraction processes to ensure efficient data retrieval for analysis and reporting
Clearly and effectively communicate complex analytical findings, insights, and recommendations to both technical and non-technical audiences through compelling presentations and written reports
Contribute to the overall data strategy, helping to define key metrics, identify data gaps, and recommend data infrastructure improvements

Requirements:

Minimum of 15 years of progressive experience in a Data Analyst, Business Intelligence Analyst, or similar role, with a strong focus on enterprise-level data
Advanced proficiency in writing complex SQL queries and PL/SQL scripts for data extraction, manipulation, and analysis from large relational databases (preferably Oracle)
In-depth understanding of ETL processes, data warehousing principles, dimensional modeling (star schema, snowflake schema), and concepts like Slowly Changing Dimensions (SCDs)
Solid understanding of IBM DataStage or similar enterprise-grade ETL tools, including the ability to understand job flows, source-to-target mappings, and data transformations
A good understanding of Enterprise Application Integration (EAP) concepts and how data moves across different business systems via integration layers (e.g., APIs, message queues)
Expert-level experience with at least one leading Business Intelligence/Visualization tool (e.g., Tableau, Power BI, Qlik Sense, Cognos)
Exceptional analytical, quantitative, and problem-solving skills with a proven ability to interpret data, analyze results, and provide data-driven recommendations
Excellent verbal and written communication skills, with a proven ability to present complex analytical findings clearly and concisely to diverse audiences
Strong commitment to data quality, accuracy, and governance
Demonstrated experience in mentoring and guiding less experienced team members

Nice to have:

Bachelor's or Master's degree in a quantitative field such as Computer Science, Statistics, Mathematics, Economics, or Business Administration
Experience with statistical analysis tools (e.g., R, Python with Pandas for advanced analytics
Familiarity with cloud-based data platforms (e.g., AWS Redshift, Azure Synapse, Google BigQuery)
Experience with big data technologies (e.g., Hadoop, Spark)
Domain expertise in a specific industry (e.g., Finance, Banking)

Additional Information:

Job Posted:
August 16, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Data Analyst/Developer