Data & Analytics Specialist

Light Of Life Rescue Mission • Pittsburgh, PA

3d

About The Position

The Data & Analytics Specialist serves 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. This role designs and maintains reporting infrastructure, collaborates across internal and external teams, and supports strategic initiatives with actionable insights. Through advanced tools and peer collaboration, the Specialist builds the organization's capacity for continuous improvement, outcome measurement, and cross-functional data literacy.

Requirements

• 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.

Nice To Haves

• Intermediate to advanced skills in Microsoft Excel; familiarity with Microsoft Access a plus.
• Experience or readiness to supervise interns or junior analysts, with capacity to provide structured guidance and mentorship.

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.
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 101-250 employees