Job Title: Data Analyst
Location: : Must sit in West Creek, Richmond, VA - Tue-Thu onsite & Mon and Fri remote (will also consider Mclean, VA)
Quantity: 1
Duration: ~14 months
Interview process: Technical interview to see how they approach data problems, what functions they utilize etc.
Shortlisting deadline: 8/11
Visa friendly: USC/GC
Notes:
- Customer Account Profitability Finance Team, under Data Solutions
- Data Analytics supporting key financial metrics
- Part of a team that creates products for analytical reporting horizontally across the organization
- Project: Commercial Finance. Create Data product with customer account data and G/L and P&L for all customers in Commercial Domain
- Product exists for G/L, but P&L level is new with high volumes of data
- Identify sources and files and develop based on user stories
- Extract and transform data based on COF quality standards (not looking for ETL developers, need analysis skillset)
- Bring up impediments and work within the team to fix any issues
- Take requirements and create product and complete testing. Want it in production within 12 months
- Data is in Capital One's "One Lake" Snowflake database
- Skills: Python and SQL and AWS (MUST have) PySpark (nice to have)
- Need programming level exp in python, to pull data, analyze and automate
- Develop scripts from scratch - creating a data project for finance
- Coding, testing migrating to production
- Majority of work focused on this project and assisting with other commercial scripts
- Former COF background and finance background are a big plus