SAS/SQL Programmer

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 - 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 (adjust range as needed)

- 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:

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.