Topeka Onsite Marketing Data Analyst — Power BI & SQL

Advisors Excel, LLC; Topeka (KS); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401k with matching

Generous PTO

On-site café and gym

Professional development opportunities

Job summary

Advisors Excel is seeking a Marketing Data Analyst to turn complex marketing data into actionable insights. You will partner with Strategic Marketing Coaches and cross-functional teams to build dashboards, analyze campaign performance, and deliver reporting that helps financial advisors improve marketing results.

This on-site role in Topeka, Kansas focuses on data preparation, validation, and quality, with emphasis on data-driven decision making. Sponsorship is not offered at this time.

Qualifications

• 3–5 years of experience in data analysis, marketing analytics, business intelligence, or a related field.
• Proficiency with SQL and experience working with large, complex datasets.
• Experience building dashboards and reports using Power BI, Sigma, or similar BI tools.
• Strong analytical, problem-solving, and communication skills.
• Exceptional attention to detail with a 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

Data analysis

Marketing analytics

Communication skills

Attention to detail

Education

Bachelor's degree

Tools

Power BI

Sigma

Job description

Advisors Excel is seeking a Marketing Data Analyst to turn complex marketing data into actionable insights. You will partner with Strategic Marketing Coaches and cross-functional teams to build dashboards, analyze campaign performance, and deliver reporting that helps financial advisors improve marketing results.

This on-site role in Topeka, Kansas focuses on data preparation, validation, and quality, with emphasis on data-driven decision making. Sponsorship is not offered at this time.