Assistant Manager – SAS – Amex – Gurgaon (4 + years of experience)
Jobs Admin —
Updated On January 29th, 2015
Designation – Assistant Manager – SAS
Location – Gurgaon
About employer– Amex
Job description:
Responsibilities
- Gather business requirements from end users and translate them into specifications design. Design, develop, and maintain the dimensional model based on business requirements
- Incumbent will be aligned to the SAGE team, and will liaise with stateside counterparts (/stakeholders) to understand requirements and problem statement
- Analyze the existing environment of disparate systems and derive opportunities to leverage SAGE datamart to develop simplified solutions, also recommend alternative solutions to technical problems
- Automate applications/manual routines to incorporate controls, validate and test all code for accuracy and efficiency
- Bringing large data from SAS and non-SAS data sources into SAS environment, performing SAS data manipulations against the resulting sets
- Build reports/dashboards to produce data listings, summary tables, data graphs and widgets pertaining to corporate card data.
- Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.
Qualification and Skills Required
- No of years as per GPD standards (suggested 4+ years of experience)
- Bachelor’s or Master’s degree relevant to the industry
- Other credentials will be a plus
- Good knowledge of DWH-RDBMS concepts; proficient in SQL and SAS Programming, having knowledge of both Entity Relational Models, and Dimensional Models (Star Schema and Snowflake schema)
- Hands on experience with SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT
- Proficiency in data-handling and analysis
- Experience in developing, validating and implementing SAS programs and produce derived datasets for analysis and generating & documenting tables, listings and graphs for reports
- Generating the Reports through SAS Enterprise Guide and experience with SAS BI Tools
- Experience in extracting data and creating SAS datasets from various sources like Teradata, SQL Server, DB2, Access database, Excel and flat files
- Ability to work on multiple projects simultaneously and meet the deadlines as and when required
- Ability to develop effective working relationships with stakeholders of different seniority and geographical location
- Strong attention to detail and being solution oriented
- Strong communication skills and an ability to communicate complex ideas in a simple manner to a global audience
- Working knowledge of Banking systems and understanding of relevant reporting framework preferable
Interested people can apply for this job can mail their CV to [email protected] with subject as Assistant Manager – SAS – Amex – Gurgaon