Data AnalystFairfax, Virginia, United StatesJob OverviewWe are seeking a Data Analyst to support the US Card Partnerships team, focusing on credit card analytics, brand partnership performance, and customer insights.Required Skills5+ years of experience in data analytics, preferably in the financial services or credit card domain.Prior experience supporting Capital One's 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.PreferredFamiliarity 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 DescriptionAnalyze 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.Develop and optimize complex SQL queries (including Window Functions, Partitions, Rank/Dense Rank/Row Number).Use Python or PySpark for data manipulation, automation, and predictive analytics.Create and maintain Tableau dashboards and visual reports for business stakeholders.Apply context filters and efficient data connections (Extract vs. Live) to optimize dashboard performance.Collaborate with cross-functional teams to design data-driven solutions for customer segmentation, personalization, and portfolio monitoring.Support ad-hoc analytical requests and reporting related to customer journey mapping and credit card usage trends.Or refer someone