Job Description :
We have a consulting opportunity for a SAS Advanced Programmer / Enterprise Business Intelligence Developer in Chapel Hill, NC for an Education client.

DESCRIPTION and RESPONSIBILITIES:

Seeking a full time SAS Advanced Programmer / Enterprise Business Intelligence developer to work with our client, an Education client in Chapel Hill, NC.

The consultant will assist the client to architect, design and develop reports, graphs, stored processes, visualizations and dashboards. 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.

QUALIFICATIONS – ESSENTIAL
Experience deriving SAS analytics and content with SAS 9.4 including:
o Apply and demonstrate expertise with efficient DATA step, SQL programming and SAS Macro programming.
o Experience developing reports and content with SAS 9.4 Enterprise Business Intelligence products including:
o 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.
o Creating and using Stored Processes for the creation of customized web output, to include:
o Leveraging and utilizing the creation and passing of parameters from one Stored Process to another via hyperlinks, listboxes, textboxes, etc. (The appropriate use of Macro coding, macro variables, and Macro functions to ensure correct parameter passing is vital)
o Utilize knowledge of Macro variables available to processes running under the stored process server.
o Leveraging the ability for creating session variables & passing parameters as macro variables for chaining Stored Processes
o Ability to know when to use canned SAS PROCs versus Macro / DATA step / PUT statements to produce desired output creating and modifying SAS BI Dashboards using available functionality. As an example, defining data sources, ranges, KPIs and the Dashboard
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
Leveraging and utilizing SAS Output Delivery System (ODS)
SQL and Oracle and MS SQL Server RDBMS experience
Good written and spoken communications skills in English and thought-leadership skills