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.

What You’ll Bring (Must‑Haves)

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

Nice to Have (Pluses)

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