Data Analyst

KellyMitchell Group; McLean (VA); Hybrid; USD 72,000 - 103,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

ESOP

401K

Job summary

KellyMitchell is seeking a Data Analyst to independently support over 30 internal customers, delivering data analysis, validation, and performance dashboards. The role emphasizes Python/SQL development, AWS proficiency, and cross-functional collaboration.

The position offers a hybrid work model in the McLean/Richmond area with W-2 employment. Strong communication skills and the ability to present insights to executives are essential.

Qualifications

• 5+ years of overall experience, incl. at least 4 years in data analysis and 4 years of hands-on programming experience.

Responsibilities

• Provide data analytical support and build performance monitoring dashboards.
• Conduct data validation and quality checks to ensure data integrity.
• Analyze data structures to identify gaps and develop actionable plans to close them.
• Translate business requirements into technical data solutions with BA teams.
• Develop automated Python scripts to generate Google Slides, Sheets, and Docs.

Skills

Python

SQL

Tableau

AWS

Data analysis

Project management

Tools

Google Slides

Google Sheets

Google Docs

Job description

Job Summary

Our client, a leading Financial Services provider, is seeking a Data Analyst to join their team. This individual will manage their work independently to support over 30 internal customers, providing critical data analytical support, data validation, and performance monitoring dashboards. This position is W-2 only. We do not work with third-party firms or C2C arrangements for this role.

Core Responsibilities

• Provide dedicated data analytical support around various services, including building performance monitoring dashboards and detailed analytical reports
• Conduct thorough data validation, quality checks, and system integration tasks to ensure data integrity
• Analyze existing data structures and processes to identify gaps, evaluating tests and developing actionable plans to close those gaps
• Receive and interpret business requirements directly from Business Analyst (BA) teams to translate them into technical data solutions
• Develop automated Python scripts to generate and populate Google Slides (with charts and tables), Google Sheets, and Google Docs
• Manage assigned data projects independently, including setting up meetings, defining project timelines, mapping milestones, creating agendas, and tracking deliverables
• Deliver frequent, high-level project status updates and analytical presentations to stakeholders up to the Senior Director level

Required Skills/Experience (Must-Haves)

• 5+ years of overall experience, featuring at least 4 years of professional data analysis work experience and 4 years of hands-on programming experience
• Strong proficiency with Python and SQL (including the ability to write scripts from scratch)
• Proven experience utilizing Python to build and manipulate Google Slides, Sheets, and Docs with dynamic charts and tables
• Proficient utilizing and developing within AWS service environments
• 1+ year of experience utilizing Tableau
• 1+ year of experience managing projects, creating timelines, leading client-facing communications, and addressing diverse stakeholder needs
• Exceptional presentation and communication skills with the ability to convey complex data topics in a clear, concise, and logical manner to executives

Preferred Skills/Experience (Nice-to-Haves)

• Prior professional experience working within a Financial Services environment
• 1+ year of experience utilizing AWS QuickSight for business intelligence and dashboard creation
• Familiarity or exposure to Databricks. (Note: Spark is not required)

Key Competencies & Behaviors

• Independent Driver
• Analytical Problem Solver
• Adaptable Team Player

Work Environment

• Location: McLean, VA or Richmond, VA
• Work Model: Hybrid
• Pay Range: The approximate pay range for this position is between $52.00 and $75.00 per hour. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
• Medical, Dental, & Vision Insurance Plans
• Employee-Owned Profit Sharing (ESOP)
• 401K offered

About KellyMitchell

At KellyMitchell, our culture is world class. We're movers and shakers! We don't mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.