Light of Life Rescue Mission ยท 7 hours ago
Data & Analytics Specialist, Human Services Nonprofit
Pittsburgh, PA
Full-time
Onsite
Mid Level
$48K/yr - $58K/yr
3+ years expLight of Life Rescue Mission is a faith-based provider of services to people in need, assisting the homeless population in Pittsburgh since 1952. The Data & Analytics Specialist serves as a central resource for business intelligence and analytics efforts, maintaining data integrity and enabling data-informed decision-making across departments.
CateringChildrenMen'sNon ProfitResidentialWomen's
Responsibilities
Spearhead the development and maintenance of comprehensive business intelligence solutions using Microsoft Power BI, integrating data from MissionTracker (MySQL-based SaaS) and additional organizational systems
Author, optimize, and execute complex SQL queries to extract, filter, and aggregate data for high-impact analysis and reporting
Design and maintain tabular data models in Power BI, including development of calculated columns and DAX measures to support nuanced performance metrics
Establish and manage data transformation processes through Power Query and M Code, ensuring clean, structured datasets ready for reporting
Create visually compelling and interactive dashboards that translate complex data into understandable insights for a variety of stakeholders
Administer Power BI Service, including workspace management, asset deployment, and access controls to ensure security and usability
Build and manage data connections and gateway integrations to support real-time reporting and collaborative access via platforms such as SharePoint
Develop automated workflows using Power Automate to streamline data refreshes, report scheduling, and distribution processes
Conduct data quality audits and implement ongoing governance efforts to ensure the accuracy, completeness, and reliability of organizational data
Collaborate with internal departments - including Administration, Operations, and Development - to provide dashboards, reports, training, and consulting support tailored to each team's data needs
Provide data and reporting support to: Security (e.g., incident tracking, access data), Leadership (KPI dashboards, strategy support), TrainingHR (staff evaluation, onboarding data), KitchenFood Services (meal counts, inventory analysis), Donation CenterFree Store (in-kind donation metrics), MarketingGrants (donor impact visuals, program outcomes)
Support Grants and Development with metrics and visuals for donor communication, grant applications, and impact reporting
Collaborate with MissionTracker Pro Data Views Cohort peers via Slack, email, and virtual meetings to share best practices, troubleshoot, and exchange templates/code
Fulfill reporting obligations and requests from County partners, ensuring compliance with external requirements
Regularly engage in peer knowledge-sharing with internal data colleagues to enhance tools and reporting strategies
Support planning and supervision of data interns from local universities, providing technical guidance and project oversight
Due to the interface with the clients, all jobs at Light of Life require employees to: Work with others as a disciple of Christ, sharing the Gospel through actions and words
Establish mutual trust, fostering a safe, authentic environment
Exhibit Light of Life's Core Values: Honoring God, Loving Well, Embracing Growth, Valuing Diversity, and Pursuing Excellence
Practice effective stewardship of all resources
Model personal responsibility, accountability, timely reporting and a self-evaluative lifestyle
Qualification
Required
Bachelor's degree in Business, Computer Science, Mathematics, or related field
Minimum of three years' experience managing databases and performing data analysis in a professional setting
Advanced skills in Microsoft Power BI, including data modeling, DAX, Power Query, and dashboard development
Strong proficiency in SQL, with experience writing and optimizing queries for MySQL or comparable relational databases
Experience with Power Automate and integration of data systems for workflow automation
Excellent computer and database knowledge, including ETL processes, query optimization, and data visualization best practices
Intermediate to advanced skills in Microsoft Excel; familiarity with Microsoft Access a plus
Strong analytical thinking and problem-solving skills
Excellent communication and interpersonal skills with the ability to translate data for diverse audiences
Self-motivated and highly organized, with a track record of delivering insights that drive operational or strategic improvements
Demonstrated ability to collaborate across organizations and professional networks to exchange technical knowledge and best practices
Experience or readiness to supervise interns or junior analysts, with capacity to provide structured guidance and mentorship
Company
Light of Life Rescue Mission
Light of Life provides shelter and food for homeless men, women, and children.
51-200 employees
Funding
Current Stage
Growth StageRecent News
2025-08-08
Company data provided by crunchbase