Job Profile Name: Technical Data Analyst - C12
Job Description:
The Technical Data Analyst is a senior-level position responsible for bridging the gap between complex business requirements and technical data solutions, leveraging advanced analytical and technical skills to develop data-driven solutions, with a focus on regulatory reporting and liquidity risk initiatives. This role will liaise extensively with business stakeholders and technology teams to articulate data needs, extract insights, and ensure data quality and integrity.
Responsibilities:
- Consult with business clients to determine system functional specifications and partner with multiple management teams and other units to meet organizational objectives.
- Define, document, and validate detailed data requirements, data flows, and data lineage for new or enhanced systems and applications.
- Provide technical input during the development and implementation phases, including formulating and defining systems scope, data objectives, and necessary data architecture enhancements for complex, high-impact projects.
- Design and develop robust data models (conceptual, logical, physical) to support reporting, analytics, and business processes.
- Prepare and curate data for AI/ML model development, working closely with AI engineers to ensure data quality, feature engineering, and model validation.
- Utilize advanced SQL for data extraction, manipulation, and analysis from various relational databases, data warehouses, and Big Data platforms.
- Develop and maintain data visualization dashboards and reports using tools such as Tableau, Power BI, or QlikView, translating complex data into understandable business insights.
- Lead the analysis of complex data sets to identify trends, patterns, and anomalies relevant to regulatory reporting, liquidity risk, and other critical financial functions.
- Identify and communicate data-related risks and impacts and propose risk mitigation options, considering business implications of the application of technology to the current business environment.
- Evaluate new data technologies, analytical tools, and evolving business requirements, and recommend appropriate systems alternatives and/or enhancements to current systems by analyzing business processes, systems and industry standards.
- Serve as advisor or coach to new or lower level analysts.
- 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:
- 6-8 years of experience as a Technical Data Analyst or similar role within the Financial Services industry, preferably in regulatory reporting (e.g., Basel, CCAR, FR 2052a) and liquidity risk.
- Advanced proficiency in SQL for complex data querying, analysis, and optimization across large datasets.
- Strong experience with relational databases (e.g., Oracle, SQL Server, DB2) and data warehousing concepts (e.g., dimensional modeling, star/snowflake schemas).
- Demonstrated expertise with Big Data technologies including Hadoop, Spark (PySpark/Scala Spark), Kafka, and cloud-based data platforms (e.g., AWS S3, Databricks).
- Demonstrated experience with data modeling tools and techniques.
- Proficiency in data visualization tools (e.g., Tableau, Power BI, QlikView) and strong Excel skills for data manipulation and presentation.
- Experience with scripting languages for data analysis (e.g., Python, R) is highly desirable.
- Experience with data preparation for AI/ML models and understanding of core AI/ML concepts and workflows is highly desirable.
- Comprehensive knowledge of data analysis principles, methodologies, and data governance frameworks.
- Experience across all phases of the Software Development Life Cycle (SDLC), with a focus on data-centric projects.
- Consistently demonstrates clear and concise written and verbal communication.
- Demonstrated problem-solving and decision-making skills.
- Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements.
Education:
- Bachelor's degree/University degree or equivalent experience.
- Master's degree preferred.
------------------------------------------------------
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.
Skills Required
- 6-8 years of experience as a Technical Data Analyst or similar role in financial services
- Experience with regulatory reporting and liquidity risk, preferably Basel, CCAR, or FR 2052a
- Advanced SQL proficiency for complex querying, analysis, and optimization
- Experience with relational databases including Oracle, SQL Server, or DB2
- Knowledge of data warehousing concepts, dimensional modeling, and star or snowflake schemas
- Experience with Hadoop, Spark, Kafka, and cloud data platforms such as AWS S3 or Databricks
- Experience with data modeling tools and techniques
- Proficiency with Tableau, Power BI, or QlikView
- Strong Microsoft Excel skills for data manipulation and presentation
- Experience with Python or R for data analysis
- Experience preparing data for AI/ML models and understanding AI/ML concepts and workflows
- Knowledge of data analysis methodologies and data governance frameworks
- Experience across the Software Development Life Cycle, especially data-centric projects
- Bachelor's degree or equivalent experience
- Master's degree
- Clear written and verbal communication skills
- Problem-solving and decision-making skills
- Ability to work under pressure and manage deadlines or changing requirements
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Health coverage is presented as comprehensive, including free in-network preventive care, mental-health resources, and the Be Well Program. Materials also state new hires have access to health and insurance benefits from the outset.
-
Retirement Support — The retirement plan offers a $1-for-$1 match up to 6% of eligible pay. New employees are eligible for the plan, with automatic enrollment after 90 days if they do not enroll themselves.
-
Inclusive Benefits Coverage — Benefits highlight fertility treatment coverage, adoption/surrogacy reimbursement up to $30,000, and disability coverage. Coverage extends to spouses and domestic partners regardless of gender identity or sexuality, with gender-affirming care-related support noted.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
