211 Data Coordinator

Description

ORGANIZATION SUMMARY 211 Utah, supported by United Ways of Utah, is the state's leading resource network connecting Utahns in need with local health and social services. United Way of Salt Lake, 211 Utah (Salt Lake City team), and Promise Partnership Utah are part of the Utah’s Promise organization. Together, we are committed to 100% of kids and families thriving. Our workplace is fast-paced, friendly, adaptive, and grounded in our core values: relationships, continuous improvement, results, and equity. We offer competitive compensation including a comprehensive benefit package, generous paid time off, and flexible schedules. People with diverse backgrounds and abilities are encouraged to apply. POSITION SUMMARY The Data Coordinator supports the 211 Data & Reporting Director in advancing the organization’s strategic data vision and operational reporting needs across the 211 Utah State system. Working collaboratively with the Data & Reporting Director, Operations Director, Technology & Systems Director, and 211 leadership teams, this role is responsible for supporting data management, reporting, analytics, data quality, visualization, Customer First Measurements, and systems optimization efforts that strengthen organizational decision-making and service delivery. This position helps transform operational data into actionable insights that improve both organizational performance and partner success across the statewide provider network. The Data Coordinator plays a critical role in maintaining accurate, secure, and actionable data across 211 Utah systems and platforms. This position assists in developing reports, dashboards, workflows, and analytics that support organizational goals, grant reporting, operational improvements, Community Information Exchange (CIE) initiatives, and statewide partnerships. The Data Coordinator also serves as a technical resource for data systems, supports emerging technology initiatives, and helps ensure that data is translated into meaningful insights that demonstrate the impact of 211 Utah services. The Data Coordinator also plays a key role in helping 211 Utah and its partner network improve community outcomes by identifying opportunities to increase successful referrals and overall needs met. Through data analysis, partner reporting, and continuous performance monitoring, this position helps providers better understand service gaps, referral effectiveness, customer outcomes, and opportunities to improve the percentage of client needs successfully resolved. The role serves as a bridge between data and action by providing partners with meaningful insights that strengthen service delivery and collective community impact. This role works under the direction of the Data & Reporting Director and serves as a key contributor to the implementation of the department’s data strategy, reporting framework, and continuous quality improvement efforts. PRIMARY TASK Supports the reporting, analytics, and data management needs for the 211 department at United Way of Salt Lake while assisting the Data & Reporting Director with strategic and cross-departmental initiatives. ESSENTIAL FUNCTIONS Reporting & Data Analytics Support Facilitate monthly organizational report audits and quality checks for Salesforce reporting systems. Prepare reports, dashboards, charts, graphs, narratives, and visualizations for internal leadership, partners, boards, and public-facing communications. Support Data Director in analyzing data for annual impact reports, grants, contracts, funders, and operational reporting needs. Analyze referral completion and needs met trends to identify opportunities for 211 Utah and partner organizations to improve customer outcomes. Support the generation and maintenance of standard and ad-hoc reports to ensure timely and accurate delivery of actionable insights. Run call statistics, monitor trends, and review operational data to help improve service delivery, caller experience, and service navigator performance. Conduct exploratory data analysis to identify trends, answer operational questions, and support data-informed decision-making. Extract key findings from data sets and communicate insights clearly to stakeholders with varying levels of technical expertise. Assist with maintaining publicly accessible dashboards and organizational reporting tools. Support the maintenance of reporting metrics and key performance indicators (KPIs) for departmental and organizational use. Partner Performance & Community Impact Monitor statewide provider performance using key outcome measures including needs met, referral completion, customer engagement, and service accessibility. Identify trends that improve partner effectiveness and increase successful client outcomes across the provider network. Collaborate with community partners to develop measurable improvement plans that increase needs met outcomes and reduce service gaps. Support the evaluation of Community Information Exchange and closed loop referral initiatives by measuring partner participation, referral completion, and customer outcomes. Prepare partner scorecards and community impact reports that communicate progress toward shared goals and identify opportunities for improvement. Recommend process improvements based on data analysis that strengthen coordinated care and improve the customer experience. Assist leadership in evaluating new partnerships and technologies that expand community capacity and increase successful service connections. Data Management & Data Quality Support efforts to streamline and optimize data collection, validation, and reporting processes to improve accuracy, consistency, and efficiency. Conduct regular data quality reviews and validation checks to ensure data completeness and integrity across systems. Utilize SQL, Python, Excel, and related tools for data extraction, transformation, and analysis. Develop and maintain documentation for data assets, including field definitions, metadata, and reporting logic to support organizational knowledge-sharing and AI-readiness. Support provider-side database management and data-related requests for Service Navigation Managers and operational teams. Identify opportunities for continuous data quality improvement, including resource and call-level data enhancements. Monitor data quality standards that ensure accurate measurement of referral outcomes, needs met rates, and partner performance across integrated systems. Systems & Technical Support Have foundational understanding of the organization’s data architecture and integrated systems environment. Utilize Microsoft analytics tools, like Power BI, to support reporting and visualization efforts. Create workflow diagrams and process documentation using Microsoft Visio and related tools. Maintain a working knowledge of Salesforce configuration, including permission sets, flows, page layouts, credential management, and digital experience fields. Support ongoing updates and enhancements for the 211 and DHHS websites as needed. Develop a working knowledge of telephony systems, including IVR/IVA configuration and reporting. Assist in developing AI driven reporting and analytical tools that help identify opportunities to improve customer outcomes, provider engagement, and community collaboration. Provide basic technical support, including password resets, hardware troubleshooting, and system navigation assistance. Support project coordination and task management efforts through Asana. Serve as a subject matter expert (“super user”) for provider database systems and related workflows. Maintain awareness of emerging AI tools, data technologies, and industry trends to improve operational efficiency and workflow optimization. Collaboration, Training & Stakeholder Support Conduct bi-weekly meetings with Service Navigation Managers to review performance metrics, identify anomalies, and communicate trends and expectations. Support the Data & Reporting Director in building organizational capacity around data literacy, reporting tools, and data-informed decision-making. Assist team members and partners in accessing, analyzing, and understanding qualitative and quantitative information. Translate complex data concepts into clear and actionable information for a variety of audiences. Participate in internal and external data committees, meetings, and collaborative initiatives as assigned. Assist partners in interpreting dashboards and performance reports to support continuous quality improvement initiatives. Assist in establishing consistent data definitions and reporting standards across partner organizations to enable accurate, comparable, and trustworthy shared reporting. Participate in cross-organizational data committees and working groups, helping translate partner needs into reporting solutions that advance collective impact. Support the integration of qualitative insights from clients, providers, and community partners into reporting and evaluation efforts. Partner with Service Navigation Team to ensure reporting reflects a customer-first lens, measuring not just operational throughput but the quality and outcomes of each interaction with partner agencies. Emergency Response Support Support 211 emergency response efforts through reporting, data tracking, and operational analytics during emergency or disaster situations. Assist with resource utilization tracking and reporting during emergency response events. Be prepared to support the Service Navigation Team during high call-volume or emergency events as needed. Participate in fire, emergency preparedness, and disaster response trainings and drills. Maintain awareness of disaster protocols and reporting procedures relevant to the role. Attend staff briefings and support operational communication efforts during emergency incidents. Provide additional emergency-focused duties and operational support as assigned. Help 211 Operations Director and maintain contact with affected county(s) representatives The Data & Reporting Director will also perform other emergency-focused duties as assigned. Provide assistance during emergency or disaster situations The Data Coordinator also assists with other duties as assigned. Requirements REQUIRED COMPETENCIES Strong analytical and problem-solving skills with the ability to interpret and communicate complex data clearly. Ability to present quantitative and qualitative data findings to diverse audiences, including leadership, community partners, and stakeholders. Experience building reports, dashboards, and visualizations that support strategic decision-making. Ability to identify data quality issues and implement continuous improvement practices. Strong organizational skills with attention to detail and commitment to data accuracy. Ability to manage multiple projects, deadlines, and competing priorities effectively. Demonstrated ability to learn and adapt to new technologies, systems, and processes. Experience using data storytelling techniques to communicate trends, outcomes, and impact. Ability to collaborate effectively across departments and build strong working relationships. Ability to document processes, workflows, and technical systems clearly and accurately. Comfort working in fast-paced and evolving environments with changing priorities. Ability to maintain confidentiality and adhere to data privacy and security standards. Strong written and verbal communication skills. Proficiency with Microsoft Office products, especially Excel. Commitment to continuous learning, innovation, and process improvement. QUALIFICATIONS Bachelor’s degree in Data Analytics, Information Systems, Statistics, Computer Science, Public Administration, or a related field, or equivalent work experience. Three years of experience in data analysis, reporting, visualization, or related analytical work. Experience with data visualization tools such as Power BI, Tableau, or Domo required. Experience with Salesforce reporting and analytics preferred. Experience using SQL and/or Python for data extraction and analysis preferred. Experience working with relational databases, data warehousing concepts, and complex spreadsheets. Advanced Microsoft Excel skills required. Experience creating workflow diagrams and process documentation using Visio or similar tools preferred. Experience supporting data governance, privacy, and security practices preferred. Experience leveraging AI tools and emerging technologies to improve workflows and operational efficiency preferred. Experience with survey design, data collection, and analysis preferred. PHYSICAL REQUIREMENTS The team member is regularly required to communicate clearly, and exchange accurate information interpersonally or through communication devices. Must be able to learn new systems and procedures, prepare and analyze data and figures, constantly operate a computer and other standard office machinery. Must be able to remain in a stationary position 75% of the time. The position requires occasional movement on- and offsite to participate and/or present in meetings. Must be able to move light items such as paper, laptops and presentation materials up to 25lbs. The employee is required to work primarily in-person, in our UP offices during core business hours Monday – Thursday, with the option to work remotely on Fridays. Utah’s Promise is currently piloting a 36-hour work week with Friday afternoons off. COMPENSATION & BENEFITS The position is a full-time, exempt position with full benefits. $51,707 – 63,197. UWSL/UP provides a wide range of benefits, including: Competitive medical, dental, vision insurance • 6% retirement match Life, accidental death, and long & short-term disability insurance • FSA • HSA contribution Free on-site gym & bike storage • Paid parking or public transportation subsidy Two weeks paid office closure (December & July) • Generous PTO & Health time Paid parental leave • Onsite coffee shop & café • Paid time to volunteer