Marketing Data Analyst & Power BI Specialist (Data Cleaning + EDA)

We’re looking for someone who actually enjoys working with messy marketing data and understands that cleaning a dataset isn’t about replacing every missing value with a mean or median. Our digital marketing agency has been running campaigns across Google Ads, Meta Ads, LinkedIn, email marketing, and our CRM. Over the last two years, we’ve accumulated campaign performance data from multiple exports, and the quality is far from perfect. Before we build dashboards and make business decisions, we need someone who can understand the data, identify problems, and explain why they exist instead of applying generic cleaning techniques. What you’ll be working with Campaign performance exports Lead and customer data from our CRM Website traffic reports Ad platform reports Email marketing performance Monthly Excel and CSV reports from different team members The data currently has issues like Missing values that may have different reasons depending on the source Duplicate leads created from multiple campaign imports Inconsistent campaign naming conventions Different date formats Mixed currency and spend formats Incorrect or inconsistent channel names Empty fields that may actually carry business meaning Possible outliers that should be investigated instead of automatically removed We need someone who can Assess data quality before making changes Investigate why values are missing rather than blindly filling them Recommend appropriate handling methods for different situations Detect and resolve duplicate records carefully Standardize inconsistent data Document every cleaning decision Perform exploratory data analysis (EDA) to uncover useful business insights Identify trends, anomalies, and campaign performance patterns Build an interactive Power BI dashboard for our marketing team Dashboard should help answer questions like Which campaigns generated the highest quality leads? Which marketing channels deliver the best ROI? Cost per Lead (CPL) by channel Cost per Acquisition (CPA) Conversion Funnel Monthly marketing performance trends Geographic performance Budget vs actual spend Top-performing campaigns Lead source comparison Required Skills Python (Pandas, NumPy) Data Cleaning & Data Quality Assessment Exploratory Data Analysis (EDA) Power BI SQL (preferred) Marketing analytics experience is a strong plus When applying Please don’t send a generic proposal. Instead, tell us: A project where you discovered an underlying data quality issue that wasn’t obvious. An example where you decided not to impute missing values and explain why. How you typically document your preprocessing decisions so stakeholders understand what changed. Share one dashboard you’ve built (screenshots are fine if the data is confidential). We’re looking for someone who thinks like an analyst first and a dashboard developer second. The goal isn’t just clean data—it’s trustworthy data that supports better marketing decisions.