Business Analyst

Business Analyst

Location: Dallas/Fort Worth Preferred / Remote Possible
Department: Analytics & Insights
FLSA: Exempt
Experience Level: 3-5+ years

About Us

We're an analytics-forward agency serving nonprofit media ministries and faith-driven organizations. We help our clients grow generous donor communities and extend their impact through data-informed decision making, modern reporting, and practical operational insight.

The Role

We're hiring a Business Analyst who blends classic BA skills with strong marketing analytics, SQL/Python chops, and a keen eye for design. You'll translate ministry and fundraising objectives into clear requirements; build and validate data solutions; and deliver beautiful, adoption-worthy dashboards and reports that drive action across direct mail, phones, digital, and social content channels.

What You'll Do

• Own discovery & requirements: Run stakeholder interviews, refine business problems, document user stories/acceptance criteria, and map current/future state processes and data flows.
• Be the client liaison: Bridge client teams, strategists and data analysts; manage backlogs; clarify scope; and keep deliverables aligned to outcomes.
• Analyze direct-response & donor performance across channels: direct mail, inbound/outbound call centers, email/SMS, web, paid search/social, podcasts/OTT/CTV, and organic social/content.
• Build and iterate dashboards & reports in Power BI that are visually clear, on-brand, and actionable; author exec summaries and narrative insights.
• Measure what matters: Calculate and interpret response rate, conversion, AOV, ROI/ROAS, CPA/CAC, LTV, lift, retention/attrition, reactivation/upgrade, pledge-to-cash, sustainer KPIs, and call-center metrics (connect rate, conversion, AHT) as well as social/content metrics (reach, engagement rate, completion, sentiment).
• Hands-on data work: Write robust SQL (joins, CTEs, window functions) and Python (pandas/numpy) for analysis, data preparation, QA, and automation; partner on simple ETL tasks.
• Information design: Apply data-viz best practices (layout, typography, hierarchy, accessibility) to improve adoption of reporting and dashboards.
• Quality & UAT: Define test cases, validate data against source systems, and triage defects with engineering.
• Documentation: Maintain specs, data dictionaries, KPI definitions, and dashboard guides to support consistent usage.
• Enablement: Train end users; host readouts; package insights into executive-ready briefs and presentation decks.
• Travel: Able to travel periodically for in person client and company meetings.

• 3-5+ years in a Business Analyst, Marketing Analyst, or similar role within an agency, nonprofit, or media/marketing environment.
• Bachelor's degree in Business, Marketing/Analytics, Information Systems, Statistics, or related field (Master's a plus).
• Direct-marketing domain knowledge across direct mail, inbound/outbound phones, email/SMS, web, paid media, and social/content channels-including the KPIs used to operate each channel.
• Fundraising & donor development expertise: familiarity with donor lifecycle and segmentation (e.g., RFM), sustainer programs, pledge vs. cash, campaigns/appeals, and gift/recurring stewardship practices.
• SQL proficiency: capable of building complex queries, optimizing for performance, and validating results across large datasets.
• Python proficiency for analysis/automation (pandas, numpy). Experience with another statistical language (R or SAS) is a plus.
• Power BI expertise: data modeling (star schema), DAX measures, interactive visuals, row-level security, and publishing/permissions.
• Microsoft Power Platform familiarity: Power Automate (flows) and/or Power Apps for lightweight process tooling.
• Data architecture literacy: understands the roles of data lakes, data warehouses, and data marts; comfortable discussing Kimball/star schemas and basic dimensional modeling.
• Report writing & storytelling: ability to craft clear narratives and executive summaries that connect data to decisions.
• Design sensibility: working knowledge of visual/graphic design principles; can collaborate in tools like PowerPoint, Figma, or Adobe to refine layout/branding.
• Detail orientation & ownership with excellent communication and stakeholder management.
• Report Directly to Executive Leadership Team along
  with ongoing and prompt communication.

• Experience with nonprofit CRMs and fundraising platforms (e.g., Salesforce NPSP, Raiser's Edge, Virtuous, CharityEngine).
• Exposure to Azure data stack (Azure SQL, Synapse, Data Factory), Databricks, or modern ELT tools.
• A/B testing design/analysis, cohort analysis, and MMM/MTA exposure.
• Familiarity with call-center systems and telephony data (e.g., connect/dispo codes).
• Light UI/UX or graphic production experience for report theming and layout.
• Familiarity with faith-based media and ministry audiences.