Data and Product Analyst- Nonprofit

Description & Requirements Data and Product Analyst- Nonprofit Local Remote Houston Metro The Connective is seeking a highly analytical Data and Product Analyst to primarily focus on cleaning and analyzing program data, visualizing data for partners and community members, and distilling actionable insights, while also supporting our Salesforce CRM administration and product development needs. About The Connective The Connective is a growing, Houston-based civic technology, design, and collective action nonprofit. Our mission is to transform social services into a more connected, empathetic and accessible system. We do this by designing and delivering human-centered social service programs, developing cutting-edge technology tools for service providers, and leading community-wide change. Getting assistance is harder than it should be, and the process of asking for help is dehumanizing and stressful. With mounting risk of climate disasters and increasing economic pressure on low-income communities, social services are struggling to keep up and need a radical transformation. That's why we're here. We envision a future where the next crisis is not an emergency. A future in which we've prepared for and adapted to inevitable change. We dream of thriving, resilient communities that are equipped with the right tools in the moments they need them most. Our potential lies in our power to connect; we can do better through our collective knowledge and experience. Alongside our network of partners, we turn barriers into bridges and expand access for those in need. Client can only consider candidates who do not require current or future sponsorship to work within the USA. Best-in-Class Benefits and Culture: We value our employees' time and efforts. Our commitment to your success is enhanced by a competitive compensation of $67,000 - $81,000 annually, depending on experience, and an extensive benefits package that includes: Comprehensive health coverage: Medical, dental, and vision insurance provided Robust retirement planning: 401(k) plan available with employer matching Financial security: Life and disability insurance for added protection Flexible financial options: Health savings and flexible spending accounts offered Well-being and work-life balance: Paid time off, flexible schedule, and remote work within the Houston Metro area Plus, we work to maintain the best environment for our employees, where people can learn and grow with the company. We strive to provide a collaborative, creative environment where everyone feels encouraged to contribute to our processes, decisions, planning, and culture. About You Data Expert: You are dedicated to using data to better understand the community that we operate in. You are highly organized and focus on data cleanliness and are most comfortable when performing in depth data analysis. You leverage data to highlight community trends and determine how we can best serve our clients Visualization Pro: You are passionate about building dashboards and geospatial maps. Your data visualizations tell a story to communicate our successes and challenges to our team members, clients, and partners Quality Specialist: You specialize in identifying and resolving data issues, developing and implementing data quality standards, and collaborating with various teams to improve overall data management Analytical Dynamo: You know that in-depth data analysis can identify problems and determine root causes. Data security is always top of mind, while also wanting to share data publicly to support our partners and clients. CRM Professional: You look to improve our Salesforce instance to ensure data is captured accurately, products are updated and maintained, and our clients are operating in a high-tier environment. You recommend improvements to products and workflows that can improve user experience. Effective Communicator: You excel at verbal and written communication and you have strong storytelling to gain buy-in for your products. You can easily translate client needs to product strategy. You're as comfortable presenting to stakeholders as you are training team members. Equity Advocate: You believe in fostering fairness and justice within procedures, processes, and distribution of resources. In every product you develop you always aim to uplift communities that have been historically marginalized and/or are often not centered in social service design. Service-Oriented Collaborator: At the heart of your work is a commitment to serving others in the organization and at our partner organizations. You understand that as a shared service, your role is to enable and empower teams with the products they need, and you approach this with strong customer service skills, ensuring their requirements are met with precision and timeliness. Adaptable and Innovative: In a constantly evolving field and organization, you remain flexible, adapting your strategies as needed. You're not just comfortable with change; you welcome it, always seeking the next innovation that will push our mission forward. Learner and Mentor: You have a voracious appetite for learning and sharing your knowledge. You're continually seeking to expand your toolkit to better support the organization's goals. You aim to bring your team up with you, guiding others with wisdom, patience, and understanding. Solution-Oriented: Challenges excite you because they present opportunities for solutions. With every problem, big or small, you see a puzzle awaiting resolution. Innovator in Social Service Transformation: You're passionate about using data and technology to transform the landscape of social services. You understand the unique challenges in this sector and are driven to find creative solutions to overcome them. What You'll Do 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 Qualifications Required Skills Strong interest in improving how vulnerable communities access social services Experience in nonprofit or social services sector strongly preferred Experience leveraging Salesforce data mining and analysis techniques to create automated dashboards, reports, and data-driven insights. 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) 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 Preferred Skills 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 Build technology with purpose. Lead with data. Create lasting community impact. We are an equal opportunity employer that welcomes and encourages diversity in the workplace. We do not discriminate based on race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. We will consider qualified applicants with criminal histories for employment. Client can only consider candidates who do not require current or future sponsorship to work within the USA. We anticipate this posting will close in 30 days. Insperity