Applecart is looking to solve the problem of C-suites lacking the tools to reach stakeholders who matter most to their business, by hiring a Data Analyst to contribute to polling and predictive modeling efforts, targeting, and analytics.
Requirements
- Expertise in Python or a similar object-oriented language, including the ability to architect scalable systems, design reusable components, and implement OOP solutions from high-level requirements
- Experience with data-manipulation tools (Pandas, dplyr, PySpark) to convert raw data into validated, analysis-ready datasets — including data cleaning, joining, aggregating, visualizing, and performance optimization
- Ability to use version control systems to maintain clear, organized code repositories
- Experience using SQL to query and manipulate databases
- Experience working in Tableau to produce intuitive, client-facing data reports and visualizations
- Experience working with statistical libraries like scikit-learn or PySpark ML to build predictive risk models, and high-level knowledge of best practices for constructing such models
Responsibilities
- Work quickly and fluently in Python and SQL to ingest, analyze, and transform internal datasets for use with data pipelines and client-facing deliverables
- Assist with long-term research and development on PySpark-based data pipelines, custom survey research methodologies, and related deliverables
- Work closely with the campaign and survey research team to create samples, process data, conduct survey analyses, and build custom predictive models using survey results and other data sources
- Build, maintain, and extend the functionality of internal Tableau dashboards through intuitive and easy-to-read visualizations, charts, and tables
- Troubleshoot and solve problems for the Client Services and Audience Operations teams involving the processing, reporting, and delivery of audience data
- Fulfill ad-hoc requests for projects, solving problems for teams involving data transformation, cleaning, and effective communication between project stakeholders
Other
- 1-3 years of work experience in a data analytics-focused role for a company, analytics or consulting firm, political committee, or in an academic setting
- Capability to manage multiple tight timelines while being adaptive to cross-functional responsibilities and requests
- Ability to collaborate proactively with team members and be highly motivated in managing project work
- College- or graduate-level coursework in statistics, data analysis, mathematics or computer science
- This is a hybrid role, with work from home or in the office on Monday and Friday, and in Applecart’s New York City office Tuesday through Thursday
