Data Analyst

Akkodis; Richmond (VA); On-site; USD 55,000 - 69,000; Full time

Benefits offered by this job

Medical, dental, vision

Life insurance

401K plan

Paid time off

EAP program

Job summary

Akkodis is seeking a Data Analyst for a 12-month contract in Richmond, VA. The role focuses on backbook analysis, data migration, and ensuring data quality across legacy systems.

Responsibilities include data discovery, mapping, discrepancy resolution, and collaboration with tech and business teams. Requires 5+ years in data-focused roles and strong Snowflake/Databricks/SQL/Python skills.

Qualifications

• 5+ years of real-world experience as a Data Analyst or similar technical data-focused role.
• Extensive hands-on proficiency in Snowflake, Google Suite, Databricks, SQL, and Python.
• Deep understanding of complex data architecture, data quality frameworks, and data manipulation.
• Proven ability to dive deep into legacy datasets and drive analytical outcomes.

Responsibilities

• Backbook Data Analysis: lead data discovery to identify legacy data schemas required for migration.
• Drive Priority Migrations: support migration timelines across Bankruptcy, Deceased/Estates, Levies & Garnishments, and Charge-Offs.
• Data Mapping & Translation: map legacy attributes to destination systems like Customer Core and AccountsCBP.
• Discrepancy Resolution: resolve data discrepancies to establish the true source of truth for the Bank.
• Define Migration Logic: determine business logic for active/ended restrictions across accounts.
• Technical Execution: use SQL, Python, Snowflake, and Databricks for large-scale extractions and validation.
• Cross-Functional Collaboration: work with Tech Leads, Data Stewards, and Business teams.

Skills

Data analysis

Problem solving

Data fluency

Tools

Snowflake

SQL

Python

Databricks

Google Suite

Job description

This Data Analyst role is a 12 - Month Contract with a client located in Richmond, VA.

Pay Range: $40/hr. - $50/hr. The rate may be negotiable based on experience, education, geographic location, and other factors.

Key Responsibilities:

• Backbook Data Analysis: Lead the data discovery process to identify where legacy data resides today, detailing schemas, tables, and columns required for migration.
• Drive Priority Migrations: Support high-priority and medium-priority migration timelines, including Bankruptcy, Deceased/Estates, Levies & Garnishments, and Charge-Offs.
• Data Mapping & Translation: Map legacy attributes from systems like Profile and CST to destination systems, such as Customer Core and AccountsCBP.
• Discrepancy Resolution: Evaluate and resolve data discrepancies between multiple legacy systems (e.g., Profile vs. CST) to establish the true source of truth for the Bank.
• Define Migration Logic: Collaborate with stakeholders to determine business logic for handling active and ended restrictions across both open and closed accounts.
• Technical Execution: Leverage SQL, Python, Snowflake, and Databricks to write complex queries, perform large-scale data extractions, and validate post-migration data quality.
• Cross-Functional Collaboration: Work closely with Tech Leads, Data Stewards, and Business teams to ensure a standard backbook analysis checklist and framework are established and followed.

Required Qualifications:

• Experience: 5+ years of real-world experience working as a Data Analyst, Data Engineer, or in a highly technical data-focused role.
• Core Skills: Extensive hands-on proficiency in Snowflake, Google Suite, Databricks, SQL, and Python
• Data Fluency: Deep understanding of complex data architecture, data quality frameworks, and data manipulation.
• Problem-Solving: Proven ability to dive deep into legacy datasets, understand undocumented schemas, and confidently drive analytical outcomes.

Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy.

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers