Company DescriptionApplecart deploys proprietary technology to run smarter advertising campaigns. We work with some of the nation’s most prominent corporations, non-profit organizations and political candidates to activate and communicate with key target audiences at a scale and level of efficacy previously thought impossible. Part high-level strategic consultancy, part cutting edge data R D lab, Applecart offers proven solutions derived from objective, iterative experimentation. Our core offering is a proprietary social graph that leverages publicly-available data to map real-world relationships between individuals at national scale. Our roots are in politics, where we have tested and honed our methods at every level, in high-impact circumstances. We’re branching out beyond political campaigns to tackle new advertising challenges in which determining “who knows whom” provides decisive advantages for our clients.Applecart’s political work has been featured by The Colbert Report, CNN, The Washington Post, The Associated Press, USA Today, The Huffington Post, among other prominent news outlets.Job DescriptionApplecart seeks a motivated client relations specialist to help direct our new advocacy/public affairs effort. Applecart deploys proprietary technology that powers political campaigns, advocacy groups, and corporations that are serious about winning. We work with some of the nation’s most prominent political groups, corporations, and non-profit organizations to activate and communicate with key target audiences at cutting-edge scale and efficiency. Part high-level strategic consultancy, part cutting edge data R D lab, Applecart offers proven solutions derived from objective, iterative experimentation.Our core offering is our proprietary Social Graph, which leverages publicly-available data to map real-world relationships between individuals at national scale. Recently we have taken our Social Graph, honed in politics, into the advocacy space. Your work will directly help leading trade associations influence policy outcomes, increasing fundraising yields, and optimize messaging spending and operations.As a Data Analyst on our Advocacy team, you will be responsible for working with a team of strategists and data scientists to deliver custom analytics products, reports, and analyses to Applecart’s high profile advocacy clients. The job will entail fielding client inquiries, working with our sales and research teams to integrate testing into client projects, and creating and supervising the production of sales and reporting materials. The ideal candidate will be self-motivated and organized, with excellent written and verbal communication skills. SQL skills required; Python familiarity strongly preferred. Self-direction, attention to detail, and responsibility are paramount. Pay is competitive and commensurate to education and experience. Responsibilities:Work collaboratively with a team of analysts and strategists to deliver custom analyses, standardized analytics products, and presentationsSupport our sales team by helping to customize sales products and to generate estimatesDeliver quality analytics products to clients in a timely fashion, with impeccable attention to detailProblem-solve creatively to deliver data-driven solutions to client challenges on tight timelinesWork quickly and fluently in SQL to produce deliverables responsive to client requestsTranslate data sets, models, and technical concepts into actionable, client-friendly deliverablesQualificationsBasic Qualifications:1-3 years of work experience in data analysis1-3 years working in advocacy, public affairs, political campaigns, advertising, public policy, or governmentStrong proficiency in SQL, Excel, and PowerPointExperience and success at managing multiple tight and often conflicting timelines, while maintaining a cool confidenceOutstanding attention to detail that means taking the quality of work personallyStrong interest in or passion for politics, the legislative process, and analytics technologyDemonstrated strong written communication skillsExperience producing intuitive, client-ready data visualizationsExperience performing quality assurance on large datasetsPreferred Qualifications:Comfortable working in a fast paced, highly collaborative, dynamic work environmentHistory of being a self-starterComfort identifying problems small and large and proactively working solve themExperience with PythonSuccess at translating data and technical processes to materials easily understood by a nontechnical audienceAdditional InformationFor additional information, or to apply, please visit: https://applecart.recruiterbox.com/jobs/fk0mr3v/