View Our Website View All Jobs

SAS Data Integration / Visual Analytics Consultant

Pinnacle Solutions, Inc. is seeking a highly-experienced SAS Data Integration / Visual Analytics Consultant as an addition to our elite SAS Consulting Team for one of our Clients - a Financial Services Company, located in Effingham, IL for a 6-Month Contract-to-Hire, Full-time, all On-site beginning in May 2017.


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

PLEASE ALSO NOTE!  The Client intends for the Candidate to become their employee after the 6-month contract, if Candidate and the Client are happy.  Please do not apply unless you accept this model and are local or will relocate.



The Client is implementing the SAS Credit Scoring for Banking solution and requires an experienced SAS Data Integration consultant with financial services and risk experience. The consultant must have excellent communication skills and must be able to communicate about the techniques developed and results of analysis both to executives and other analysts in the organization.



  • Bachelor’s degree or equivalent experience.
  • Experience with SAS Credit Scoring Detailed Data Store (DDS) – is a major plus.
  • The Customer requires an experienced SAS Data Integration consultant (client prefers experience with SAS Data Integration Studio 4.6 or higher) Specific Requirements for Data Integration:
    • Mid to senior level resource, 5+ years’ experience.
    • Must know SAS Data Integration Studio (Prefers DI Studio 4.6 or higher exp).
    • Must be able to build and maintain SAS DI Studio jobs, job flows within Platform LSF, and troubleshoot job failures.
    • Must be able to perform both production support role as well as new development tasks.
    • 5 years or more of Data Warehousing implementation experience and experience developing technical solutions with SAS Data Integration in a SAS environment.
    • Data Modeling, Data Architecting and ETL architecting expertise is required.
    • Integrating and managing the data mappings from the client’s data sources (mainly Oracle) to the SAS Data Warehouse using SAS Data Management Solution.
    • Designing, developing and implementing the DI Studio job flows to load the data into Oracle.
    • Ability to develop new data loads to existing data warehouse.  Creating Stored Processes to provide the users easy access to the data.
    • Have good oral and written communication skills.  Lead and/or actively participate in SAS knowledge-sharing activities.
    • Must be able to read, and understand existing coding and processing to troubleshoot and resolved issues as they arise.
  • Experience using SAS Visual Analytics 7.1 or higher, including:
    • Loading data in LASR Analytic Server with autoload and experience with Visual Data Builder.
    • Experience with VA Explorer and VA Designer.
    • Designing and Developing Visualizations, Reports and Dashboards.
  • Utilize SAS software to analyze data. Identify trends and relationships within the data through descriptive statistical techniques is a major plus.
  • Experience deriving SAS content with SAS 9.4 including:
    • Apply and demonstrate expertise with efficient DATA step, SQL programming and SAS Macro programming.
    • Experience with designing, developing and maintaining analytical Data Warehouses/Data Marts.
    • Be proficient in Base SAS programming (DATA step), SQL programming (i.e., use of SQL pass-through or PROC SQL), as well as the SAS Macro language for use in making code more efficient.
    • Utilizing Enterprise Guide and its functionality to create project flows which could include aspects of data access, manipulation, summarization, and report generation to a variety of output formats and channels, etc.
    • Creating and using SAS Stored Processes for the creation of customized content.



LOCATION(S):  Effingham, IL

WORK TYPE:  6-Month C2H

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, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file