Light of Life Rescue Mission ยท 6 hours ago
Data & Analytics Specialist
665 Ridge Avenue, Pittsburgh, PA, USA
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 the Northside of Pittsburgh since 1952. The Data & Analytics Specialist will serve as a central resource for the organization's business intelligence and analytics efforts, maintaining enterprise 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), Training & HR (staff evaluation, onboarding data), Kitchen & Food Services (meal counts, inventory analysis), Donation Center & Free Store (in-kind donation metrics), Marketing & Grants (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
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
Benefits
Healthcare
Dental
Vision
Matching Retirement Plan
Minimum 3 Weeks' Vacation Plus Holidays
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