Senior Marketing Business Analyst

JOB SUMMARY: This is a job overview/brief description of the role. The Senior Marketing Business Analyst drives marketing efficiency and insight for our direct-to-consumer business, combining analytical expertise with an automation-first mindset. You'll transform raw data into automated reporting systems and actionable intelligence for ~20 external partners and internal channel managers. The ideal candidate thrives on eliminating manual work, building scalable solutions, and freeing up time for strategic analysis that drives customer growth and marketing ROI. DUTIES & RESPONSIBILITIES: Reporting Automation & Optimization: Own and automate partner performance reporting for ~20 partners and daily dashboards for Marketing channel owners Proactively identify opportunities to eliminate manual processes through scripting, APIs, and workflow automation Design scalable reporting frameworks that grow with the business without proportional manual effort Strategic Analysis & Business Partnership: Conduct high-impact analyses that inform marketing investment decisions, often synthesizing data from multiple sources Investigate complex, ad-hoc data questions from Marketing leadership with speed and precision Track channel KPIs and provide data-driven optimization recommendations to improve performance Translate complex analytical findings into clear, compelling narratives for diverse audiences Process Improvement & Innovation: Serve as the team's automation champion—constantly asking "how can we do this faster and better?" Build reusable analytical tools, templates, and frameworks that enable self-service insights across Marketing QUALIFICATIONS: Education/Experience: BS/BA in Mathematics, Analytics, Statistics, Computer Science, or related quantitative field 6-8 years of progressive analytics experience, preferably in digital/performance marketing environments Demonstrated track record of automating reporting processes and building scalable analytical solutions Technical Skills: Required: SQL proficiency for querying and extracting data from SQL Server databases Power BI experience building dashboards and automated reports (or Tableau/Looker) Advanced Excel (pivot tables, VLOOKUP, Power Query, comfortable with large datasets) Demonstrated automation experience - you've built scheduled reports, automated data pipelines, or scripted repetitive tasks. Bonus if you maintain code in a Git repository. Familiarity with digital marketing data sources (Google Analytics, Facebook Ads, etc.) Highly Valued: Python or R for data manipulation, analysis, and automation workflows BigQuery for GA4 data analysis and custom attribution Experience with APIs to pull data programmatically from marketing platforms Version control (Git/GitHub) - we want to see your automation work SQL Server-specific features like stored procedures, SSIS, or jobs for scheduling Nice to Have: GA4 implementation or marketing attribution modeling Experience with data warehousing concepts (fact/dimension tables, star schemas) DAX for advanced Power BI calculations Core Competencies: Automation-first mindset with ability to build solutions Problem-solving tenacity and intellectual curiosity Ownership mentality from ambiguous requirements to polished delivery Strong communication skills translating technical complexity to executive insights Strategic thinking balancing tactical execution with business impact Collaboration and relationship-building across stakeholders Detail-oriented while maintaining momentum and managing multiple priorities PHYSICAL REQUIREMENTS: Sitting or standing for extended periods; repetitive motions; use hands to handle equipment or controls; reach with hands and arms; typing on keyboard; viewing computer screen extended periods; speak clearly and hearing Regular use of typical office equipment, computer software, programs, and methods of communication such as a computer, e-mail, phone system, and messaging. In a remote work environment, being interactive and communicative with management and co-workers in a visible manner is an essential function of the job. Camera/video usage is required. Must be able to lift 25 pounds. *The compensation for this role falls within an annual salary range of $115,000 to $145,000 + annual performance bonus.* *Endurance is committed to building a diverse and inclusive team. Please note: at this time, applicants must have existing authorization to work in the U.S., as we are unable to offer new visa sponsorship.*Equal Employment OpportunityEndurance Warranty Services is proud to be an equal-opportunity employer. We celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Our differences are what make us better together. Endurance Warranty is an E-Verify Company. About EnduranceEndurance Warranty has been honored with multiple Stevie Awards for being a great place to work, and we’re growing rapidly. We’re a fast-paced company offering limitless opportunities to grow your career. Thanks to our dedicated employees, we provide best-in-class auto repair coverage to customers across the country, protecting people from unexpected and costly breakdowns for almost 15 years. At Endurance, we embrace the entrepreneurial spirit, and you’ll play a role in shaping this dynamic industry. We offer great pay, amazing benefits, and the opportunity to learn and grow. When you work for Endurance, you’re working for a company that cares about you and your future. We empower employees to lead, drive change and give back where they work and live. Our people are our greatest strength, and we’re proud to work as a diverse team to serve our customers and our community.  Therefore, we’ve been honored as a top place to work, including multiple StevieⓇ Awards for the best workplace and great employer. For the last several years, Endurance has also earned a spot-on Selling Power’s “50 Best Companies to Sell For” and consistently makes industry lists from Crain’s and Inc. magazine for our continuous and significant growth. Experts in the industry recognize that our employees care as well—Consumer Affairs highly recommends Endurance, and our customers highly rate us on Google, Trustpilot, and other major online review sites. Come accelerate your career with us. We’ll give you the tools you need to succeed at work and the flexibility to enjoy life outside of your job.