SAS/SQL Programmer (Python nice to have)

About Hexaware Technologies

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to clients worldwide. We foster a collaborative and inclusive work environment where every team member is valued and empowered to succeed. Hexaware offers excellent growth opportunities, collaboration with highly visible customers, and a perfect work-life balance. The company encourages challenging oneself to achieve full potential and innovate for a better future.

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

Hexaware Technologies is a leading global IT Services company dedicated to driving digital transformation and innovation. Founded in 1990, Hexaware offers AI empowered services including IT Consulting, Application Development, Infrastructure and Cloud Management, and Business Process services. The company has over 30,000 professionals across 30 countries and fosters a people-centric culture committed to sustainability.

What Would You Do?

Role: SAS/SQL Programmer (Python nice to have)

Location: Mclean, VA (5 day onsite)

Key Responsibilities

• Develop, optimize, and maintain SAS programs (Base SAS, Macro, PROC SQL) for data ingestion, transformation, validation, and reporting
• Write high-performance SQL for complex joins, window functions, CTEs, and stored procedures across RDBMS platforms
• Build repeatable, auditable ETL processes and data pipelines; schedule and monitor batch jobs
• Implement data quality checks, reconciliation, and lineage documentation
• Collaborate with data analysts, data scientists, and business stakeholders to translate requirements into technical designs
• Produce standardized datasets and reports for operational and analytical use
• Optimize performance at code and database levels (indexing, partitioning, statistics)
• Create and maintain comprehensive technical documentation (designs, SOPs, runbooks)
• Support UAT, defect triage, and production releases following SDLC best practices
• Contribute to modernization initiatives (e.g., translating selected SAS workloads to SQL or Python where applicable)

Must-Have Qualifications

• 5 to 7 years of hands-on experience in SAS and SQL development
• Strong in Base SAS, SAS Macro, PROC SQL, data step processing, and performance tuning
• Advanced SQL skills: complex joins, window functions, CTEs, subqueries, and query optimization
• Solid understanding of ETL concepts, data warehousing fundamentals, and dimensional modeling
• Experience with one or more RDBMS: Oracle, SQL Server, PostgreSQL, or Snowflake (via SQL)
• Version control (Git) and SDLC exposure (branching, code review, CI-friendly practices)
• Job scheduling familiarity (e.g., Control-M, Autosys)
• Strong debugging skills and attention to detail with data validation and reconciliation
• Excellent communication skills and ability to work with cross-functional teams

Tools and Technologies

• SAS (Base, Macro, PROC SQL), Enterprise Guide or SAS Studio
• SQL across common RDBMS (Oracle/SQL Server/PostgreSQL/Snowflake)
• Git, JIRA/Confluence or similar documentation tools

Nice-to-Have (Python)

• Practical experience with Python for data processing and automation using pandas, SQLAlchemy/pyodbc, and notebooks
• Writing modular, testable Python code; basic unit testing (e.g., pytest)
• Orchestrating jobs with Airflow or similar workflow tools
• Experience exposing or consuming REST APIs for data movement
• Ability to translate SAS logic into Python equivalents where beneficial

Education and Certifications

• Bachelor's degree in Computer Science, Information Systems, Statistics, or related field (or equivalent experience)
• Preferred: SAS Certified Specialist/Professional or equivalent certification

What You'll Get From Us

• 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 dedicated to providing a work environment free from discrimination and harassment. Employment decisions are based on business needs, job requirements, and individual qualifications without discrimination based on race, nationality, religion, sex, age, disability, marital status, sexual orientation, gender reassignment, or any other status protected by law. Candidates of all backgrounds are encouraged to apply.