Marketing Data Analytics

Merchants Bonding Company (mutual)

West Des Moines, IA

JOB DETAILS
SKILLS
A/B Testing, Analysis Skills, Application Programming Interface (API), Business Support, Campaigns, Certified Public Accountant (CPA), Channel Marketing, Click Through Rate (CTR), Customer Relationship Management (CRM), Customer Relationship Management (CRM) Systems, Data Analysis, Data Cleaning, Data Collection, Data Management, Data Quality, Data Sets, Financial Analysis, Google Analytics, LinkedIn, Looker, Market Analysis, Marketing, Marketing Automation Software, Marketing Metrics, Metrics, Multiplatform/Cross-Platform, Online Marketing, Performance Analysis, Performance Management, Performance Metrics, Performance Testing, Power BI, Python Programming/Scripting Language, Quality Monitoring, Reporting Dashboards, Return on Investment (ROI), SQL (Structured Query Language), Salesforce.com, Scripting (Scripting Languages), Search Engine Marketing (SEM), Search Engine Optimization (SEO), Trend Analysis, Underwriting, Web Analytics, Website Conversion
LOCATION
West Des Moines, IA
POSTED
30+ days ago

Say Yes to the Best Career Opportunities

Merchants Bonding Company is hiring professionals who value clarity, collaboration, and opportunities to make an impact. Our team is growing, and we're looking for people who thrive in a fast-moving environment built on common sense underwriting and first-class experiences. If you're ready for the next step in your career with a team that says yes to the best, this is your opportunity.

Job Purpose:

The Marketing Data Analyst will build and maintain the data pipelines, integrations, and dashboards that support marketing performance and growth initiatives. This role will work across multiple platforms (CRM, marketing automation, paid media, and web analytics) to pull, combine and structure data into usable reporting and insights which includes leveraging APIs, automating data workflows, and ensuring data accuracy across systems.

In addition to building the data infrastructure, this role will monitor campaign performance, support testing efforts, and provide clear, data-driven insights to marketing and business stakeholders to help the organization understand what is working, where to optimize, and how to improve overall marketing effectiveness.

Job Responsibilities:

Data Integration and Pipeline Development

  • Build and maintain data pipelines that pull from platforms such as Salesforce, Marketo, Google Analytics, LinkedIn, and paid media channels
  • Implement API integrations and use scripting (Python, SQL, or similar) to automate data collection, transformation, and reporting
  • Combine multiple data sources into clean, reliable datasets for analysis and reporting
  • Monitor data quality and resolve discrepancies across systems

Dashboards and Performance Reporting

  • Develop and maintain dashboards that track marketing performance across channels
  • Ensure stakeholders have access to accurate, up-to-date reporting
  • Track and report on key metrics such as ROI, CPA, conversion rates, and campaign performance
  • Identify trends, anomalies, and performance gaps through ongoing monitoring

Insights and Business Support

  • Translate data into clear, actionable insights for marketing and business stakeholders
  • Partner with marketing team members to define reporting needs and success metrics
  • Deliver ad hoc analysis and data insights to support business decisions
  • Help standardize reporting and measurement practices

Testing and Optimization

  • Implement A/B and multivariate testing frameworks, including tracking and measurement
  • Analyze results and provide clear recommendations for optimization
  • Implement and contribute to a structured "test and learn" approach to improve performance over time

Education and Skills

  • Experience working with Python, SQL, or a similar language to pull, manipulate, and analyze data
  • Experience working with APIs and integrating data from marketing platforms (Google, LinkedIn, CRM systems such as Salesforce or Marketo)
  • Experience building and maintaining dashboards using tools such as Power BI, Looker Studio, or QuickSight
  • Strong understanding of marketing performance metrics (ROI, CPA, conversion rates, CTR)
  • Experience automating data pipelines and reporting workflows
  • Familiarity with A/B and multivariate testing and measurement
  • General understanding of digital marketing channels (SEO, SEM, paid media, email)
  • Minimum 3 years experience in marketing analytics, data analytics, or related field.

About the Company

M

Merchants Bonding Company (mutual)