FIRST 5 ALAMEDA COUNTY
First 5 Alameda County (F5AC)’s vision is that every child in Alameda County will have optimal health, development and well-being to reach his or her greatest potential. Our primary goals are to ensure that children are ready for kindergarten-third grade success and are free from abuse and neglect. Please see our website: www.first5alameda.org for our Strategic Plan and reports on the impact of our work.
The Data Analyst manages data analysis and reporting, supports program evaluation projects, conducts data entry projects, and contributes to database design, development, and testing. The Data Analyst also provides helpdesk support, responds to users of data systems and troubleshoots technical issues opened to the helpdesk.
This full-time, non-exempt position reports to the Evaluation and Technology Administrator, and is classified in the Manager level.
DUTIES AND RESPONSIBILITIES include, but are not limited to, the following. Nonessential functions are designated NE. Other duties may be assigned.
Data Analysis and Evaluation Support
Train, coordinate, support and/or monitor the quality of work of any staff who work on the Agency’s data management systems (ECCOnline, ECChange, Pathways) and MIP (the Agency’s financial management system)
Develop queries and generate data as required by Agency programs
Analyze and prepare data reports including coordination of program reporting for annual reports and other data projects
Contribute to design and public presentation of data
Synthesize program data to inform strategic planning and accountability reporting
Generate and provide program data to appropriate community-based agencies such as colleges, Resource and Referral agencies, State colleagues, etc., as requested
Provide technical support to Administrative Associates to produce mass mailings and provide other program support activities as necessary
Database Design and Technology Support
Responsible for the day to day operation of agency information systems
Collaborate with Evaluation and Technology staff in designing, developing and testing data systems in accordance with programmatic directives and accountability reporting requirements
Document database features and functionality and related user interfaces
Maintain and support databases in conjunction with third party developers
Develop common data queries and updates to user interfaces, as appropriate
Collaborate with Finance to ensure timely and accurate reconciliation of data between MIP and ECCOnline
Liaise the needs of program staff through development specs for third party developers
Provide phone support to external users of Agency databases to trouble shoot and resolve technical issues
Bachelor degree in social sciences, health statistics, epidemiology, public health, public policy, or related field
Minimum three years of full-time research or data analysis experience, which has included at least two years of database experience including programming, working with and enhancing relational databases and web pages. Some experience with data review and report writing, program evaluation, and/or administrative or financial record-keeping required. A Master’s degree may substitute for one year of the required experience.
May occasionally travel within Alameda County
KNOWLEDGE AND ABILITIES
Relational database systems such as SQL Server or MS Access
Practices of database design, SQL and intermediate relational database queries
Principles of quantitative analysis
Research and report preparation principles
Basic program evaluation methodologies
Basic principles of public administration
Basic budgetary and financial recordkeeping procedures
Proficiency in Microsoft Office Suite, prefer advanced level Excel and Access, use of the internet for research
Web interface programming such as ASPX, ActiveX, .NET, HTML and Visual Basic a plus
Conduct data analysis using SPSS, SAS, STATA, or other data analysis software package
Continually enhance technical skills as technical applications evolve
Read, analyze and interpret technical syntax and troubleshoot programming code
Train staff and partners with varying technical abilities on using data systems
Effectively communicate technical and procedural language using common terms
Strictly follow database development documentation guidelines
Develop and maintain data collection and reporting processes
Demonstrate cultural awareness and sensitivity in a variety of contexts
Work well under pressure and in a multidisciplinary team setting, including collaboration and coordination with off-site third party developers and staff
Think proactively, anticipate and identify problems, gather information/data to analyze situations, and develop effective recommendations and solutions
Exercise sound judgment within generally established policies and procedures to select appropriate strategies and make and carry out effective decisions
Communicate clearly and effectively, orally and in writing, to staff, the Commission, partners, and the public
Read, analyze and interpret common professional publications, policy documents, financial reports and related technical and business documents and information
Demonstrate initiative and work independently with little supervision
Plan, prioritize, and organize database-related requests and work to ensure organizational and program goals are achieved
Meet attendance requirements of the position, be punctual and timely in meeting all requirements for work performance
Adapt, with minimal or no advance notice, to changes in agency operations and work assignments or procedures
PHYSICAL DEMANDS AND WORK ENVIRONMENT
The physical demands and work environment described below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Mobility to work in a standard office environment and attend off-site meetings; mobility and manual dexterity to use standard office equipment and handle documents; vision to read handwritten and printed materials and a computer screen; hearing and speech to communicate in person and by telephone
Frequently program, type, and/or enter data while sitting for approximately 6-8 hours per day
Provide help desk phone support for up to 8 hours per day several days per week
May occasionally lift and/or move heavy (up to 25 pounds) items such as furniture and boxes
The primary work environment is a normal office setting. The noise level is usually moderate.
$55,000 ($26.44/hour) to start, plus excellent benefits
HOW TO APPLY
Please send a cover letter and your resume to:
First 5 Alameda County
1115 Atlantic Avenue
Alameda, CA 94501
Open until filled
Equal Opportunity Employment
First 5 Alameda County is an equal opportunity employer. Women, ethnic and racial minorities and persons with disabilities are encouraged to apply.
It is the policy of First 5 Alameda County to afford equal opportunity in all aspects of employment to all persons without discrimination on the basis of race, religion (including religious dress or grooming), sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), national origin, ethnicity, age, physical or mental disabilities, color, marital status, sexual orientation, gender identity or expression, genetic information, medical condition, exercise of rights under the Pregnancy Disability Leave Law or the California Family Rights Act, or any other basis protected by law. This policy shall apply to all employees and applicants for employment, and extends to all phases of employment, including recruitment, hiring, training, promotion, discharge or layoff, rehiring, compensation, and benefits.