Business Analyst
3 days ago
Roanoke
Job DescriptionSalary: Business Analyst Location: Dallas/Fort Worth Preferred / Remote Possible Department: Analytics & Insights FLSA: Exempt Experience Level: 35+ years About Us Were an analyticsforward agency serving nonprofit media ministries and faithdriven organizations. We help our clients grow generous donor communities and extend their impact through datainformed decision making, modern reporting, and practical operational insight. The Role Were hiring a Business Analyst who blends classic BA skills with strong marketing analytics, SQL/Python chops, and a keen eye for design. Youll translate ministry and fundraising objectives into clear requirements; build and validate data solutions; and deliver beautiful, adoptionworthy dashboards and reports that drive action across direct mail, phones, digital, and social content channels. What Youll 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 directresponse & 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, onbrand, 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, pledgetocash, sustainer KPIs, and callcenter metrics (connect rate, conversion, AHT) as well as social/content metrics (reach, engagement rate, completion, sentiment)., • Handson 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 dataviz 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 executiveready briefs and presentation decks., • Travel: Able to travel periodically for in person client and company meetings. What Youll Bring (MustHaves) • 35+ years in a Business Analyst, Marketing Analyst, or similar role within an agency, nonprofit, or media/marketing environment., • Bachelors degree in Business, Marketing/Analytics, Information Systems, Statistics, or related field (Masters a plus)., • Directmarketing domain knowledge across direct mail, inbound/outbound phones, email/SMS, web, paid media, and social/content channelsincluding 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, rowlevel 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. Nice to Have (Pluses) • Experience with nonprofit CRMs and fundraising platforms (e.g., Salesforce NPSP, Raisers 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 callcenter systems and telephony data (e.g., connect/dispo codes)., • Light UI/UX or graphic production experience for report theming and layout., • Familiarity with faithbased media and ministry audiences.