Data and Product Analyst- Nonprofit/Remote

Summary

The Connective is a civic technology, design, and collective action nonprofit focused on transforming social services into a more connected, empathetic, and accessible system. The Data and Product Analyst will clean and analyze program data, create visualizations and geospatial maps, develop actionable insights, and support Salesforce CRM administration and product development. The role also provides data analysis, quality assurance, reporting, workflow optimization, and stakeholder collaboration to improve service delivery.

Responsibilities

• Clean, join, and consolidate Connective's substantial program data from multiple sources. Perform complex quantitative data analysis to inform program strategy and support partner entities (nonprofit, government, etc.) Leverage CRM data and external sources to shed light on community trends, client needs, and internal metrics
• Build geospatial maps for public consumption and program evaluation purposes. Create tabular and visualization reports using tools like Tableau or Power BI
• Perform extensive data validation and quality assurance analysis within large datasets. Build proactive data validation automation to catch data integrity issues
• Provide analytic services related to grant reporting and fundraising proposals. Analyze problems and determine root causes through data-driven approaches. Aggregate data from multiple sources to create analyses, dashboards and supporting reports. Lead data sharing strategy with external partners. Operationalize data processes to provide automated dashboards and reports within Salesforce
• Support strategy, communications and development, and project teams with comprehensive data analysis
• Identify data issues within Salesforce and develop solutions to maintain database performance. Support Salesforce configuration to meet organizational goals and product backlog requirements. Manage product backlog priorities for CRM improvements
• Optimize Connective's Salesforce instance to improve internal workflows and user experience. Assist with custom fields, validation rules, workflow rules, and process flows in Salesforce. Coordinate with internal and external users on programmatic objectives and CRM needs. Support building new Salesforce functionality to enhance service delivery
• Work with program teams to understand and address data pain points and needs. Coordinate with internal and external stakeholders on programmatic objectives. Communicate insights effectively to executive-level partners and senior management

Skills

• Strong interest in improving how vulnerable communities access social services
• Power user in at least one of these technologies: Microsoft Excel, Python, R, or SQL
• Power user in a data visualization tool such as Tableau or Microsoft Power BI
• Advanced proficiency with Microsoft Excel for complex data analysis (data cleansing, consolidation, nested logic)
• Experience with Salesforce data mining and analysis
• Ability to build tabular and graphic reports as needed
• Demonstrated history of quickly learning and adopting new data tools
• Excellent communication skills with proven track record in collaborative environments
• Exceptional organizational skills and ability to prioritize multiple projects
• Demonstrated ability to think big picture while managing detailed work
• Hands-on Salesforce administration experience, ideally with Non-Profit Success Pack (NPSP)
• Experience with SQL, Apex, and Salesforce Lightning Component framework
• Knowledge of custom fields, validation rules, workflow rules, and process flows in Salesforce
• Experience building programs and processes within Salesforce
• Background in human-centered design and agile methodologies
• Experience in nonprofit or social services sector

Qualifications

Must Haves

• Strong interest in improving how vulnerable communities access social services
• Power user in at least one of these technologies: Microsoft Excel, Python, R, or SQL
• Power user in a data visualization tool such as Tableau or Microsoft Power BI
• Advanced proficiency with Microsoft Excel for complex data analysis (data cleansing, consolidation, nested logic)
• Experience with Salesforce data mining and analysis
• Ability to build tabular and graphic reports as needed
• Demonstrated history of quickly learning and adopting new data tools
• Excellent communication skills with proven track record in collaborative environments
• Exceptional organizational skills and ability to prioritize multiple projects
• Demonstrated ability to think big picture while managing detailed work

Nice to Haves

• Hands-on Salesforce administration experience, ideally with Non-Profit Success Pack (NPSP)
• Experience with SQL, Apex, and Salesforce Lightning Component framework
• Knowledge of custom fields, validation rules, workflow rules, and process flows in Salesforce
• Experience building programs and processes within Salesforce
• Background in human-centered design and agile methodologies
• Experience in nonprofit or social services sector

Benefits

• Medical, dental, and vision insurance provided
• 401(k) plan available with employer matching
• Life and disability insurance for added protection
• Health savings and flexible spending accounts offered
• Paid time off
• Flexible schedule
• Remote work choices provided
• A collaborative, creative environment where everyone feels encouraged to contribute to processes, decisions, planning, and culture
• Opportunities to learn and grow with the company