Intern Python Data Analyst Jobs in Ashburn, VA (NOW HIRING)

What Working at Hexaware offers:

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance.

With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware s commitment towards creating smiles.

At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together.

We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion the driving force that makes one smile and innovate, create, and make a difference every day.

The Hexaware Advantage: Your Workplace Benefits

• Excellent Health benefits with low-cost employee premium.
• Wide range of voluntary benefits such as Legal, Identity theft and Critical Care Coverage
• Unlimited training and upskilling opportunities through Udemy and Hexavarsity

Who we are?

At Hexaware Technologies, we are a leading global IT Services company, dedicated to driving digital transformation and innovation for businesses around the world. Founded in 1990, Hexaware has grown into a global trusted partner for enterprises, offering comprehensive AI empowered services including IT Consulting, Application Development, Infrastructure and Cloud Management and Business Process services.

At Hexaware we are a community of creative, diverse, and open-minded Hexawarians creating smiles through the power of great people and technology.

We pride ourselves on our people-centric culture and commitment to sustainability. Our diverse team of over 30,000 professionals across 30 countries is driven by a shared passion for innovation and excellence. We foster a collaborative environment where creativity and continuous learning are encouraged, enabling our employees to thrive and grow.

What would you do?

Role : Data Analyst with Strong SQL, SAS, Python

Location: McLean, VA (5 Days Onsite)

Role Summary

You will analyze, transform, and interpret complex datasets to generate actionable insights that drive business decisions. The role emphasizes hands-on data extraction with SQL, statistical analysis and automation using SAS and Python, and delivering reliable reporting and dashboards to stakeholders.

Responsibilities

• Data extraction and preparation
• Write efficient SQL (joins, CTEs, window functions) to extract and aggregate data from relational databases.
• Build and maintain ETL/ELT workflows using Python (pandas) and SAS (DATA steps, PROC SQL).
• Clean, standardize, and validate datasets; implement data quality checks and reconciliation routines.
• Analysis and modeling
• Perform exploratory data analysis and descriptive statistics.
• Conduct statistical testing and basic predictive modeling in SAS/Python (e.g., regression, classification where applicable).
• Translate ambiguous business questions into analytical approaches and measurable metrics.
• Reporting and visualization
• Develop automated reports and dashboards (e.g., SAS Visual Analytics, Tableau, Power BI).
• Create clear visual narratives and documentation that communicate insights and recommendations.
• Automation and optimization
• Automate recurring analyses and reporting using SAS macros and Python scripts.
• Optimize SQL queries, SAS jobs, and Python data pipelines for performance and scalability.
• Schedule and monitor recurring jobs using enterprise schedulers or cron.
• Stakeholder collaboration
• Partner with business, product, and engineering teams to define requirements and deliver insights on time.
• Present findings and recommendations in a clear, business-oriented manner.
• Maintain thorough documentation and adhere to version control (Git) and data governance standards.

Required Qualifications

• Bachelor s degree in a quantitative field (e.g., Statistics, Mathematics, Computer Science, Engineering, Economics) or equivalent practical experience.
• Hands-on experience in a data analyst or similar role working with large datasets.
• Strong proficiency in:
• SQL: complex joins, window functions, CTEs, query tuning.
• SAS: Base SAS, PROC SQL, SAS/STAT; experience with macros and SAS Enterprise Guide.
• Python: pandas, numpy; data wrangling and analysis scripting.

Preferred Qualifications

• Experience with data visualization tools (SAS Visual Analytics, Tableau, Power BI).
• Familiarity with data warehousing concepts (star schema, dimensional modeling) and ETL best practices.
• Exposure to cloud data platforms (AWS Redshift, Azure Synapse, Google Cloud Platform BigQuery, Snowflake) and file formats (Parquet, Avro).
• Basic knowledge of scikit-learn for light ML use cases.
• Experience with APIs, scripting for data ingestion, and job orchestration tools (e.g., Airflow).
• Knowledge of data governance, PII handling, and compliance practices.

Core Skills

• Technical
• SQL performance tuning and query optimization.
• SAS programming (DATA step, PROC, macro automation).
• Python data analysis (pandas) and visualization (matplotlib or seaborn).
• Git-based version control and collaborative workflows.
• Analytical
• EDA, hypothesis testing, experiment design basics.
• KPI definition, metric design, and business outcome mapping.
• Root-cause analysis and ability to translate data into decisions.
• Communication
• Clear storytelling with data; stakeholder management.
• Requirements gathering and documentation.

What you ll get from us:

Insert employee benefits here e.g.:

• Competitive Salary
• Company Pension Scheme
• Comprehensive Health Insurance
• Flexible Work Hours and Hybrid Work Options
• XX days paid annual holidays + public holidays.
• Professional Development and Training Opportunities
• Employee Assistance Program (EAP)
• Diversity, Equity, and Inclusion Initiatives
• Company Events and Team-Building Activities

Equal Opportunities Employer:

Hexaware Technologies is an equal opportunity employer. We are dedicated to providing a work environment free from discrimination and harassment. All employment decisions at Hexaware are based on business needs, job requirements, and individual qualifications. We do not discriminate based on race including colour, nationality, ethnic or national origin, religion or belief, sex, age, disability, marital status, sexual orientation, parental status, gender reassignment, or any other status protected by law. We encourage candidates of all backgrounds to apply.