Sky Consulting logo
Sky Consulting Verified
IT Consulting, Business Consulting

Senior Data Analyst

Mclean, Virginia, United StatesHybridFull TimeSenior$101,495–$122,230 /yrPosted 2 months agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

We are seeking a Senior Data Analyst with extensive experience in Python, SQL, ETL processes, and AWS cloud technologies. The role involves developing and maintaining ETL pipelines using Ab Initio, performing data analysis on large datasets, and building reports and dashboards to support business decisions. The ideal candidate will also have experience with microservices architecture, Node.js, Angular, REST APIs, distributed systems, and CI/CD practices. This is a hybrid remote position located in McLean, VA, requiring strong analytical, problem-solving, and collaboration skills.

Note: Prior experience with Capital One will be preferred.

We are looking for a Senior Data Analyst with strong experience in Python, SQL, ETL processes, and AWS cloud technologies. The ideal candidate will have hands-on experience working with Ab Initio for ETL, building data pipelines, and performing data analysis to support business insights and decision-making.

This role requires someone who is comfortable working with large datasets, transforming data, and collaborating with cross-functional teams in a fast-paced environment.

Key Responsibilities

  • Develop and maintain ETL pipelines using Ab Initio to process and transform large datasets.
  • Write efficient SQL queries to extract, manipulate, and analyze data from multiple sources.
  • Use Python for data processing, automation, and analytics.
  • Work with AWS cloud services to manage and analyze data in cloud environments.
  • Perform data validation, quality checks, and troubleshooting for data pipelines.
  • Build reports, dashboards, and insights to support business decisions.
  • Collaborate with data engineers, analysts, and business stakeholders to understand requirements.
  • Ensure data accuracy, consistency, and governance across systems.

Requirements

  • Strong programming experience in Python (Java acceptable).
  • Hands-on experience with AWS cloud services.
  • Experience building and supporting microservices architecture.
  • Experience with Node.js for backend/API development.
  • Exposure to Angular frontend framework.
  • Strong understanding of REST APIs and distributed systems.
  • Experience with CI/CD pipelines and DevOps practices.

Required Skills

  • 10 years of experience in Data Analytics or Data Engineering roles.
  • 5 years of experience with Ab Initio (ETL).
  • Proficiency in Python for data analysis and scripting.
  • Advanced SQL skills for querying and manipulating data.
  • Hands-on experience with AWS Cloud services.
  • Experience working with large datasets and data pipelines.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration skills.

Pay: $101,494.62 - $122,230.08 per year

Work Location: Hybrid remote in McLean, VA 22102

Ready to apply?
You'll be redirected to Sky Consulting's application page.

Similar roles