Develop, maintain, and optimize SAS programs, ETL workflows, and data models. Lead validation, testing, and troubleshooting of SAS GRID and SAS Viya jobs, support migration activities to Viya, and produce automated reports and dashboards. Collaborate with business, data, and infrastructure teams to ensure data quality, performance tuning, and successful deployment of SAS applications.
- Develop, maintain, and enhance SAS programs, macros, and scripts.
- Perform data extraction, transformation, and loading (ETL) activities.
- Analyze large datasets and generate reports for business insights.
- Design and optimize SAS data models and workflows.
- Validate and troubleshoot SAS jobs and production issues.
- Collaborate with cross-functional teams to gather business requirements.
- Create automated reports and dashboards.
- Ensure data accuracy, integrity, and compliance with company standards.
- Participate in code reviews and documentation activities.
- Support deployment and maintenance of SAS applications.
- Participate in migration of SAS workloads, ETL jobs, and batch processes from SAS GRID to SAS Viya.
- Analyze existing SAS GRID environments, ETL workflows, scheduling dependencies, and data pipelines.
- Convert and validate SAS programs, macros, and ETL processes for SAS Viya compatibility.
- Support migration of SAS Enterprise Guide projects, batch scripts, and shared libraries.
- Ensure migrated jobs execute efficiently within the SAS Viya compute environment.
- Identify compatibility issues and recommend remediation approaches.
- Quality Assurance & Validation
- Perform code validation and reconciliation between SAS GRID and SAS Viya outputs.
- Conduct unit testing, system testing, and parallel run validations.
- Troubleshoot migration and ETL-related issues.
- Ensure data quality, accuracy, and process integrity throughout migration activities.
- Stakeholder & Client Engagement
- Collaborate with business users, data teams, infrastructure teams, and architects.
- Provide regular updates on migration progress and issue resolution.
- Support client discussions and technical walkthroughs as needed.
Required Technical Skills
SAS Technologies
- Strong hands-on experience in SAS Base Programming
- SAS Macros
- SAS Enterprise Guide (EG)
- SAS Viya Platform (Good to have)
ETL & Data Engineering Skills
- ETL development and maintenance
- Data transformation and integration
- Data quality validation and reconciliation
- Performance tuning and optimization of SAS jobs
- Understanding of data warehousing concepts
Development & Tools
- Git / version control systems
- CI/CD exposure is preferred
- Experience working in Linux environments)
Cloud & Infrastructure (Preferred)
- Experience with AWS, Azure, or GCP environments
- Cloud-based analytics platform deployment
Domain Expertise
- Experience in Property & Casualty (P&C) Insurance domain preferred
- Understanding of insurance data, underwriting, claims, pricing, or actuarial datasets is an advantage
- Familiarity with regulatory and reporting environments is preferred.
Leadership & Soft Skills
- Strong problem-solving and debugging skills
- Good communication and collaboration abilities
- Ability to work independently and within distributed teams
- Willingness to learn and adapt to new SAS platform capabilities
Qualifications
- 4+ years of experience in SAS programming and ETL development
- Strong SAS Base and Macro programming expertise
- Experience supporting SAS GRID-based applications and batch processes
- Exposure to SAS Viya is preferred
- Experience in ETL support, enhancement, and migration activities
- Ability to work collaboratively within cross-functional teams
Education
Bachelor’s or Master’s degree in one of the following:
- Computer Science
- Statistics
- Data Science
- Engineering
- Mathematics
- Or related technical discipline
Preferred Qualifications
- SAS Certifications (Base SAS, Advanced SAS, SAS Viya)
- Experience with Python or R for advanced analytics
- Experience with Agile / Scrum delivery models
- Previous experience leading large-scale analytics platform migrations
- Exposure to insurance analytics or actuarial systems
Similar Jobs
Information Technology • Database • Consulting
No responsibilities or qualifications were provided in the job description.
Top Skills:
SAS
Information Technology • Database • Consulting
No responsibilities were provided in the job posting.
Top Skills:
SAS
Information Technology • Database • Consulting
Support migration of SAS ETL workloads from SAS GRID to SAS Viya: analyze ETL workflows, convert and validate SAS programs and macros, test and reconcile outputs, troubleshoot issues, ensure data quality, and collaborate with architecture, infrastructure, and business teams during migration planning and execution.
Top Skills:
PythonRSas BaseSas Enterprise GuideSas GridSas MacrosSas Viya
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
