SAS Programmer/Analyst

MOHELA - Chesterfield, MO (30+ days ago)2.5


MOHELA is a nationally-recognized leader in student loan servicing and higher education financing. Established in 1981, our success for more than 35 years is due to the tremendous efforts of our outstanding staff. MOHELA is currently searching for an outstanding individual for the position of SAS Programmer.Located in Chesterfield, Missouri, MOHELA offers excellent benefits, including:

  • Medical + Dental + and Vision coverage within 60-90 days
  • 401K with dollar for dollar match up to 8% of salary after 1 year
  • Fully vested company paid pension after 5 years
  • Tuition reimbursement up to $12,000 per year after 3 months
  • Dependent child tuition reimbursement after 1 year

General Statement of Duties: Responsible for assisting the Business System Manager in the management of all aspects of the SAS query tool. Assist with managing usage of SAS and TIDAL to implement automation through controlled and methodical means. Ability to build and interpret business requirements documents and translate defined requirements into detailed, field-specific data extracts using SAS or SQL. Work in coordination with operational management, analysts/advocates, system managers, DBAs and Product Development to ensure SAS related enhancements are fully researched, specified and documented in order to provide continued support and maintenance. Assist with defining opportunities to improve business processes and support critical business strategies. As an employee of the Authority, the Analyst is additionally responsible for assisting with the broad stewardship of the Authority's mission.

Essential Duties and Responsibilities

SAS Management:

-Responsible for thecreation of complex SAS reports. The use of SAS requires in depth knowledge of the SAS product, SAS Language, SQL Language as well as a strong working knowledge of the data warehouse tables. SAS is a complicated tool that requires a high degree of proficiency. Decisions impacting our business are made based on queries provided by SM&S. It is critical that the queries are accurate and timely.

-Responsible for the integration of SAS with other internal products, including SQL, TIDAL, local tables, Automation processes and Web process

- Through effective communication with management and other SM&S staff, assist in the design, development and implementation of SAS programs. Build and interpret business requirements documents and translate defined requirements into detailed, field-specific data extracts using SAS or SQL.

-Assist manager with the following: determining what level of SAS user should create requested queries; providing continuing education on SAS usage; ensuring SAS is being used efficiently and effectively; implementing controls around the SAS process.

- Keep informed on SAS technology; attending seminars, training classes, conferences, to continue to build knowledge.

- Analyze processes, procedures, techniques regarding SAS and TIDAL to ensure the best methods are being utilized. Recommend solutions and new methodologies.

TIDAL: 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.

System Help Desk: Resource for SAS and TIDAL related 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 and conferences designed to build knowledge of the same.

Communications: Provides regular and timely project status updates to Manager, Business Systems. Cultivate and maintain positive relationships with internal stakeholders. Effectively communicate technical topics to non-technical audiences.

Federal, State and Guarantor Regulations: Responsible for achieving and maintaining a thorough knowledge and understanding of all federal, state, and guarantor regulations regarding the student loan program being serviced. Ensure system changes meet the requirements through coordination with all affected parties and notify management if the change(s) are not implemented in the system timely.

Minimum Qualifications:

- Write, maintain, and support SAS Programs

- Knowledge of SQL Server or DB2.

- Experience writing SQL queries.

- Strong analytical skills required.

Requirements:

  • Education/Experience: . Minimum of 2 years of SAS coding experience and SQL experience. Write, maintain, and support SAS Programs. Student Loan Program or similar financial services experience a plus. Bachelor’s Degree preferred.
  • Computer Skills: To perform this job successfully, an individual should have experience using SAS, writing SQL queries, and knowledge of SQL Server or DB2.
  • Strong analytical skills required
  • Written and verbal communication skills
  • Sound analytical and problem solving skills
  • Time management skills.
  • Ability to be flexible in a dynamic and constantly changing professional environment.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

We are an EEO/AA Employer. We do not discriminate in hiring on the basis of race, color, national origin, sex, gender identity, sexual orientation, religion, age, disability, protected veteran status, or any other characteristic protected by federal, state or local law

To build a diverse workforce, MOHELA encourages applications from individuals with disabilities, minorities and veterans.

In compliance with the American Disabilities Act Amendment Act (ADAA), if you have a disability and would like to request an accommodation in order to apply for a position with MOHELA, please call please call 636.733.3700 x3571, TDD 7-1-1

Job Type: Full-time

Salary: $65,000.00 to $75,000.00 /year

Experience:

  • SAS/SQL: 2 years