Business & Data Analyst - Financial Svcs (e) Job at Shoreline Community Coll

Salary: $70,000.00 - $95,000.00 Annually Location : Shoreline Community College, WA Job Type: Administrative Exempt Job Number: BDA-24 Department: Business & Administrative Services Opening Date: 11/18/2024 Job Summary Date of First Consideration: 12/8/24 Remote/Hybrid Work Options Available Salary Range: $70,000 - $95,000 / yr, depending on qualifications and experience Welcome Learn More AND Reporting to the Executive Director of Budget, Finance and Accounting, the Business & Data Analyst serves as the lead for the Financial Supply Chain Management (FSCM) pillar in the PeopleSoft/ctcLink system, and its functions in the budget, finance, and accounting work units. The analyst works with other Business & Data Analysts and provides ongoing technical and functional support. This position provides business process mapping, analysis, support, and recommendations to improve operational practices and ctcLink efficiency. It also involves analyzing ctcLink system requirements, assigning security roles, addressing IT-related issues, and ensuring efficient and effective operation of ctcLink -related functions in the FSCM pillar. Primary responsibilities include the following: Lead Peoplesoft/ctcLink financial system analysis, support, improvement, and maintenance. Organize and coordinate projects to support functionality and operation of the college's financial system using established criteria while working collaboratively with other related teams, leads, and analysts to improve existing structure and procedures; monitor project's progress and outcomes, recommending optimal solutions and resources to ensure the best outcomes. Work closely with local stakeholders and the State Board for Community and Technical Colleges (SBCTC) partners while acting as functional and technical lead and subject matter expert in the ctcLink FSCM pillar (the ctcLink finance modules). Provide ctcLink system and functional configurations within the various financial modules. Work closely with the college's other ctcLink pillars' leads and SBCTC production and support analysts for troubleshooting, issue escalations, and resolutions. Coordinate and actively participate in the ctcLink and other related systems maintenance and improvement work groups and workshops. Research existing processes, recommend adjustments and improvements, resolve problems where needed, and implement new processes to support optimal operation. Provide system and technical production support and analysis, write queries and reports, and assist the work units in setting operational practices and disseminating system information. Serve as a primary resource for end-user support, assisting with troubleshooting and providing technical guidance and training to budget, finance, and accounting department staff, ensuring familiarity with ctcLInk system functions, reporting, and best practices. Design and conduct training sessions and material for end-users before granting access to the ctcLink Finance Module to support end-users' system and information needs. Create, maintain, and update training materials, user guides, FAQs, system and support documentation. Serve as a reporting and query development expert on Finance subject matter. Create ad hoc queries and reports using PeopleSoft/ctcLink query and other business intelligence and data analysis tools. Ensure data accuracy and consistency by monitoring, auditing, and reconciling system data. Partner with internal stakeholders to identify and address system functional shortfalls, issues, concerns, and reporting needs and delivering actionable insights and recommendations to the management team. Work with budget, finance, and accounting staff and leadership to identify, develop, and implement reporting and data analysis in coordination to support more efficient and effective workflows and processes. Collaborate with the college's IT department, institutional research, human resources, student services, and other departments and teams to align system functionality with the changing financial policies and regulations landscape. Implement and monitor security protocols with the supervisor to protect sensitive financial information and ensure data security and compliance with relevant laws, regulations, and college policies and procedures. Ensure compliance with federal, state, and local regulatory standards, college policies and procedures, and best data handling and system access practices. Conduct regular reviews and contribute to risk assessment activities related to financial systems. Travel to participate in training sessions, workshops, seminars, and other related events. Perform other duties of a similar nature or level as assigned. Qualifications Required Education & Experience: Bachelor's degree in Education, Business, Statistics, Computer Science or closely related field. Any combination of relevant education and experience may be substituted for the educational requirement on a year-for-year basis. Minimum of two (2) years of experience in a technical and/or functional role providing business analysis and/or systems support for a college administrative information system and/or enterprise resource planning (ERP) or other complex information systems. Minimum of one (1) year of experience in a college or university in human resources, academic affairs, purchasing, payroll, accounting, finance, or curriculum management. Knowledge Of: Microsoft Office 365 Suite including Outlook, Teams, Excel, Word, PowerPoint, and SharePoint programs. Virtual meeting software such as MS Teams, Zoom, WebEx, GoTo Meeting, etc. ERP systems and financial reporting software, e.g., PeopleSoft, Banner, Oracle, Jenzabar, Workday, or similar. Systems and end-user need analysis. Structured Query Language, SQL or other coding languages. Advanced Excel methods like writing Macros, using VBA lookups, and other Excel BI tools, such as Tableau, and other applications/software. Project management and software change management and best practices. Regulations such as FERPA, GLBA, and other data security and privacy standards. Skill In: Contributing to diversity, equity, access and inclusion by fostering a climate of global competency and multicultural understanding Effectively disseminating complex information to non-technical subject matter experts Establishing and maintaining collaborative, positive, and effective working relationships at all organizational levels with a diverse community of faculty, staff, administrators across a range of disciplines and departments as well as SBCTC and external partners Time management with competing priorities in the development of functional unit activities Accuracy and attention to detail while managing multiple projects and deadlines Independently working, prioritizing, self-motivating, and maintaining progress on college goals, tasks, and deadlines without direct supervision Oral and written communication, as well as active listening to discern end-users' needs to solve problems and focus on solutions Keeping current with and applying information/technology from a variety of resources Demonstrating value and openness toward diverse points of view Handling difficult and sensitive situations and resolving conflict professionally Using sound independent judgment within policy, ethical, and legal guidelines Interpreting applicable laws, regulations, and policies You can't check off every listed knowledge and skill? Please apply anyway Studies have shown that traditionally marginalized communities are less likely to apply to jobs unless they meet every single qualification - even if they might be a great fit for the role Conditions of Employment The College is currently providing services in a mixed modality of operations (both online and in-person services are offered). When on campus, this position will perform work in a standard office setting, use standard office equipment and physically attend meetings both on and off campus. Remote work options are also available. If authorized for online work, employees will need to provide their own workspace and internet access, noting the College will provide technical equipment and support for online work needs. This position may require working in evenings and on weekends as needed, as well as limited travel. Terms Of Employment: This is a full-time administrative/exempt annually contracted position Initial salary placement determined by the College dependent upon education/experience. Hiring of this position is contingent upon available funding as determined by the College President. Required Materials To be considered for this position, please submit the following: NEOGOV online application & supplemental questions Cover letter describing relevant knowledge, skills, and characteristics that align with the needs of the position Current resume Official degree required upon hire Please Note : Once application materials have been submitted, you may not modify the application If you are chosen to move forward in this recruitment, you will be notified via email to the address listed in your application (make sure to check spam/junk folders) or by phone. Other Conditions: Shoreline Community College is committed to providing equal opportunity in education and employment for all students, employees, and applicants, and does not allow discrimination or harassment on the basis of race or ethnicity, color, national origin, age, sex, sexual orientation, gender identity, marital status, creed, religion, status as an honorably discharged veteran or military status, political affiliation or belief, citizenship/status as a lawfully admitted immigrant authorized to work in the United States, or presence of any physical, sensory, or mental disability. For our full non-discrimination statement and contact information, visit: Persons with disabilities have the right to reasonable accommodation in all aspects of employment with the College. This includes, but is not limited to recruitment, application, hiring, training, termination, conditions of employment, and any other employer-supported activities. Applicants requesting accommodation should contact the Office of Human Resources at . In accordance with RCW 28B.112.080, applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current or past places of employment. In compliance with the Immigration and Nationality Act, proof of authorization to work in the United States will be required at the time of hire. Shoreline CC does not currently sponsor HB-1 visas. Other conditions that may apply will be detailed upon the offer of employment. This position is overtime exempt. Applicants considered for positions at the College may be required to submit to a background check as a condition of employment. Adverse information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability for the position. Faculty positions are represented by the American Federation of Teachers Local 1950. Classified positions are represented by the Washington Federation of State Employees. ADMINISTRATIVE EXEMPT, CLASSIFIED, AND FULL-TIME FACULTY POSITIONS See bottom for Part-Time Faculty Benefits Information Comprehensive Benefits Packages Health, Dental, and Vision Insurance Life Insurance Long-term Disability Insurance Retirement Plan Employee Assistance Program Optional Flexible Medical Spending Account (FSA) Optional Dependent Care Assistance Program (DCAP) Optional SRA Tax Annuities Optional Deferred Compensation Plan Optional Home/Auto Insurance with Liberty Mutual Optional Credit Union participation Optional GET (Guaranteed Education Tuition) Program Tuition Waiver Various Professional Development & Wellness Programs Health Insurance Employee premiums for health insurance range depending on the plan and dependents covered. Two options for standard managed-care plans One value managed-care plan Three preferred provider options Two CDHP options Dental Insurance Employees have three dental plans to choose from. Two managed-care dental plan One preferred provider dental plan Life Insurance Life Insurance overview: $35,000 basic coverage and $5,000 accidental death and dismemberment coverage at no cost to the employee Optional coverage for spouse, children, supplemental, optional, and additional accidental death and dismemberment coverage - all at additional cost to the employee Long-term Disability Insurance Long-term Disability Insurance overview: Basic Coverage: 90 day waiting period, $240 per month maximum Optional Coverage: 90 day waiting period, 60% of gross pay - tax free (retirement plan still continues) Retirement Plans Public Employees Retirement System Plan 2 or Plan 3. Classified and civil service positions eligible to participate. Teacher's Retirement System (TRS) - Plan 3. Available for those who have been enrolled and vested in the past State Board Retirement Plan administered through TIAA-CREF - full time faculty and administrative/exempt positions eligible to participate. The Public Employees Benefits Board (PEBB) manages health, dental, life, and long term disability insurance. The Washington State Department of Enterprise Services administers Shoreline's Employee Assistance Program (EAP). PART-TIME FACULTY POSITIONS A part time faculty member becomes eligible for benefits at the beginning of the second consecutive quarter of half time or more employment at one or more Washington state institutions of higher education. Spring and fall quarters are considered consecutive quarters for benefits eligibility. Half time is determined based on each institution's definition of full time. A part time faculty member must qualify each quarter they teach to maintain eligibility. Once eligible, part time faculty will be notified of their benefit and retirement options. 01 What approach would you take to evaluate an ERP system's configuration in the post-implementation phase? What key metrics, methods, and tools do you use for evaluation? Required Question