Citi
Financial Services
SAS&SQLDeveloper–AssistantVicePresident
Neural analysis suggests this role is
optimal for Mid candidates.
“SAS & SQL Developer – Assistant Vice President at Citi. Skills: SAS, SQL, Data analysis, Quantitative analysis. Provide MIS support. Analyze requirements”
What You'll Achieve.
Satisfy compliance and regulatory requirements; Ensure extraction process returned desired result
Industry & Context.
Analyze requirements; Analyze results; Implement changes
Shift: 3. 30 PM to 12. 30 AM
What They're Looking For.
Must Have
6-10 years of experience in data management and analytics, Experience as an Operations Research Analyst, Analytics Manager, Strategic Business Analyst or related position performing quantitative analytics supporting financial services, Experience analyzing large applying quantitative analysis techniques to perform complex analyses and data mining, Experienced with the architecture of Operational Data Store (ODS), Enterprise Data Warehouse (EDW) and Big Data Hadoop System, Experienced with Citi's major backend database systems (mainly Origination Empower, ODS Oracle, EDW Teradata and EAP), Proficient in writing SAS/SQL programs to extract, transform and data, Know how to profile and analyze the extracted and develop analytical reports using SAS, Able to write Python coded for complex or repetitive tasks, Able to read/write SAS macros for complex or repetitive tasks, Knowledge of UNIX basic commands and basic shell scripting, Knowledge of AutoSys scheduling tool to automate jobs, Team player with good communication skills
Nice to Have
Master’s degree, Knowledge of project management
What You'll Do.
Write SAS and SQL codes
Pull populations/samples for control executions
Translate test requirements into technical terms
Implement logic in SAS/SQL
Write new codes or update existing ones
Prepare program logic document
Respond to IA enquiries
Conduct testing and analyze results
Assist in uploading final reports to QA system
Write Unix Shell scripts
Add SAS programs to AutoSys scheduler
Maintain data integrity
Develop ad-hoc reports
Assist in development of monthly reports
How You'll Work.
Team & Collaboration
Set up/attend meetings with various business partners and MIS teams; Work with business partners (Compliance, Internal Audit, Credit Risk, Originations, and CBORC)
Communication Scope
Good communication skills
Full Job Description
This position will provide MIS support for Mortgage Servicing Control teams and occasionally for business partners (Compliance, Internal Audit, Credit Risk, Originations, and CBORC). The candidate will be analyzing requirements, profiling source data, and writing SAS and SQL codes to pull populations/samples for control executions. **The primary objectives of this role will include:** * Set up/attend meetings with various business partners and MIS teams to define the requirements and identify source data points. * Translate test requirements (Intake forms) into technical terms and implement them in SAS/SQL logic to pull populations and statistically valid samples for the tests. * Write new codes or update the existing ones to extract and/or profile data. * Prepare the program logic document and submit the change to Management for its approval. * Quickly respond to IA enquiries. * Conduct testing and analyze results to ensure extraction process returned the desired result and implement changes as needed. * Assist in uploading final reports to QA system (Quest) to allow reviewers to begin testing. * Write simpler Unix Shell scripts required. * Add SAS programs to AutoSys scheduler for automation purposes. * Maintain data integrity of the populations and reports in the department to satisfy compliance and regulatory requirements. * Develop ad-hoc reports as requested by the unit managers. * Assist in the development of the department’s final monthly reports for upper management and business partners, if requested. **Required Qualifications:** * 6-10 years of experience in the field of data management and analytics. * Experience as an Operations Research Analyst, Analytics Manager, Strategic Business Analyst or related position performing quantitative analytics supporting financial services * Experience analyzing large datasets; applying quantitative analysis techniques to perform complex analyses and data mining * Should be experienced with the architecture of Operatio
Applying for this SAS & SQL Developer – Assistant Vice President role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Workday
- Workday has a multi-step form — save your progress after every section.
- "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
- Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
- Job requisition numbers are useful when following up with HR by email.
ANONYMOUS · UNFILTERED
What do employees actually say about Citi?
Real rants from real employees. Read before you apply.