Data Analyst

Trekrecruit • Fairfax, VA

3d

About The Position

We are seeking a Data Analyst to support the US Card Partnerships team, focusing on credit card analytics, brand partnership performance, and customer insights. This role involves analyzing large-scale transactional and customer datasets to uncover insights on spending patterns, portfolio performance, and campaign effectiveness. The analyst will also work on brand partnership analytics, identifying brand-specific customer behavior trends, transaction anomalies, and performance indicators. Key tasks include data extraction, transformation, and loading (ETL) using various tools, developing and optimizing SQL queries, using Python or PySpark for data manipulation and analytics, and creating Tableau dashboards for business stakeholders. Collaboration with cross-functional teams and support for ad-hoc analytical requests are also integral parts of the role.

Requirements

• 5+ years of experience in data analytics, preferably in the financial services or credit card domain.
• 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).
• Strong problem-solving and analytical thinking skills with the ability to translate data into actionable insights.

Nice To Haves

• Prior experience supporting Capital Ones Credit Card Data Analytics or similar environments is strongly preferred.
• Working knowledge of predictive analytics models, classification techniques, or LLM-based analysis.
• 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.

Responsibilities

• 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed