General Summary:
The Data Analyst I’s role is to review data and write required reports for stakeholders. This individual will complete tickets from a queue independently or with the help of other data analysts. This position requires strong administrative experience and the ability to work in a fast-paced environment. Adapting new and developing AI technologies such as Aider, ChatGPT, Copilot+++, Cursor, etc., to promote work productivity.
Essential Functions include, but are not limited to the following:*
● Maintain and manage separate databases for all testing programs
● Maintain and manage external CAHSEE database and cooperate with SIS vendor to ensure that all CAHSEE scores are input and displayed
● Submit yearly reports to CDE (PAIF, R-30 Language Census, SNOR, ASAM, and Civil Rights Reports)
● Assist as needed in the tracking and collection of data for CALPADS
● Create reports to evaluate effectiveness of company educational programs using testing, demographic, and curriculum data
● Supply regression analyses to WASC committees as needed
● Collect, format, and distribute data from public sources (API, AYP, ASAM, etc.) as needed
● Assist with test distribution and logistics as necessary
● Manage nightly SIS database download on local server
● Maintain a technical knowledge of CALPADS files and keep up with changes in the CALPADS system
● Other duties as assigned by supervisor
Knowledge, Skills and Abilities Required:
● Minimum of 2 years of experience working with SQL and SPSS (2005 and 2008 editions) programs
● Experience with Microsoft Excel; working knowledge of Word and PowerPoint
● Ability to maintain pre existing databases in SQL and ability to create and customize new files as needed
● Good written and oral communication skills
● Knowledge of Crystal reports
● Knowledge of Quick reports
● Ability to conceptualize, create, and explain analytical regressions
● Fluent with AI tools Cursor, Copilot+++, ChatGPT, Aider, etc
Education and Experience:
● Bachelor’s degree, strongly preferred
● Related training or experience
Job Type: Full-time
Pay: $25.00 - $29.00 per hour
Experience:
- SQL: 2 years (Required)
- with AI tools Cursor, Copilot+++, ChatGPT, Aider, etc: 1 year (Required)
Ability to Commute:
- Pasadena, CA 91107 (Preferred)
Work Location: Hybrid remote in Pasadena, CA 91107