Impact Data Analyst – Dual Generation

DEPARTMENT:    Community Impact / Grants / Impact Data Team    

GRADE:    22
IMMEDIATE SUPERVISOR:    Impact Data Officer    

EXEMPTION STATUS:    Exempt
DATE POSTED-INTERNAL/EXTERNAL:    6/17/2024    

EXPIRES: 7/206/2024

JOB LOCATION:    San Antonio, TX
SALARY RANGE:    $65,000 - $70,000    

RELOCATION ALLOWANCE:    No
WORK MODALITY:    Hybrid-remote (3 days on-site and up to 2 days remote)    

EMPLOYEE CLASSIFICATION:    Individual Contributor

ABOUT US
United Way of San Antonio and Bexar County unites the community to identify and solve our most critical issues. We are dedicated to improving people's lives and creating community-level change. Our work includes leading cross-sector collaborations, advocating for public policy changes and investing in programs that prevent problems from happening in the first place for those in need. Improving quality of life and advancing the greater good involves focusing in four impact areas:  preparing children for kindergarten; empowering students to graduate and reach their full potential; helping individuals and families become self-sufficient; providing a safety net of services for those in crisis.

JOB SUMMARY
The role of Impact Data Analyst supports ongoing measurement, data, and evaluation work for United Way’s community impact investments and promotes community, collective impact, and individual program level progress.

The Impact Data Analyst designs measurement processes, reviews and analyzes data, but also helps tell its story and facilitate its use towards continuous improvement in a collective impact environment. The role requires the application of technical skills including the sourcing and analysis of various types of quantitative and qualitative data as well as the design and implementation of data dashboards/visualizations and creation of reports. It includes the presentation of data and conclusions drawn to internal and external audiences. The Impact Data Analyst is charged to facilitate collective data conversations and provide individual support to United Way staff and partner agencies in building their capacity to use and apply data. The position is embedded in and collaborates with United Way’s Impact Data Team of six. See United Way’s website for more information on our overall Community Impact work.

This role is assigned to its Dual Generation Initiative, a multi-sector and multi-agency effort to support families with young children 0-10 years on both San Antonio’s Eastside and Westside. Its primary goals are to support families to achieve financial independence through a holistic effort encompassing simultaneous high quality whole family supports in the areas of family coaching, workforce development, child and youth development, and family well-being. For an overview of the concept of Two-Generation work see a high-level description by Ascend at the Aspen Institute.  For information on the United Way of San Antonio Dual Generation initiative see the United Way website.

The shared client management system AACN SYNC based on Salesforce is utilized to allow partner agencies to coordinate work with families served through the initiative. It houses the client-level progress and outcome data on the Dual Generation Initiative families supported by all partner agencies and is used to evaluate initiative outcomes over time. Supporting the use of the AACN SYNC platform, furthering its development to meet the evolving needs of the Dual Generation Initiative, and use of its data for analysis, reporting, learning, and action are at the core of the responsibilities of the position.

PRIMARY DUTIES AND RESPONSIBILITES
1.    Data Collection and Management
a.    Collaborate with United Way stakeholders to identify data needs and sources.
b.    Develop and implement data collection systems and strategies to ensure accuracy and consistency.
c.    Manage and maintain databases, ensuring data integrity and security.
2.    Data Analysis and Interpretation
a.    Utilize statistical techniques and tools to analyze quantitative and qualitative datasets.
b.    Identify trends, patterns, and correlations within the data to extract actionable insights.
c.    Interpret findings and communicate results effectively to stakeholders through reports, presentations, and visualizations.
3.    Performance Monitoring and Evaluation
a.    Develop and implement performance measures/key performance indicators (KPIs) to assess the effectiveness of programs and initiatives.
b.    Monitor and evaluate organizational performance against established metrics.
c.    Participate in accountability reviews at the agency and program level.
d.    Provide recommendations for improvement based on data analysis and participate in continuous improvement efforts.
4.    Data Visualization, Reporting, and Storytelling
a.    Design and create visually compelling dashboards, charts, and graphs to communicate complex data insights.
b.    Prepare regular reports and presentations for internal and external stakeholders.
c.    Customize reports to meet specific needs and preferences of different audiences.
d.    Craft narratives to convey emerging stories 
5.    Collaboration and Support
a.    Collaborate with cross-functional teams within United Way to address data-related challenges and opportunities.
b.    Support collective impact efforts through data presentation and facilitation at stakeholder meetings.
c.    Provide guidance, support, and training to United Way and partner agency staff on data-related issues, including data collection methods and analysis techniques.
d.    Stay informed about advancements in evaluation, data analytics, and technology to continuously improve processes and methodologies.
 

