Senior Data Analyst
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
Similar roles
- Data AnalystHaystack · Chicago, Illinois, United States · Hybrid
Sr. Data AnalystKaseya · Miami, Florida, United States · Remote
Senior Data AnalystAmTrust Financial Services, Inc. · Dallas, Texas, United States · Hybrid- Data AnalystSolace · United States · Remote
- Junior Data AnalystPaw'some · New York, United States · Onsite