refresh

热门公司

Trending

招聘

JobsCitigroup

SAS & SQL Developer Senior Analyst – Assistant Vice President

Citigroup

SAS & SQL Developer Senior Analyst – Assistant Vice President

Citigroup

MUMBAI, Mahārāshtra, India

·

On-site

·

Full-time

·

5d ago

Team

USPB Controls Automation:

Role Overview

This is an A.V.P. C12 developing professional role within the USCC Controls Automation team in Mumbai. The successful candidate will be a key contributor, dealing with most problems independently and exercising latitude to solve complex issues. This role integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices, contributing significantly to the team's objectives. You will apply analytical thinking and leverage data analysis tools and methodologies to drive data-driven analysis and control-related business projects. The role demands attention to detail, professional judgment when interpreting data, and the ability to break down information systematically and communicably. The quality and timeliness of service provided will directly impact the effectiveness of both our team and other closely related teams.

Key Responsibilities

  • Serve as a representative for the Controls Automation team on control-related business projects, focusing on the development and execution of data-driven analysis.
  • Develop and automate control reports utilizing a range of tools including SAS, SQL, Enterprise Data Warehouse, Big Data, EAP, and shell scripting.
  • Develop, enhance, and validate methods for measuring and analyzing all risk types, including market, credit, and operational risks.
  • Support the design, development, delivery, and maintenance of best-in-class Control programs, policies, and practices for USCC Controls Automation.
  • Identify potential risks and escalate them for further review and action.
  • Handle preliminary investigations, assist with reconciliation procedures, and prepare routine correspondence.
  • Create and maintain reports for control, tracking, and analysis purposes, ensuring appropriate and secure retention of documents.
  • Collaborate with senior staff on investigating and responding to customer and operational complaints.
  • Interact and work effectively with other areas like RISK, TECH, Quality Control and Operations as needed.
  • Appropriately assess risk in business decisions, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets. This includes 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.
  • Must be able to work until 2 PM EST

Qualifications & Skills

Experience:

  • Minimum of 8 years of overall experience in data analysis, reporting, and automation.
  • At least 6 years of hands-on experience working with Database Management Systems (DBMS) tools.

Technical Proficiency (Must-Have):

  • Strong and advanced proficiency in SAS: Demonstrated expertise in SAS programming for data manipulation, statistical analysis, and report generation.
  • Strong and advanced proficiency in SQL: Expert-level SQL skills for complex querying, data extraction, and database management across various platforms.

Technical Proficiency (Add-on/Desired):

  • Proficiency in UNIX shell scripting for automation and job scheduling.
  • Experience with job scheduling tools such as Autosys or Control-M.
  • Familiarity with Enterprise Data Warehouses, Big Data, and EAP platforms.

Education:

  • Bachelor’s/University degree or equivalent experience in a quantitative, technical, or related field.

Soft Skills:

  • Consistently demonstrates clear and concise written and verbal communication skills, crucial for exchanging complex/sensitive information.
  • Self-motivated, detail-oriented, and capable of working independently and as part of a team.
  • Demonstrated project management and organizational skills, with the ability to handle multiple projects simultaneously.

Job Family Group:

Product Management and Development:

Job Family:

Product Management

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.

Total Views

0

Apply Clicks

0

Mock Applicants

0

Scraps

0

About Citigroup

Citigroup

Citigroup

Public

Citigroup Inc. or Citi is an American multinational investment bank and financial services company based in New York City. The company was formed in 1998 by the merger of Citicorp, the bank holding company for Citibank, and Travelers; Travelers was spun off from the company in 2002.

10,001+

Employees

New York City

Headquarters

Reviews

3.3

4 reviews

Work Life Balance

3.0

Compensation

3.2

Culture

2.8

Career

2.5

Management

2.7

35%

Recommend to a Friend

Pros

Compensation increases for investment banking roles

Legitimate investment banking employer

Internship opportunities available

Cons

Unclear career progression paths

Limited meaningful experience in internships

Compensation raises lower than competitors

Salary Ranges

28 data points

Mid/L4

Senior/L5

Staff/L6

Mid/L4 · Business Risk Intermediate Analyst

1 reports

$77,165

total / year

Base

$67,100

Stock

-

Bonus

-

$77,165

$77,165

Interview Experience

5 interviews

Difficulty

2.8

/ 5

Duration

14-28 weeks

Experience

Positive 0%

Neutral 40%

Negative 60%

Interview Process

1

Application Review

2

Recruiter Screen

3

Programming Assessment

4

Hiring Manager Interview

5

Panel/Superday Interviews

6

Final Decision

Common Questions

Technical Knowledge

Case Study

Behavioral/STAR

Past Experience

Culture Fit