Senior Systems Data Analyst

Employment Type : Full-time | Exemption Status : Exempt

Salary : $118,657.43

Location : Bonita, CA ( full-time in office )

Purpose of Role :

Under general supervision, the Senior Systems Data Analyst develops and implements data analyses, data collection systems and other strategies that optimize efficiency and quality of the Agency. Develops systems and applications to store and analyze data, and prepares reports to interpret and summarize the results. Provides user support for data analysis tools. Provides leadership and ensures deadlines are met.

Summary of Responsibilities :

• Generates and distributes reports to management regarding various agency data points including, but not limited to : programs’ enrollments, participants’ terminations, recertification, discrepancies and File Error reports.
• Conducts data analysis for reporting purposes.
• Compares data and other reports for matching purposes, informing supervisor and / or appropriate department of any inaccuracies and / or omissions.
• Develops systems, including creating and programming databases and user experience (UX), to store and interpret various agency data points.
• Works with Microsoft SQL Server, including creating databases and queries.
• Researches discrepancies to ensure accuracy, as needed.
• Prepares reports and performs special studies as required.
• Develops, monitors, and revises data and / or procedures as required.
• Assists in creating and applying systems and procedures for effective management of the organization.
• Communicates effectively with key staff in all departments in order to obtain information necessary to complete reports and special projects required by management.
• Creates and maintains innovative tracking systems as required.
• Creates and maintains graphs, charts and other graphic elements for presentations to management as required.
• Serves as a resource to team members, responding to questions and providing guidance.
• Aid the development of the teams’ ability to deal with and resolve difficult and complex projects as needed.
• Achieve goals through coordination ideas and resources.
• Function as a role model to create a culture sensitive to the diverse socio-economic, cultural, and linguistic needs of the families CDA serves.
• Create a positive environment to build cooperation, mutual respect and team unity.
• Prioritize and coordinate team members by providing purpose, motivation, and inspiration.
• Demonstrate flexibility and agility to accomplish CDA’s mission.
• As needed, may participate in special projects and collaborate with other Data Analysts from other departments.
• Provides pertinent information to other departments as requested.
• May participate in audits and file reviews, as needed.
• May generate specific reports and conduct appropriate follow-up and / or maintenance of reports, as needed.
• May be responsible for leading, coordinating and training special projects.
• Serves as a general back up for other Data Analysts in other departments.
• Serves as back up to the general IT Help Desk.

Additional Duties and Responsibilities :

Minimum Qualifications :

Bachelor’s Degree in Computer Science and / or related field, or three-year related experience and / or training, or equivalent combination of education and experience. Education, training and / or experience that demonstrate possession of knowledge, skills and abilities listed above.

Valid California driver’s license. Certification of good DMV record. Valid auto registration and insurance. Position may require occasional driving to and from locations to meet with parents and / or for the purpose of training.

Must have Knowledge of CDA’s goals and objectives, vision, mission, and values; and California Department of Education Child Care Division rules and regulations. Must have advanced skills in Microsoft Excel, Microsoft SQL, various programming languages, data analysis tools, and server infrastructure. Must have experience with designing and programming user experience (UX) and user interfaces (UI). General fundamentals of Server architecture and infrastructure required, including cloud-based infrastructure.

Must have advanced program and funding contract knowledge sufficient to analyze, interpret, critique and / or qualify as a resource to other fiscal analysts. Must have ability to prepare comprehensive reports and recommendations; to check and compare records of data for accuracy; to refer to schedules and charts, and to research, compile, analyze and disseminate data and information.

Must have ability to prioritize workload to ensure deadlines are met, and initiate prompt and professional responses to coworkers and other individuals with minimum supervision. Ability to calculate mathematical equations and formulas accurately; ability to read and interpret documents such as safety rules, operating and maintenance instructions, rules and regulations, and procedure manuals; ability to maintain composure, work well under pressure and meet strict deadlines.

Must have ability to maintain confidentiality and follow privacy laws, rules and regulations, and procedures in regards to record keeping, using appropriate judgement in answering questions, releasing information considering the consequences of disclosure; adapt to new situations, policies or procedures, demonstrating flexibility in the workplace promoting a positive atmosphere; communicate and treat all individuals with dignity and respect, responding in a cooperative, solution-oriented manner; understand and respect diversity in the workplace / community, showing consideration by communicating tactfully and sensitively at all times.

Must have ability to maintain professional relationships with all avoiding conflicts of interest, and reporting when a relationship is established in order to take appropriate steps for removing what could become a conflict of interest; handle crisis situations calmly and work with individuals of varying educational, social-economic backgrounds; define problems, collect data, establish facts, and draw conclusions informing the supervisor or appropriate others of problems.

Must be able to operate office equipment such as personal computers, copy machines, fax machines, telephones, calculators and scanners on a daily basis to review, update, track, and research data, information and / or produce reports; proficient in Microsoft Office including Word, Excel, Power Point and Outlook.

Working Environment

Office environment; exposure to computer screens and other basic office equipment; the noise level in the work environment is usually low to moderate. Reasonable accommodations in the work environment may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands

The physical characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this classification. Reasonable accommodations may be made to enable an individual with a qualified disability to perform the essential functions of a job, on a case-by-case basis.

Must have the ability to safely use a variety of equipment and tools to perform job satisfactorily; drive safely to and from post office for daily pick up and / or delivery of mail.

Continuous : Upward and downward flexion of the neck; frequent : sitting, repetitive use of hands to operate computers, printers, and copiers; occasional : walking, standing, bending, and twisting of neck, bending and twisting of waist, squatting, grasping, reaching above and below shoulder level.

Regularly : Lift and carry heavy items such as copy paper and mail bins weighing up to 50 pounds or more, as needed.

Periodic : Lift and move furniture and / or equipment, such as desks, file cabinets, copy machines, printers; hang items on walls, and install keyboard trays.

This list of job duties and responsibilities is not intended to be all-inclusive and may be expanded from time to time to include other duties or responsibilities that may be deemed necessary.

Benefits :