Data and Reporting Analyst - Full-time

*Candidates must be local to either Los Angeles, CA or Oakland, CA

Are you dedicated to empowering and supporting youth, regardless of their background? We're searching for passionate individuals to make a positive impact on the lives of foster youth. Become an integral part of their transformative journey and join the First Place for Youth team.

About First Place for Youth We’re a leading non-profit organization dedicated to supporting foster youth in their transition to adulthood, with a focus on education, employment, and housing. We believe that all young people deserve the opportunity to thrive and lead successful, independent lives. Our comprehensive programs empower foster youth to overcome the unique challenges they face and build the skills, confidence, and connections they need to succeed.

Why Work at First Place For Youth:

• Meaningful Impact:  Help to transform the lives of foster youth on the cusp of adulthood. Your role will support them in their journey to conquer challenges, achieve independence, and fulfill their aspirations.
• Innovative Approach: We thrive on innovation, pushing the boundaries of foster care support. Your voice here matters, and you’ll contribute to programs that redefine the futures of these young lives.
• Collaborative and Supportive Environment: Embrace a dynamic and supportive workplace, where every team member is valued. Together, we're a force dedicated to uplifting youth. Expect professional growth, fueled by teamwork and collaboration.
• Comprehensive Benefits: We value the well-being of our employees and offer a comprehensive benefits package. From health and wellness benefits to retirement plans, we ensure that our team members are taken care of so they can focus on their important work supporting foster youth.
• Culture of Diversity and Inclusion: We celebrate diversity in every form. At First Place for Youth, inclusivity reigns, creating a workplace where all voices are heard, respected, and empowered.

POSITION SUMMARY: The Data and Reporting Analyst reports to the Evaluation & Learning manager. This is a key member of the Department providing data analysis, visualization, and reporting support to First Place for Youth, its Network Affiliate partners throughout the United States, and its public, foundation, and corporate funders. The Evaluation and Learning Department is focused on strengthening the organization’s reputation as an analytics leader in the child welfare and non-profit spaces, by making data and reports more accessible and informative to staff, leadership, partner organizations and funders, through the creation of well-designed dashboards, simple-to-interpret metrics, and effective training guides.

Essential Duties and Responsibilities: Include the following. Other duties may be assigned.

Primary responsibilities of the Data and Reporting Analyst include augmenting and maintaining the reporting infrastructure for the organization, querying the data warehouse with MySQL in addition to developing reports/dashboards within the case management system (Apricot) and business intelligence software platform (Power BI). The Data and Reporting Analyst is also responsible for

• Constructing, augmenting, and/or monitoring series of internal dashboards in Power BI used by front line staff and senior leadership to drive action by staff and/or impact for the youth we serve, ensure compliance with contracts/donor reporting requirements, and support staff and managers with performance management.
• Monitoring, updating, and/or where necessary, creating new reports in Apricot; and identifying strategies to reduce the number of questions, forms, and assessments we ask our staff as part of broader data reduction efforts.
• Providing documentation, training or technical assistance to staff in accessing and using Apricot and Power BI, manage staff accounts and permissions, provide data entry support to direct service staff when necessary, and maintain confidential data files.
• Helping to manage internal metrics dictionary and ensure reports are accurate.
• Collaborating with program staff and managers to ensure accuracy and reliability of agency data, and full compliance with internal and external data standards.
• Supporting improvements to the organization’s data warehouse and helping to automate key reports.
• Responding to complex data requests that require advanced reporting capabilities, and automating the production of standard ones.
• Completing monthly, quarterly, and annual reports in collaboration with the Program Department.
• Supporting the creation of novel analyses and/or new data visualizations and reports to monitor data quality, support the evaluation of our impact, or improve the design and quality of data presented.
• Work in collaboration with colleagues to achieve organizational, departmental, and individual priorities.
• Troubleshoot errors/bugs in Apricot & Power BI and work with vendors to resolve.

Qualification and Requirements:

• A Bachelor's degree in related field such as computer science, data analytics, economics, or public policy required.
• Two years of experience as a data/business intelligence analyst with in-depth experience working with and using MySQL and data visualization in Power BI is required.
• Extensive experience and demonstrated knowledge of building and updating reports/dashboards in data visualization tool (ideal candidates will have experience doing so with Microsoft’s Power BI).
• Experience providing database or data reporting support in a social service agency is a plus.
• Strong Microsoft Excel, case management system and business intelligence software experience preferred. Previous experience with Apricot case management software strongly preferred.
• Demonstrated ability to problem-solve complex problems and identify and scale solutions.
• Ability to effectively monitor numerous data related details and accurately identify any errors or missing information.
• Attention to Detail – Ability to work with high level of detail, work has high level of professional polish down to smallest details, documents and products are well thought out and clear, database is organized and up to date.

Benefits:

• Full-time position
• 15 days of vacation time in year one
• 12 days of sick time
• 2 flexible holidays
• 14 paid holidays
• Paid sabbatical
• Paid maternity and paternity leave
• Employee’s choice of Kaiser or UCH HMO/PPO Up to 90% of premium covered by First Place on certain plans
• Delta Dental Premium PPO
• VSP Vision
• 401k Retirement Savings with Match

*We do not offer relocation assistance Local candidates preferred

*Pay will be determined based on Education and Experience.

If you are passionate about making a difference in the lives of transition age foster youth and want to join a dynamic and impactful organization, we invite you to apply. Together, let's empower transition age foster youth to achieve their dreams and build a brighter future. To learn more about First Place For Youth and view our current job openings, please visit our website at www.firstplaceforyouth.org/careers.

We are unable to sponsor work visas now or in the future.

First Place will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act, the San Francisco Fair Chance Ordinance, and applicable law. You do not need to disclose your criminal history or participate in a background check until a conditional job offer is made to you. Find out more about the Fair Chance Act by visiting the California Civil Rights Department Fair Chance Act webpage or reviewing this guidance provide by the City of San Francisco. For additional information regarding your rights, please also review the Summary of Your Rights Under the FCRA.