• Perform detailed data analysis and profiling to support MDM and data integration initiatives. • Analyze and validate master data domains such as Customer, Product, Vendor, or Supplier. • Work closely with MDM developers to validate match, merge, and survivorship logic. • Perform data reconciliation and validation between source, staging, and target systems. • Write complex SQL queries for data extraction, validation, and troubleshooting. • Support implementation and enhancement of Informatica MDM / PowerCenter / IDQ solutions. • Identify and resolve data quality issues, inconsistencies, and duplication. • Create documentation including data mapping, data lineage, and business rules. • Collaborate with business stakeholders to understand data requirements and governance policies. • Support UAT, reporting, and production validation activities.

• Collaborating with the Client Services team to identify universes and targeting strategies • Delivering complex projects on time • Helping Pivot deliver a product within a fast-moving environment • Accessing voter file data and transforming it into clean, printer-ready mail lists • Performing regular quality control (QC) measures on jobs • Updating Pivot’s data processes and support systems • Understanding how targeting insights and analyses will be used • Tailoring approaches to targeting to specific circumstances • Evaluating vendors for data sources and statistical targeting models • Partnering with multiple departments to establish strategies to accomplish clients’ goals

• Source and Process Voter File Data • Access voter file data from a variety of platforms and transform into clean, printer-ready mail lists • Perform regular quality control (QC) measures on complex, multi-variable jobs • Package data materials appropriately for production • Proof and perform final QC on all data products before production • Assist in updating Pivot’s data processes and support systems • Develop and maintain an understanding of postal processing regulations, state-specific voter data availability, and advances and trends in the use of data in the Democratic community • Creatively identify opportunities for targeting hard-to-find voters • Evaluate vendors for data sources and statistical targeting models • Partner with Client Services teams (and in some cases clients) to develop targeting strategies for campaigns • Be a thought-partner in both the development of the overall strategies and specific targeting for programs • Derive clear, actionable, and timely insights from analyses of both voter file and available non-voter file data • Expertly leverage data resources, including voter files, microtargeting models, and synthetic tools to answer strategic questions for clients • Proactively support the marketing process, including giving data driven strategic input and as well as materials to include in proposals and pitches to the Client Services teams, and developing relationships in the consultant community • Develop training materials for new hires within the data department, and other departments as well • Lead and manage cycle data staff on specific projects • Understand how targeting insights and analyses will be used and tailor to best fit clients’ needs • Can interpret data from a variety of sources and excellent at communicating concepts orally and in writing • All analysis and files are produced accurately, consistently and on time • Should be able to manage multiple projects with varying levels of priority, but flexible enough to adapt to changing circumstances • Partner with multiple departments to establish strategies to accomplish clients’ strategic goals • Affinity for working with large or messy data sets • Passion for documentation, fact checking, and quality control

Role Description The Senior Marketing Analyst's primary responsibility is to help clients maximize value from their marketing data. You'll own client delivery end-to-end for your assigned accounts — from data modeling through final reporting. You'll design and maintain dashboards across BI platforms, ensure data quality, and deliver clear, actionable reporting. This role also involves managing data transformations in dbt and working with complex, multi-source data architectures. You'll leverage AI tools (e.g. Codex, Claude) to accelerate your workflows. We are looking for someone who is reliable, responsible, quality-minded, keeps commitments, takes ownership of their work, and can confidently present results to clients. Responsibilities - Support clients directly — understand their requirements, translate them into data solutions, and deliver clear insights. - Build and maintain dashboards and reports in Looker, Power BI, and Tableau — depending on client setup. - Design and maintain data models that consolidate data from multiple marketing platforms and sources. - Map and document data flows across complex, multi-source schemas. - Proactively identify opportunities, trends, or risks in marketing data and communicate findings clearly. - Write, optimize, and troubleshoot SQL queries for reporting, analysis, and investigations. - Manage and enhance data transformations with dbt. - Conduct QA/UAT to ensure data accuracy, consistency, and trustworthiness. - Use Git for version control and collaboration. Qualifications - Expert-level proficiency in at least one BI platform (Looker, Power BI, or Tableau), with the ability to deliver projects across all. - 3+ years of SQL experience. - Proficiency with AI tools and ability to integrate them into daily workflows. - Experience working with multiple marketing data sources simultaneously (ad platforms, CRM, web analytics, etc.). - Understanding of data modeling principles (star schema, dimensional modeling). - Understanding of ELT/ETL concepts and debugging data transformation logic. - English C1 level with excellent written and verbal communication. - Ability to communicate directly with clients and stakeholders. - Takes ownership and responsibility for their work and results. - Can present their work and insights confidently to clients. - Consistently checks their own work for quality, accuracy, and completeness before delivery. - Strong analytical skills, proactive problem-solving, and close attention to detail. - Comfortable with ambiguity and able to drive clarity with clients and internal teams. - Hands-on experience with QA/UAT processes. Nice to Have - Knowledge of Google Analytics (for business understanding). - Knowledge of Google Analytics Data Streams. - Familiarity with marketing platforms data (Google Ads, Facebook Ads, etc.). - Understanding of Marketing Mix Modeling (MMM) concepts. - dbt experience in analytics workflows. - Python or other scripting language for data analysis and automation. - Experience with data quality frameworks or data observability tools. - Familiarity with marketing attribution models. Benefits - Remote-first environment - Competitive compensation - Medical and dental benefits - 401K plan - Unlimited PTO - Paid holidays - Professional development reimbursement