Marketing Data Analyst — Reporting & Insights

Jobtailor; Lebanon (KY); On-site; USD 55,000 - 75,000; Full time

Job summary

Jobtailor in the United States is seeking a Data Analytics & Reporting Specialist to collect, clean, and organize data from marketing platforms and internal systems, and to prepare recurring reports.

You will perform QA checks, develop clear visualizations and summaries, and support ad hoc requests while maintaining documentation and dashboards.

Qualifications

• 1–2 years of relevant professional, academic, or project experience in data analytics, marketing analytics, reporting or a related field.
• Bachelor’s degree in computer science, analytics, marketing, business, information systems, communications, or a related discipline, or equivalent practical experience.
• Experience working with Microsoft Excel, including organizing data, formulas, look‑up functions, pivot tables, and data formatting.
• Ability to conduct accurate research and collect structured information from multiple sources.
• Strong attention to detail and the ability to identify incomplete, inconsistent, or inaccurate information.
• Basic understanding of marketing concepts and performance metrics.
• Strong organizational and time-management skills, with the ability to manage recurring tasks and deadlines.
• Ability to follow processes, work independently on assigned responsibilities, and collaborate effectively with others.
• Detail-oriented, self-starter, has excellent communication and time-management skills, demonstrates critical thinking and growth mindset.
• Availability during Eastern US business hours.
• Preferred (but not required): Experience with Power BI, Tableau, Power Query or similar reporting and data-preparation tools.
• Preferred (but not required): Experience supporting recurring reports, dashboards, research projects, or client-facing deliverables.
• Preferred (but not required): Experience in higher education, enrollment marketing, agency services, or another client-service environment.

Responsibilities

• Collect, organize, and prepare data from marketing platforms, internal systems, spreadsheets, and other approved sources.
• Clean and standardize data by identifying duplicate records, missing information, formatting inconsistencies, and other data-quality issues.
• Prepare and deliver assigned recurring marketing reports and support ad hoc reporting requests using established processes and business requirements.
• Maintain and update reporting workbooks, dashboards, research files and supporting documentation.
• Perform quality-assurance checks to validate data accuracy, report calculations, date ranges, filters, and consistency across sources.
• Review marketing and organizational data to identify trends, changes, gaps, and items requiring further investigation.
• Investigate data discrepancies, document findings, and collaborate with the appropriate team members to resolve issues.
• Prepare clear tables, visualizations, and written summaries to communicate reporting results.
• Contribute to improvements in recurring data-collection, reporting, quality-assurance, and documentation processes.

Skills

Data Analytics

Microsoft Excel

Quality Assurance

Reporting

Attention to Detail

Research

Education

Bachelor’s degree in Computer Science, Analytics, Marketing, Business, Information Systems, Communications, or related discipline

Tools

Power BI

Tableau

Power Query

Job description

• Collect, organize, and prepare data from marketing platforms, internal systems, spreadsheets, and other approved sources.
• Clean and standardize data by identifying duplicate records, missing information, formatting inconsistencies, and other data-quality issues.
• Prepare and deliver assigned recurring marketing reports and support ad hoc reporting requests using established processes and business requirements.
• Maintain and update reporting workbooks, dashboards, research files and supporting documentation.
• Perform quality-assurance checks to validate data accuracy, report calculations, date ranges, filters, and consistency across sources.
• Review marketing and organizational data to identify trends, changes, gaps, and items requiring further investigation.
• Investigate data discrepancies, document findings, and collaborate with the appropriate team members to resolve issues.
• Prepare clear tables, visualizations, and written summaries to communicate reporting results.
• Contribute to improvements in recurring data-collection, reporting, quality-assurance, and documentation processes.

Requirements

• 1–2 years of relevant professional, academic, or project experience in data analytics, marketing analytics, reporting or a related field.
• Bachelor’s degree in computer science, analytics, marketing, business, information systems, communications, or a related discipline, or equivalent practical experience.
• Experience working with Microsoft Excel, including organizing data, formulas, look-up functions, pivot tables, and data formatting.
• Ability to conduct accurate research and collect structured information from multiple sources.
• Strong attention to detail and the ability to identify incomplete, inconsistent, or inaccurate information.
• Basic understanding of marketing concepts and performance metrics.
• Strong organizational and time-management skills, with the ability to manage recurring tasks and deadlines.
• Ability to follow processes, work independently on assigned responsibilities, and collaborate effectively with others.
• Detail-oriented, self-starter, has excellent communication and time-management skills, demonstrates critical thinking and growth mindset.
• Availability during Eastern US business hours.
• Preferred (but not required): Experience with Power BI, Tableau, Power Query or similar reporting and data-preparation tools.
• Preferred (but not required): Experience supporting recurring reports, dashboards, research projects, or client-facing deliverables.
• Preferred (but not required): Experience in higher education, enrollment marketing, agency services, or another client-service environment.

Core Competencies

Demonstrates expertise in data analytics and reporting, with strong skills in Microsoft Excel for data organization and analysis. Capable of conducting quality assurance checks and preparing clear visualizations and summaries to communicate findings effectively.

Highest-signal resume keywords

• Data Analytics
• Microsoft Excel
• Quality Assurance
• Reporting
• Attention to Detail

ATS Optimization Keywords

Hard Skills

• Data Collection
• Data Cleaning
• Data Standardization
• Data Visualization
• Data Formatting
• Formulas
• Look-Up Functions
• Pivot Tables
• Research
• Trend Analysis

Soft Skills

• Strong Organizational Skills
• Time-Management Skills
• Critical Thinking
• Collaboration
• Communication

Industry Keywords

• Marketing Analytics
• Higher Education
• Enrollment Marketing
• Client-Service Environment

Tools & Technologies

• Power BI
• Tableau
• Power Query