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.

 

DESCRIPTION & RESPONSIBILITIES

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).

 

QUALIFICATIONS – ESSENTIAL

• 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

 

DETAILS:

LOCATION(S):  Lansing, MI

WORK TYPE:  12-Month Contract

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

RATE:  DOE

 

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  hr@thepinnaclesolutions.com and learn more about us at  www.thepinnaclesolutions.com.

Read More

Apply for this position

Required*
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

150