View Our Website View All Jobs

Senior SAS Advanced Programmer / SQL Developer

Pinnacle Solutions, Inc. is seeking a highly experienced Senior SAS Advanced Programmer / SQL Developer as an addition to our elite SAS Consulting Team for one of our Clients - a large Healthcare company, located in Lansing, MI for a 12-Month Contract, Full-time, all On-site. 


NOTE!  Candidate - please specify a desired HOURLY rate in application questions.



The ideal Candidate, as the Senior SAS/SQL Advanced Developer, is responsible for data preparation and development of SAS processes/code from different sources of data to an Oracle data warehouse. The consultant will develop SAS reports as well (ie:  Proc Report, Data _Null_,Proc Tabulate).



• Oracle experience is a MUST.

• At least 5 years of SAS programming and SQL experience.

• Advance level SAS proficiency in the following:

  • BASE SAS DATA step programming (i.e. Data step programming: use of functions, merges, dynamic formats, date formats, retains, arrays, hash tables, other Procs and advanced coding techniques for general data manipulation and reporting).
  • SAS Macro language for use in making code more efficient and building modular systems (treating macros as subroutines).
  • SQL programming (i.e. use of both SQL pass-through and PROC SQL via SAS/Access to one or more databases).
  • SAS/Access to Oracle to Oracle RDBMS.
  • SAS Reporting - Proc Report, Data _Null_, Proc Tabulate, Proc Freq.
  • Leveraging and utilizing SAS Output Delivery System (ODS).

• Understands SAS best practices, tips & tricks, and innovative in the usage of SAS.

• Experience with proper SAS code testing procedures and has good understanding of when results are correct or need to be revised.

• Self-starter, works independently as necessary, and with other business and technical people.

• Ability to understand business requirements and validate / ask appropriate follow up questions in order to translate to what is needed for SAS processing.

Oracle RDBMS experience is a MUST.

• Good written and spoken communications skills in English and thought-leadership skills.


EDUCATION (Required)

• Bachelor of Science in computer science or related field



LOCATION(S):  Lansing, MI

WORK TYPE:  12-Month Contract

WORK MODEL:   Full-time, M-F, 40 hours per week, all On-site



Pinnacle Solutions is a trusted SAS Alliance & Resell Partner, Amazon Web Services Partner, and creator of The Backpack Solution, an all-in-one, unprecedented, and must-have specialized toolkit solving all our client’s data demands.  To attract the most sought-after, elite SAS technology professionals, we specialize in flexible career models with above-market compensation.  Our specialists serve as a member of our internal development team, or they may provide on-site consulting expertise for our key Client positions.  Join our talented and elite SAS Consulting Team now by applying to this job posting or contact us via email at and learn more about us at

Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file