Job Description:
- Lead a team of 5-7 team members and work with multiple GMS Regional Partners to deliver on Standard / BAU as well as Ad Hoc reporting and Analysis.
- Effectively be able to communicate both written and verbal with numerous team members to support/guide users in SAS application.
- Direct team members on more complex data extraction, analysis or project requirements for data files that are not supported via existing tools.
- Generate analytics and insights in RAMP (SAS Environment)
- High degree of data manipulation and quality checking of data programs, file outputs and analysis.
- Provide workflow management, daily/weekly project reporting, including, but not limited to real time project status, capacity usage, capacity projections, etc.
- Support monthly/annual analytics and usage reporting
- Periodic reporting on individual and team performance including but not limited to # of analyses executed, cycle time, etc
- Regular compliance reporting showing adherence to all policy and privacy regulations
- Ability to understand AXP Card member, Merchant, and Issuer data (also known as the “closed loop” data) within AMEX databases.
Qualifications:
Required Skills/Qualifications:
- Minimum of 6 years of experience in Reporting & Analysis preferred
- People Management experience of 2+ years
- Strong reporting background and high proficiency in SAS, SQL, experience with Merge/Purge process and tools
- Advanced level SAS and SQL (create stored Procs / macros)
- Produce analytic reports (i.e. frequencies, attributes, responder vs. non-responders)
- Data Extraction. Understanding data models, database design/schema & AMEX data warehouse
- Data Manipulation & Synthesis using SAS stored procs, SQL & SAS EG
- Interface/Reports - Excel, Import datasets into Excel & generate custom charts, graphs, reports in Excel. Excel reporting using Pivot Charts/Graphs
- Data Cleansing, Sorting, Embed/update excel reports via dynamic links, System Processes – Data Processes, Automation
- Understand & execute monthly/weekly data/analytic processes, to be able to debug issues
- Strong quantitative skills combined with ability to synthesize product concepts and ideas
- Strong strategic thinking and problem-solving skills
- Strong written and verbal communication skills, including ability to translate/explain complex data concepts for non-technical audiences
- Degree in engineering, mathematics, operations research, economics, or equivalent.
Didn’t find the job appropriate? Report this Job