Data Analyst (Media Buying) — HomeIQ

Join HomeIQ as a Middle Data Analyst and help turn advertising data into accurate insights, smarter decisions, and better business performance.
We are looking for a hands-on Data Analyst who can connect advertising spend with revenue, identify performance trends, automate reporting, and build reliable dashboards and forecasting models.
This role combines data analytics, data engineering, and performance marketing analytics. You'll work with multiple data sources, improve data accuracy, and help our team make confident, data-driven decisions.
At HomeIQ, we believe that accurate data is essential: a wrong number is worse than no number at all.

What You'll Do

Data Integration & Automation

• Collect advertising spend data from multiple platforms through APIs and exports.
• Develop and maintain automated data pipelines using Python, APIs, CSV/Excel, Google Sheets, and other sources.
• Store, transform, and organize data in BigQuery.

Revenue & Cost Reconciliation

• Match advertising spend with revenue from tracking systems and affiliate networks.
• Identify and investigate discrepancies across campaigns, traffic sources, and reporting periods.
• Establish reliable reconciliation processes and data quality controls.

Analytics & Forecasting

• Analyze key performance metrics, including ROI, CPL, CPA, EPC, ROAS, and profit margins.
• Identify trends and relationships between traffic sources, creatives, costs, and revenue.
• Develop and maintain predictive models for lead pricing.
• Evaluate forecasting accuracy and continuously improve model performance.

Dashboards & Reporting

• Build and maintain daily, weekly, and monthly performance dashboards.
• Consolidate reporting, analytics, and forecasts into a unified interface.
• Implement automated data validation and monitoring processes.
• Translate complex data into actionable insights for business stakeholders.

What We're Looking For

• 2–4 years of experience in data analytics or a related data role, ideally in digital advertising, performance marketing, or affiliate marketing.
• Strong SQL skills, including complex joins, window functions, aggregations, and data reconciliation.
• Hands-on Python experience with ETL processes, API integrations, and data processing using libraries such as pandas and requests.
• Understanding of statistics and forecasting methods, including regression, time series, backtesting, and error metrics.
• Experience with Looker Studio, Power BI, or Tableau.
• Understanding of performance marketing metrics and business models, including CPA, CPL, EPC, RevShare, ROAS, and margins.
• Strong Excel and Google Sheets skills.
• Advanced English (C1) for communication with international colleagues.
• Excellent analytical thinking, attention to detail, and a strong commitment to data accuracy.
• Ability to work independently, investigate problems, and deliver practical solutions.

Nice to Have

• Experience integrating advertising platform APIs, such as Meta Ads, Google Ads, TikTok, NewsBreak, or Snapchat.
• Familiarity with affiliate marketing and tracking platforms, including Voluum, RedTrack, Everflow, Ringba, LeadProsper, AppsFlyer, or HubSpot.
• Experience with dbt and data modeling.
• Familiarity with TypeScript, React, Next.js, Streamlit, or Retool.
• Experience with Google Cloud Platform services, including Cloud Run and Cloud Scheduler.
• Experience using AI/LLM tools, including Claude, for data processing, report automation, or analytical insights.
• A degree in Computer Science, Mathematics, Economics, or a related field.

Tech Stack & Tools

• Data & Analytics: SQL, BigQuery, Python, pandas
• Visualization: Looker Studio, Power BI, Tableau
• Data Integration: REST APIs, CSV/Excel, Google Sheets
• Advertising & Tracking: Meta Ads, Google Ads, TikTok, Everflow, Ringba, LeadProsper
• Additional Tools: dbt, GCP, Streamlit, Retool, Claude

Why This Role Matters

Your work will directly influence how HomeIQ measures advertising performance, manages marketing spend, and identifies opportunities for growth.
You'll have the opportunity to take ownership of meaningful analytics projects, improve existing processes, and build tools that help the business make faster, more accurate decisions.
Interested in turning complex marketing data into real business impact? We'd love to hear from you!