Sql data analyst Jobs in Miramar, FL

OVERVIEW:

The Student Account Analyst is responsible for monitoring student accounts by auditing, reviewing, and processing transactions to ensure compliance with federal, state, institutional and private lending regulatory requirements. Reporting to the Director of Student Financial Operations, the Student Account Analyst interacts with Student Financial Services and Accounting Department's along with campus personnel to ensure functions are completed correctly in accordance with internal and external policies, requirements, and regulations.

BUSINESS CONTRIBUTIONS:

The key functions of the Student Account Analyst are to administer all aspects required to provide operational support to the Student Financial Operations department. Student Account Analysts manage ensure compliance to institutional, state, and federal regulations. This role is to ensure compliance with institutional, state, and federal regulations through:

Title IV Compliance Related Functions:

• Ensure all active student accounts are audited and reviewed for Title IV credit balances are cleared prior to the EOLP or 14 days based on authorization forms on file.
• All funds posting occurs on the daily, weekly or monthly schedule and on time.
• Ensure tuition adjustment requests from the campuses are processed per institutional policies and within the appropriate time frame.
• Schedule Stipends for student living expenses and Title IV credit balances. Reconcile student stipends with ECSI for outstanding checks and proper disposition of funds.
• All temporary active out statuses (schedule gaps, leave of absence and academic interrupt) are reviewed for funds eligibility and where not, that R2T4s are submitted to Global.
• Review graduate and cancelled student accounts for credit balances and student refunds.
• All tuition adjustments are reviewed and completed to meet internal policies and procedures and to remain in compliance with Federal Regulations.
• Process refunds due to handling of credit balances and ineligibility of funds.

Account Receivable Administrative Functions:

• Negotiate settlements and record any corresponding adjustments
• Administer the flow of accounts to and from the collection agency. Monitor and update status and alter trigger codes for returning students
• Address account disputes and communicate to appropriate campuses
• Management of student groups to ensure accounts are in the appropriate placement status
• Manage the Bad Debt Write Off process including bankruptcies or deceased students
• Reconcile collections activity to appropriate reports, reconcile periodic turn over to agency
• Prepare monthly tuition reconciliation reports and disseminate tuition billing needs to campus Bursars and executive management

Private Lending Programs Functions:

• Ensuring cash flow detail reports are being managed and monitored properly
• Oversee the maintenance of pending disbursement reports internally and externally
• Analyze the submission of private loans based on campus batch reports and other resources
• Review pre-disbursement rosters and approve/deny exceptions
• Ensure private loan packages are being approved/denied within the appropriate time frames

ESSENTIAL FUNCTIONS and RESPONSIBILITIES:

• Work within the existing audit and compliance processes to avoid any audit findings
• Work closely with Global to ensure speedy and accurate turn around for R2T4s
• Ensure all funds are posted to student accounts accurately and timely with appropriate term codes and references
• Utilize various systems to maintain pipeline and workflow queues to prioritize flow
• Attend meetings, conferences, and trainings to ensure compliance with any institutional, state or federal regulatory updates
• Participate in departmental process and policy development initiatives.
• Maintain accuracy of student records in all systems
• Provide assistance/training and be a resource to the department and campus heads during audits and internal reviews

Job Specification

Student Account Analyst

Knowledge, Skills, and Experience:

The Student Account Analyst role is primarily focused on directing and coordinating the financial activities of the Student Financial Operations department.

Below is an inclusive but not exhaustive list of various knowledge, skills, and other characteristics that are necessary for effective performance as the Student Account Analyst:

-Knowledge:

• Title IV program, Financial Aid processes and regulations
• Loan servicing operations
• Account receivables, collections
• Basic/Intermediate level knowledge of finance and accounting principles
• Financial aid systems
  • CampusNexus
  • Global's Saint Director
  • Schooldocs
  • Lender/Servicing

-Skills:

• Effective communication skills both verbal and written to convey financial concepts, laws, and policies with campus level counterparts and provide resources and actionable guidance based on needs
• Goal setting
• Proficient in MS Office (Microsoft Word, Excel and Outlook)
• Able to work independently as well as part of a team
• Attention to detail
• Organization
• Time Management

-Experience: Although not exhaustive, work experience in the following areas is highly valued:

• Financial Aid Services
• Billings/Collections
• Financial Services/Lending
• Quality Control Coordination
• Finance and Accounting

Education, Experience, and Training:

Bachelor's Degree in general business or finance.

At least 3 - 5 years of finance, loan operations or business experience.

PHYSICAL DEMANDS:

The physical demands are those required in a typical professional office setting: communicating with coworkers and getting to and from appropriate on and off-campus appointments.

Ability to travel to campuses with the potential of overnight stays.

WORK ENVIRONMENT:

Professional office setting: moderate noise levels and controlled indoor climate. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

LOCATION:

This position is an onsite position located at the Office of the Executive Director in Miami Lakes, Florida unless otherwise determined by the Director of Student Financial Operations, Chief Financial Officer and/or designee. Any changes must be reviewed by the Director of Student Financial Operations, Executive Director or the Chief Financial Officer of designee.