EDUCATION AND EXPERIENCE
•    Bachelor's degree required; Master's degree preferred.
•    Proven experience in data analysis, preferably in a human services nonprofit, social impact, or philanthropic setting with three to five years of experience.
•    Experience working with complex datasets and database structures.
•    Experience and high comfort level in facilitation of data conversations and coaching of diverse groups of stakeholders.
•    Experience with collective impact work in the context of data collection, data interpretation, and data use for improvement.
•    Experience in the application of data as an element of continuous improvement frameworks (e.g. Results Based Accountability, PDSA, Six Sigma, Theory of Change models); experience with Results Based Accountability preferred.
•    Experience in the design, collection, and analysis of surveys and forms (e.g. through Qualtrics, Jotform, Formstack).
•    Experience in qualitative data collection and analysis (e.g. facilitation of focus groups, thematic analysis).
•    Experience in data reporting to public and private funders (local, state, regional, federal).
 

KNOWLEDGE, SKILLS & ABILITIES INFORMATION
•    Proficiency in client management systems (e.g. Salesforce, Apricot 360, Caseworthy) use, data quality assurance, data reporting, data extraction, end user training, and user support.
•    Proficiency in statistical software (e.g. R, Python, STATA, SAS), data manipulation/ETL (e.g. SQL, Tableau Prep, KNIME, Alteryx) and data visualization tools (e.g. Tableau, Power BI).
•    Proficiency with Salesforce native reporting and dashboard design and data access and utilization through 3rd party tools.
•    Excellent communication and presentation abilities, with the capacity to translate complex findings into clear and actionable insights.
•    Ability to work as an independent member of a highly interdependent and interdisciplinary team.
•    Strong analytical and problem-solving skills with attention to detail.
•    Demonstrated ability to manipulate datasets to identify and analyze trends and complex relationships.
•    Ability to work both independently and collaboratively in a dynamic environment.
•    Proficient in the use of web-based tools for file collaboration (e.g. SharePoint and Box), communication (e.g. Microsoft Teams, Slack), and project management (e.g. Monday.com).
•    Advanced skills in Excel and the remainder of the Microsoft Office suite.
•    Ability to adapt quickly and learn how to apply new analysis methods and tools.
•    Strong verbal and written communication skills.
 

UNITED WAY COMPETENCIES

Core Competencies (all United Way Professionals):

Mission Focused, Relationship Oriented, Collaborator, Results Driven, Brand Steward

BENEFITS
•    Employer-subsidized healthcare plan with employer-funded HRA offered.
•    Group dental, vision, life insurance and other insurance products are available.
•    Paid holidays, personal and sick leave time.
•    403(b) retirement plan with employer matching available.

WORK ENVIRONMENT
•    Normal nonprofit office environment with little exposure to dust, noise and extreme temperatures.
•    Extended work on personal computing equipment, telephone, multi-functioning printer and calculator.
•    Reliable transportation is required with the ability to travel to and from meetings, training sessions or other business-related events locally, routinely and around the state and nationally, occasionally.
•    Monday-Friday, 8:15 am to 4:45 pm work week with occasional evening and weekend hours.
        

PHYSICAL DEMANDS
•    Sedentary work on a PC; sitting for extended periods of time, routinely. 
•    Movement within the office and during external meetings and events, regularly.
•    Bends, stoops and twists, occasionally.
•    Exerts up to 25 lbs. of force, occasionally.
•    Facilitates, presents and collaboratively interacts with others, routinely.
•    Perform repetitive tasks, i.e., typing and texting, routinely.

The above statements are intended to describe the general nature and level of work being performed by associates assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed. The contents of this job description may change as deemed necessary by United Way of San Antonio and Bexar County.

APPLY
To submit your application visit https://recruiting.paylocity.com/recruiting/jobs/All/c1a895ce-f28e-4dac…. 
•    Applications WILL NOT be accepted via email.
•    Contact uwjobs@unitedwaysatx.org should you experience problems submitting your application.

United Way of San Antonio and Bexar County is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information.

United Way of San Antonio and Bexar County is committed to the full inclusion of all qualified individuals. As part of this commitment, UWSA will ensure that persons with disabilities are provided reasonable accommodations if reasonable accommodation is needed to participate in the job application, interview process, or to perform essential job functions, and/or to receive other benefits and privileges of employment.

United Way of San Antonio and Bexar County | 700 South Alamo St., San Antonio TX, 78205 | www.unitedwaysatx.org