TrekRecruit is hiring: Data Analyst - Project / Remote in Fairfax

About the job Data Analyst Job Overview: 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. • 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.