Data Analyst

The Data Analyst will play a critical role in gathering, analyzing, and interpreting data to support decision-making and improve educational outcomes. The Data Analyst will be responsible for collecting, organizing, and transforming data from various sources, generating insightful reports, and providing actionable recommendations to enhance operational efficiency. This is an MOU position supporting Cabrillo Point Academy, Mission Vista Academy, and Pacific Coast Academy.

The Data Analyst may support specifically assigned departments according to Supervisor and IT Leadership guidance. All employees are expected to follow the responsibilities and procedures as delineated in the Employee Handbook., * Managing master data, including creation, updates, and deletion

• Provide quality assurance of imported data
• Processing confidential data and information according to School guidelines
• Helping develop reports and analyses
• Assisting with the management and design of the reporting environment, including data sources and security
• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems
• Generating reports from single or multiple systems
• Troubleshooting the reporting database environment and reports
• Training end-users on new reports and dashboards
• Assisting with the research and testing of APIs for various software applications
• Providing technical assistance in data storage structures, data mining, and data cleansing
• Accurately and efficiently enter data into relevant databases and systems, ensuring data integrity and completeness
• Maintain accurate documentation of data entry procedures and processes, data sources, and databases
• Other duties as assigned, * What data analytics software/tools/languages are you familiar with (i.e. MySQL, PowerBI, R, Google Sheet/Excel formulas)?

• Ability to analyze existing tools and databases and provide software solution recommendations
• Experience with or basic understanding of SQL, Microsoft Excel, R or Python, data visualization tools such as Tableau or PowerBI, Postman
• Experience in methodologies and processes for managing databases
• Demonstrated experience in handling large data sets and relational databases
• Good written and verbal communication skills
• TB Test Clearance
• Criminal Justice Fingerprint Clearance
• Complete the School’s Transportation/Driving Policy and provide all supporting documentation to the School’s Human Resources Department

Education

• Bachelor’s degree from an accredited university or college in computer science OR at least 1 year working experience as a data analyst or a related field

Physical Demands

The physical requirements indicated below are examples of the physical aspects that persons within this classification must perform in carrying out essential job functions with or without reasonable accommodations. Spends the majority of the day using a computer standing and/or sitting at a desk with forward bending from the waist, leaning on forearms, and looking down, which requires neck flexion. Will periodically exert 10 to 20 pounds of force to lift, carry, push, pull or otherwise move objects. Will sit most of the time but may walk or stand for brief periods of time: will occasionally be required to bend, stoop, crouch, kneel, reach above shoulder level, and/or to ascend and descend a step stool or step ladder. Must possess the ability to hear and perceive the nature of sound. Must possess visual acuity and depth perception. Must be capable of providing oral information, both in person, virtually, and over the telephone. Must possess the manual dexterity to operate business-related equipment and to handle and work with various objects and materials. It is occasionally necessary to lift and carry boxes weighing up to 40-50lbs.

Work Environment

The work location for this position is designated by the supervisor and the job description to include in-person and virtual settings as needed by the School, including individual and small groups, indoors and outdoors, and may experience the following possible exposures: heat or cold extremes; as well as fumes; odors; dust; noise level, which is moderate to loud; a higher level of exposure to illness or infection from students and/or families; intervening to stop conflicts between angry or emotionally upset students; dealing with students, parents, employees and who may exhibit unpredictable or anti-social behavior; and, exposed to students who may ask inappropriate personal questions, display socially unacceptable behavior, display physically aggressive behavior, and insult your personal characteristics including appearance, age, sex, and race., * Bachelor’s (Preferred), * How many years of SQL experience do you have? (Indicate with number)

• Health Insurance (Medical, Dental, and Vision)
• Flexible Spending Account
• Health Savings Account
• Paid Time Off
• Paid Sick Leave
• Retirement plan (403b with employer match and 457), * Dental insurance
• Health insurance
• Health savings account
• Paid sick time
• Paid time off
• Retirement plan
• Vision insurance