Data Analyst at Ascendion in MC LEAN, Virginia

Job Description:

Job Overview:

We are seeking a Data Analyst to transform raw data into actionable insights that drive business decisions. The ideal candidate should have strong expertise in Python, SQL, AWS, and Tableau to analyze data, build visualizations, and optimize data workflows. This role requires a keen eye for detail, problem-solving skills, and the ability to communicate data-driven insights effectively.

Responsibilities:

• Collect, clean, and analyze large datasets to extract meaningful insights.
• Write complex SQL queries to retrieve and manipulate data efficiently.
• Develop and maintain interactive dashboards and reports using Tableau.
• Build Python-based data processing pipelines for automation and analysis.
• Work with AWS services (S3, Redshift, Lambda, etc.) to store, process, and analyze data.
• Perform data validation, quality checks, and troubleshooting to ensure accuracy.
• Collaborate with cross-functional teams to understand business needs and provide data-driven solutions.
• Optimize queries and data models for performance and scalability.
• Present insights through clear visualizations and reports for stakeholders.

Must-Have Skills:

• Strong SQL skills (query optimization, joins, CTEs, indexing).
• Proficiency in Python (Pandas, NumPy, Matplotlib, Seaborn).
• Experience with Tableau for creating dashboards and reports.
• Hands-on experience with AWS (S3, Redshift, Athena, Lambda, RDS).
• Ability to work with large datasets and structured/unstructured data.
• Strong problem-solving and analytical thinking skills.
• Experience with ETL pipelines and data transformation techniques.

Nice-to-Have Skills:

• Experience with Power BI or other visualization tools.
• Knowledge of Snowflake, Databricks, or other cloud-based data platforms.
• Exposure to machine learning or statistical analysis.
• Familiarity with CI/CD for data pipelines.

Apply Now