> Markdown version of [/jobs/ext/520118-database-and-analytics-specialist](https://www.wearedevelopers.com/jobs/ext/520118-database-and-analytics-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database and Analytics Specialist - **Company:** JFS, Inc. - **Location:** Los Gatos, CA, United States - **Salary:** $75,000.0 - $85,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Spreadsheets, Information Systems, Databases, Data Validation, Data Cleansing, Data Deduplication, Data Dictionary, Data Integrity, Data Visualization, Operational Data Store, Pivot Tables, Power BI, SQL Databases, Data Streaming, Tableau (Software), Google Data Studio, Powerquery, Data Analytics, Conditional Formatting - **Published:** June 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=38b63649e1f19638 ## About the Role Do you have experience in SQL?, Do you have a Bachelor's degree?, · Bachelor's degree in data analytics, information systems, or a related field; equivalent experience may be considered. Experience: · Experience working with data from case management systems, nonprofit databases, spreadsheets, or similar platforms. · Experience creating reports, dashboards, charts, visualizations, or data summaries using Excel, Power BI, Tableau, Looker Studio, or similar platforms. · Experience with Bonterra Apricot or a comparable case management database. · Experience in nonprofit, human services, health care, social services, housing, aging services, refugee services, or community-based organization. · Experience with data quality improvement, record reconciliation, compliance reporting, or audit preparation in a nonprofit or human services setting. · Experience with Power Query, Power BI, Tableau, Looker Studio, SQL, data dictionaries, report specifications, cleanup logs, field maps, SOPs, or data entry guides. · Familiarity with PII/PHI, HIPAA-related confidentiality practices, role-based access, and secure handling of sensitive client and organizational data. · Familiarity with Cal-AIM, Enhanced Care Management (ECM), or Community Supports programs. Skills & Competencies: · Strong ability to review, clean, validate, reconcile, organize, export, transform, and prepare data from multiple sources for reporting and analysis. · Strong Excel skills, including filters, formulas, pivot tables, lookups, conditional formatting, data validation, sorting, deduplication, and data cleanup. · Ability to analyze data, identify trends, interpret findings, and communicate insights clearly to non-technical audiences. · Ability to navigate multiple systems, manage competing priorities, and collaborate effectively across program, finance, development, and operations teams. · Strong attention to detail, commitment to data accuracy, and demonstrated ability to identify patterns in data quality issues and recommend practical improvements. · Demonstrates alignment with JFSSV's core values, including Welcoming the Stranger, Repairing the World, and Treating Everyone with Respect and Dignity, in all aspects of work and collaboration. ## Description The Database and Analytics Specialist ensures data quality, reporting, and analytical insight across JFSSV's programs, with a primary focus on Cal-AIM. Working closely with program staff and leadership, this role maintains data integrity in Bonterra Apricot and other platforms, reviews records and workflows to identify data quality issues and process improvements and produces clear reporting that supports decision-making across Cal-AIM and the broader organization., · Data Quality, Systems, and Workflow Improvement: Review and maintain data quality across Apricot and other platforms; identify and resolve missing, duplicate, or inconsistent records; navigate cross-system data flows to support mapping, field comparisons, and data requests; and recommend workflow and process improvements that reduce redundant entry and strengthen reporting accuracy. · Reporting, Analytics, and Insight Development: Create standard and ad hoc reports using Apricot, Excel, Power BI, or similar platforms; analyze program and operational data to identify trends, risks, and opportunities. · Data Visualization and Communication: Transform data into clear dashboards, charts, and visual reports tailored to varied audiences including program staff, leadership, and board members; communicate findings in plain language for non-technical stakeholders. · Cal-AIM and Case Management Data Support: Ensure Cal-AIM ECM and Community Supports records in Apricot are complete and accurate; review client, service, outcome, authorization, and documentation data for consistency with program standards. · Documentation, Process Improvement, and Training: Maintain data dictionaries, SOPs, field definitions, and data quality guidelines; train staff on data entry standards, reports, and dashboards to support consistent, high-quality documentation across the organization. · Other duties as assigned ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)