Job Description
Job Description
We are seeking a skilled Database Analyst to join our team in San Francisco, California. This position is a contract-to-permanent opportunity, requiring a detail-oriented individual with a strong technical background and hands-on experience in database management and data migration. The role involves working on-site three days a week and contributing to the seamless integration and optimization of organizational data systems.
Responsibilities :
- Lead the migration of data from legacy systems into Apricot / Bonterra, ensuring accuracy and consistency throughout the process.
- Utilize Apricot’s tools to design and modify forms, fields, and import mappings for complex datasets.
- Extract, transform, and clean data from scattered legacy databases using SQL Server and Access.
- Validate, troubleshoot, and verify data to maintain compliance with reporting standards and privacy regulations.
- Develop training materials and provide hands-on support to non-technical staff during the transition to a unified data system.
- Design and implement reporting and visualization solutions using tools like Power BI and Tableau.
- Collaborate with diverse teams to ensure data integrity and promote consistent practices across all programs.
- Monitor and improve data quality to support grant and contract reporting needs.
- Provide technical guidance to staff and foster a collaborative, mission-driven work environment.
- Minimum of 3 years of experience in database analysis and data migration.
- Proficiency in Apricot / Bonterra for data mapping, cleaning, and importing.
- Strong knowledge of SQL Server and Access.
- Ability to extract, normalize, and transform data from multiple systems.
- Experience with reporting tools such as Power BI and Tableau.
- Excellent analytical and troubleshooting skills.
- Proven ability to train and support non-technical staff effectively.
- Familiarity with nonprofit environments and equity-focused practices.