We are seeking a Data Analyst to support the US Card Partnerships team, focusing on credit card analytics, brand partnership performance, and customer insights.
Required Skill:
5+ years of experience in data analytics, preferably in the financial services or credit card domain.
Prior experience supporting Capital Ones Credit Card Data Analytics or similar environments is strongly preferred.
Advanced SQL expertise including window functions, subqueries, joins, and optimization.
Hands-on experience with Snowflake, PostgreSQL, and Databricks.
Familiarity with AWS S3 for data ingestion and loading.
Strong proficiency in Python or PySpark for data wrangling and analytical scripting.
Proficiency in Tableau for dashboard creation and visual storytelling; understanding of context filters and data connection strategies (Extract vs. Live).
Working knowledge of predictive analytics models, classification techniques, or LLM-based analysis (preferred but not required).
Strong problem-solving and analytical thinking skills with the ability to translate data into actionable insights.
Preferred:
Familiarity with credit card portfolio analytics, brand partnership analysis, and customer journey mapping.
Understanding of machine learning models or predictive analytics frameworks used in customer segmentation and transaction analysis.
Job Description:
Analyze large-scale transactional and customer datasets to uncover insights on spending patterns, portfolio performance, and campaign effectiveness.
Work on brand partnership analytics identifying brand-specific customer behavior trends, transaction anomalies, and performance indicators.
Perform data extraction, transformation, and loading (ETL) using SQL, Snowflake, Databricks, and AWS S3 environments.