Business Intelligence and Internal Control Analyst

How You Will Make an Impact:The Business Intelligence and Internal Control Analyst is responsible for developing and monitoring internal control enforcing good accounting practices, developing data driven processes, analysis and reporting, implementing new solutions, and making necessary recommendations for any change in internal policy and procedures. This position will work directly with Sr. VP of Finance in coordinating and implementing strategies and will support the finance leadership team in internal audits, implementing internal controls and developing BI solutions. This position will interact with various professionals and stakeholders of multiple business entities and other external stakeholders. This position reports to Senior Vice President, Finance or the designee.

RESPONSIBILITIES/DUTIES: This list is illustrative only and is not intended to be a comprehensive list of tasks performed by this classification. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.

Business Intelligence (BI) Analysis and SupportDevelop, implement, and maintain BI solutions to support business decision-making processes.Support the Chief Financial Officer and Finance team in preparation of the reports related to the Audit CommitteeAssist the Sr. Vice President, Finance in various tasks, reports and responsibilities.Design and generate reports, dashboards, and visualization for key stakeholders.Develop and maintain reports and analysis tools to support Finance Team including Controllers, payroll, accounting, purchasing, and accounts payable.Analyze, reconcile, and operate General Ledger data in multiple entity environment to extract actionable insights and trends.Maintain open communication with management and Executives.Work closely with IT, Finance, and other departments to gather data requirements and ensure BI solutions align with business needs.

Internal Control and SupportProvide support to Controllers with Local Control Funding Formula (LCFF) training, revenue updates, templates, reporting due dates and compliance.Act as an objective source of independent advice to ensure validity, legality and goal achievement.Identify loopholes and recommend risk aversion measures and cost savings.Keep current on State Department of Education financial regulation.Engage to continuous knowledge development regarding sector’s rules, regulations, best practices, tools, techniques and performance standards.Ensure the use of Generally Accepted Accounting Principles (GAAP).Work collaboratively with client schools and implement appropriate controls/checks and balances.Support internal and external audits.Prepare monthly audit reports as requested.Maintain and update the Accounting Manual for multiple business entities.

Process ImprovementReview, provide recommendations, and develop policies and analysis tools to improve internal control and internal audit procedures, involving intra-department (Finance), inter-department and inter- organization (with client schools) settings.Recommend and implement solutions to streamline data collection, reporting, and control procedures.

Training and DocumentationTrain department employees on good accounting practices.Provide training and support to end-users on BI tools and data governance best practices.Maintain comprehensive documentation of BI processes and internal control procedures.

Supervisory ResponsibilitiesParticipate in the selection, supervision, training, and evaluation of subordinate personnel.Perform administrative duties, responsibilities, and activities as assigned. These may be changed or modified from time to time.

QualificationsKnowledge of laws, regulations, policies, and procedures relevant to the area of employment.Knowledge of principles and practices of budgeting, accounting and proper auditing techniques.Knowledge of State Education and Revenue, and other statutes, codes, rules and regulations pertaining to school finance and revenue calculation.Knowledge of public-school finance, including school district accounting, budgeting, and revenue calculation.Knowledge and understanding of SB 98, SB 117 and any related regulations.Knowledge and understanding of the Organization’s culture, business units, services, and products.Intermediate skill in financial analysis, critical evaluation.Understand, analyze, and explain complex mathematical models used for financing schools.Ability to create solutions in complex settings (data and logistics).Ability to exercise critical thinking, use logic and reason to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.Ability to work under tight deadlines and handle multiple requests or interruptions while still completing projects or work assignments in a timely manner.Self-sufficient, resourceful, and committed to providing excellent customer service.

MINIMUM QUALIFICATIONS:Bachelor’s degree in Accounting, Finance, Business Administration, or related field is required.3 years of experience in business intelligence, data analysis, reporting or internal control functions is required.3 years of professional experience in Accounting, Finance is required.2 years of experience in a Management or Leadership role is required.Experience with accounting software applications (i.e. SAGE).Proficient in BI tools such as Tableau, Power BI, or similar.Knowledge of data governance and principles and internal control frameworks.Strong analytical and problem-solving skills with the ability to interpret complex data sets.Strong autonomy, reliable, responsible, dependable and willingness to take on responsibilities and challenges.Strong understanding of the accounting cycle, budgeting, and financial analysis.Relevant certification in business intelligence and internal control (Certified Internal Control Professional) are a plus.Ability to travel in performance of job duties is required.Ability to lift, carry, push, pull objects weighing up to 10 pounds

PHYSICAL REQUIREMENTS:Mental Demands: high workflow management, high project coordination, and medium people engagement.Finger Dexterity: primarily using the fingers to make small movements such as typing, picking up small objects, or pinching fingers together.Talking: especially where one must convey detailed or important instructions or ideas accurately, loudly, or quickly.Average Hearing: hearing average or typical conversations and receiving ordinary information.Average Visual Abilities: normal acuity necessary to prepare or inspect documents and operate office equipment or machinery.Frequent multi-tasking, changing of task priorities, repetitious exacting work required.Prolonged period sitting at a desk and working on a computer.Working in a low moderate noise environment with frequent deadline pressures.