Analyst, Business Intelligence

Salary: $50,000.00 Annually
Location : Leesburg Campus, Leesburg, FL
Job Type: Full-time Regular Staff
Job Number: 999424
Division: Technology Innovation
Department: Institutional Effectiveness
Opening Date: 04/17/2026
Location and Supervisor: LE WJ102A; Director, Institutional Research
Working Conditions: • The employee is exposed to an interior office environment with moderate temperature fluctuations. The work environment is inside an air-conditioned building. • The noise level in the work environment is usually moderate. • There are frequent interruptions from the staff and the general public for information or assistance.


Job Summary
The Business Intelligence Analyst is responsible for architecting, managing, and optimizing the college's data ecosystem using Oracle PL/SQL and Ellucian Banner, with a focus on the acquisition, transformation, integration, and security of institutional data. This role incorporates a strategic research component by conducting analytical modeling and specialized studies across a wide range of institutional areas to support data-informed decision-making. The analyst also designs, develops, and maintains interactive dashboards that translate complex data structures into clear, actionable insights to improve operational effectiveness. The position requires strong proficiency in PL/SQL; familiarity with tools and languages such as M, R, Python, Power Query, and DAX; experience working within the Ellucian Banner environment; and a solid understanding of business intelligence architecture and platforms, including Power BI or Tableau, along with demonstrated skill in dashboard design and data visualization best practices.

Responsible for demonstrating LSSC's core values of Caring, Communicating, Collaborating, and Celebrating when interacting with students, employees, visitors, and community members.

Essential Duties & Responsibilities
include, but are not limited to the following:

• Perform complex comparative analytical studies on intra- and inter-college issues.
• Design or assist in designing research methodologies; collect and organize data; conduct statistical analyses; interpret results; and prepare technical reports.
• Analyze current process standards, metrics, and workflows to recommend improvements.
• Coordinate with Subject Matter Experts to develop process improvement reports, outlining progress, adverse trends, recommendations, and conclusions.
• Collect, analyze, validate, and communicate institutional data to stakeholders and constituents.
• Coordinate with multiple stakeholders and respond to complex internal data requests supporting planning, evaluation, operational improvements, predictive analytics, and decision making.
• Design, build, or oversee development of reporting systems, dashboards, analytical tools, data cubes, OLAP reporting, and other integrations.
• Apply statistical and analytical tools to organizational data and deliver meaningful interpretations to relevant teams.
• Coordinate dissemination of student and institutional performance information to committees, leadership, and departments, ensuring accuracy, accessibility, and consistency.
• Design, develop, implement, and supervise processes to acquire, transform, and load data from ERP systems (e.g., Oracle/Banner) and third-party platforms.
• Identify end-user training needs and develop training plans accordingly.
• Conduct descriptive studies on faculty, students, staff, and instructional processes.
• Assist in institutional policy development and long-range planning studies.
• Perform other duties as assigned.

Knowledge, Skills, & Abilities

• Ability to evaluate existing techniques and procedures and to assist in devising new methods and procedures.
• Knowledge of organization, management, and operation of an institution of higher education.
• Ability to establish and maintain effective working relationships with faculty and staff personnel and the general public.
• Strong analytical, organizational, and interpersonal skills.
• Excellent writing and oral presentation skills.
• Knowledgeable about quantitative and qualitative educational research design and analysis.
• Proficient in data manipulation and analysis.
• Ability to organize and present complex, technical information to both technical and non-technical audiences.
• Ability to work in a fast-paced environment.
• Ability to organize and manage tasks promptly.
• Responsible, dependable, and professional behavior.

ABILITIES/GENERAL:

• Promote a common purpose consistent with the College's stated goals and demonstrate a commitment to students and the learning environment.
• Possess knowledge of general written standards and procedures utilized, and have the ability to read, interpret, and follow procedural and policy manuals related to the job tasks.
• Demonstrate the ability to respond to supervision, guidance, and direction in a positive, receptive manner and follow stated policies.
• Deliver exceptional customer service by fostering a welcoming and supportive environment.
• Present a professional image in words, actions, and attire.
• Conduct oneself in a manner consistent with the College's standards of ethical conduct.
• Apply effective techniques to establish and maintain working relationships, fostering collaboration to achieve common goals; effectively communicate and collaborate with others to achieve shared objectives.
• Demonstrate the skills necessary to examine situations and processes, making recommendations for improvement critically.
• Strong service orientation and ability to effectively work as a member or leader of a team by cooperating with others, offering to help others when needed, and considering larger organizational goals rather than individual concerns. Includes the ability to build &/or support a constructive team spirit where members are committed to the goals and objectives of the organization.
• Plan, organize, and successfully multitask to meet multiple deadlines and frequently new work tasks within required timeframes. Proven flexibility to successfully work on a variety of projects quickly and accurately.
• Effectively manage change and adaptability.
• Adheres to all workplace safety rules, safety laws, regulations, standards, and practices
• Ability to work various hours, including nights, early mornings, and weekends
• Ability to travel amongst various campuses and attend College events, on or off campus, as required.

Minimum Qualifications & Education

• Required:
  1. Bachelor's degree from an accredited institution in a relevant field or area of study.
  2. One to three years of relevant experience.
  3. Experience working within the Ellucian Banner environment.
  4. Proficiency in PL/SQL.
  5. Working knowledge of programming and data analysis tools.
  6. Experience with BI and data visualization tools.
• Preferred:
  1. Master's degree from an accredited institution.

Lake-Sumter State College provides a wide range of affordable, competitive, and comprehensive benefits that are a vital part of your total compensation package. These programs are centered around health and wellness, financial security, and professional development.