Marketing Data Analyst - Onsite Topeka (Power BI & SQL)

Advisors Excel; Topeka (KS); On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401k with match

PTO

Job summary

Advisors Excel is seeking a Marketing Data Analyst in Topeka, KS to convert marketing and media data into actionable insights. You will build dashboards, analyze campaign performance, and deliver reporting to help financial advisors improve marketing results.

This role is strictly on-site, with no sponsorship offered. You will partner with Strategic Marketing Coaches, Digital, Media and Creative teams, handling data prep, lake management, and ad hoc reporting while maintaining data quality and

Qualifications

• 3-5 years of experience in data analysis, marketing analytics, business intelligence, or related field.
• Proficiency with SQL and experience with large, complex datasets.
• Experience building dashboards and reports using Power BI, Sigma, or similar BI tools.
• Strong analytical, problem-solving, and communication skills.
• Attention to detail with commitment to data accuracy.

Responsibilities

• Support marketing analytics projects through data preparation, validation, and dashboard development.
• Assist with data lake updates and management by loading and refreshing data, maintaining tables, and performing data hygiene and quality assurance checks.
• Build and maintain reports and dashboards in Power BI, Sigma, or similar BI tools.
• Analyze marketing performance across digital, broadcast, email, CRM, and web analytics channels.
• Write SQL queries to extract, join, validate, and analyze marketing data from multiple sources.
• Manage and maintain marketing data within our data lake, ensuring accuracy and data quality.
• Partner with Strategic Marketing & Performance Coaches to develop reporting that measures marketing effectiveness.
• Fulfill ad hoc reporting requests for Strategic Marketing, Digital, Media, and Creative teams.
• Identify trends, opportunities, and data anomalies while providing actionable insights to business partners.
• Maintain documentation for marketing metrics, data definitions, and reporting processes.
• Continuously improve reporting, dashboards, and data quality to help teams make informed decisions.

Skills

SQL

Power BI

Data analysis

Sigma

Dashboards

Data quality

Communication

Education

Bachelor's degree

Tools

Power BI

Sigma

Job description

Advisors Excel is seeking a Marketing Data Analyst in Topeka, KS to convert marketing and media data into actionable insights. You will build dashboards, analyze campaign performance, and deliver reporting to help financial advisors improve marketing results.

This role is strictly on-site, with no sponsorship offered. You will partner with Strategic Marketing Coaches, Digital, Media and Creative teams, handling data prep, lake management, and ad hoc reporting while maintaining data quality and