Marketing Data Architect & Insights Lead

Merchants Bonding Company; West Des Moines (IA); On-site; USD 70,000 - 90,000; Full time

Job summary

Merchants Bonding Company is seeking a Marketing Data Analyst in West Des Moines, Iowa. This role involves building and maintaining data pipelines, developing dashboards, and turning data into actionable insights to support marketing efforts. Candidates should have experience with Python, SQL, and API integrations, and a strong understanding of marketing metrics. A minimum of three years of relevant experience is required, along with proficiency in tools like Power BI and Google Analytics. The position will contribute to optimizing marketing effectiveness through data-driven strategies.

Qualifications

• 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.
• 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.

Responsibilities

• Build and maintain data pipelines that pull from platforms such as Salesforce, Marketo, Google Analytics, LinkedIn, and paid media channels.
• Develop and maintain dashboards that track marketing performance across channels.
• Translate data into clear, actionable insights for marketing and business stakeholders.
• Implement A/B and multivariate testing frameworks, including tracking and measurement.

Skills

Python

SQL

APIs

Power BI

Looker Studio

QuickSight

Marketing performance metrics

Data automation

A/B testing

Digital marketing

Education

Minimum 3 years experience in marketing analytics

Tools

Salesforce

Marketo

Google Analytics

LinkedIn

Job description

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
  
  

Qualifications

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.