Job Description & Details
This is a hands-on contract role focused entirely on wrangling data, building ETL pipelines, and optimizing reporting using SAS tools. If you enjoy deep-diving into messy enterprise datasets and turning them into actionable analytics without drowning in modern microservices hype, this one is worth a look.
What You'll Actually Be Doing
Your day-to-day will revolve around writing, maintaining, and optimizing SAS programs, macros, and scripts to handle heavy data extraction, transformation, and loading. You'll spend a significant chunk of time validating data quality, troubleshooting processing bottlenecks, and building out analytical reports and dashboards. Collaboration with business stakeholders is key here, meaning you'll need to translate vague reporting requests into concrete data solutions while ensuring everything complies with strict internal data governance.
The Core Tech Stack
You absolutely must know your way around advanced SAS programming and macro development. The role leans heavily on solid ETL pipeline design and database integration, so your SQL skills need to be sharp. Having a strong grasp of data cleansing techniques and large-scale dataset performance tuning will keep you from getting stuck when processing heavy enterprise loads.
Interview Expectations
Expect the technical round to test your macro-writing capabilities under pressure. A hiring manager will likely ask you to write a complex SAS macro on the spot and explain how you would optimize a notoriously slow-running data step. They are looking to see if you understand memory management and indexing, not just whether your code eventually compiles.
Application Advice
Make sure your resume doesn't just list SAS as a skill, but highlights specific projects where you built ETL processes and optimized heavy macros from scratch. Weave in keywords like 'data validation', 'SAS macros', 'ETL processes', and 'database integration' directly into your work history to easily clear the automated filters.