Performing analysis of data from Customer Remediation Events in accordance with the Customer Remediation Policy
Using SQL database queries to pull data from SQL Server, Oracle, and Netezza, the analyst utilizes tools such as SAS, Excel, Toad, pgAdmin, Visual Studio Code or similar data tools to transform and analyze the data
Using data to compare to an initial population created by the business to challenge the accuracy and completeness of the initial population as well as the remediation calculations and totals
Once population consensus is reached, partnering with the business to work through the remaining milestones and through the remainder of the remediation process until the event is completed
Executing population and milestone testing during validation of customer remediation events
Reviewing and testing remediation population data to validate complete and accurate remediation populations and calculations are provided to customers
Providing critical challenge of business line data processes while ensuring comprehensive population and calculation data
Credibly challenging data extraction, population verification, and financial calculations

Bachelor's degree, or equivalent work experience
Typically more than six years of applicable experience
Strong knowledge of SQL performing queries to extract and transform data from multiple database sources and structures
Experience with Oracle, MS SQL Server, PostgreSQL, and Netezza
Proficiency with SAS Enterprise Guide
Extracting, transforming, analyzing, and presenting data
Advanced Microsoft Excel knowledge
Ability to manipulate and modify data through formulas and BI tools required
Power Query and VBA
Two or more years of experience in testing, audit, and/or an applicable risk management environment
Knowledge of PCS, CPTS, and/or MPS systems and merchant processing and/or retail credit experience
Strong team player with the ability to work well under minimal direct supervision while managing multiple simultaneous projects

Healthcare (medical, dental, vision)
Basic term and optional term life insurance
Short-term and long-term disability
Pregnancy disability and parental leave
401(k) and employer-funded retirement plan
Paid vacation (from two to five weeks depending on salary grade and tenure)
Up to 11 paid holiday opportunities
Adoption assistance
Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

Data Analyst

Key skills