Responsibilities: * Responsible for the creation of SAS reports and other ETL activity. The position requires prior working knowledge of and proficiency in SAS and SQL-related and -dependent products.
Responsible for the integration of SAS with other internal products, including TIDAL scheduler, local SQL tables, and Web, CRM and automation processes.
Through effective communication with management and other SM&S staff, assist in the design, development and implementation of SAS programs. Interpret and translate business requirements documents into technical requirements, with the help of business analysts. Have a good understanding of the business in order to translate often undefined requests into meaningful data.
Assist manager with the following: determining what level of SAS user should create requested queries; ensuring SAS is being used efficiently and effectively; implementing controls around the SAS processes.
Analyze processes, procedures, techniques to ensure the best methods are being utilized. Recommend solutions and new methodologies.
Quickly diagnose and troubleshoot problems with existing processes.
TIDAL scheduler: Responsible for the scheduling of SAS queries on TIDAL as well as the continued maintenance and monitoring of those queries on TIDAL. Ensure TIDAL is being used efficiently and effectively, implementing controls around TIDAL.
Help Desk: Resource for applicable questions from all staff levels. Respond to questions about system queries requiring further research and analysis. Provide SAS and TIDAL related support and act as system representative for internal meetings pertaining to query/data discussions. Provide support for MOHELA projects and focus groups. Use knowledge of the organization and environment to effectively consult through complex situations.
Technology: Achieve and maintain a current working knowledge of technology application development standards and processes, data transmission standards, industry standards and XML standards. Attend seminars, training and conferences designed to build knowledge of the same.
Communications: Provides regular and timely project status updates to Senior SM&S Manager. Cultivate and maintain positive relationships with internal stakeholders. Effectively communicate technical topics to non-technical audiences.
Minimum of 2 years of SAS coding experience and SQL experience. Write, maintain, and support SAS programs.
Bachelor's Degree preferred.
Strong analytical and problem-solving skills required.