Data Reporting Specialist (Remote US)

Location: Remote (International)

Required Coverage: Minimum 4 hours overlap with US business hours

Experience Level: 3–4 Years

About Ignite Visibility

Ignite Visibility is a top-rated, full-service US digital marketing agency. We are a fast-growing team that thrives on data-driven storytelling. We are looking for a collaborative Data Reporting Specialist who is passionate about building clear, beautiful, and accurate reports that help our clients win.

Position Summary

As a Data Reporting Specialist, you are the bridge between raw marketing data and strategic decision-making. You will report to the Senior Data Strategist and take ownership of the agency’s client-facing reporting suite. Your day-to-day will involve building custom dashboards, maintaining data health in BigQuery, and ensuring our account teams have the insights they need to optimize campaigns in real-time.

Primary Responsibilities

Report Building & Dashboarding

• Custom Report Construction: Design and build comprehensive, visually appealing dashboards in Looker Studio (Google Data Studio) for new and existing clients.

• Report Refinement: Regularly edit and adjust existing dashboards based on specific client requests or changing KPIs.

• Data Ingestion: Map and ingest data from various sources (Google Ads, Meta, LinkedIn, GA4) to ensure reports are holistic and accurate.

• Insight Translation: Use your reports to conduct campaign analysis, helping to identify performance trends and areas for optimization.

Data Maintenance & QA

• Database Oversight: Manage and organize client data within Google BigQuery to ensure it is structured for easy reporting.

• Daily Quality Assurance: Conduct daily QA checks of our ETL tools and databases to ensure a proper refreshing cadence; catch and fix "broken" charts before the client sees them.

• Troubleshooting: Resolve data discrepancies between platform UIs (like Facebook Ads) and our reporting dashboards.

Collaboration & Support

• Agency Liaison: Act as the primary point of contact for Account Managers for all things reporting—troubleshooting bugs, adding new metrics, or creating specialized data views.

• SOP Documentation: Document the data structures and Standard Operating Procedures (SOPs) for individual client reports to ensure team consistency.

Required Skills & Qualifications

• Experience: 3–5 years in digital marketing analytics, data reporting, or a similar role.

• Reporting Expert: Highly proficient in Looker Studio (Google Data Studio). You should be comfortable with data blending and calculated fields.

• Marketing Fluency: A solid understanding of paid media metrics (CTR, CPC, ROAS, Conversions) and how platforms like Google Ads and Meta work.

• Technical Curiosity: Exposure to SQL and/or Python (specifically for data cleaning/transforming). You don't need to be a developer, but you should be excited to learn and use these tools.

• English Proficiency: Strong written and verbal communication skills for collaborating with our US-based team.

• U.S time zoneOverlap: Ability to work a schedule that provides at least 4 hours of overlap with US Pacific Standard Time (PST) or CST.

Preferred Skills (The "Plus" List)

• Professional experience with Google BigQuery.

• 1+ years in a digital marketing agency setting.

• Experience with automated data connectors (Supermetrics, Funnel.io, etc.).

• Basic knowledge of MySQL (joins and if/then statements).

Why Join Ignite Visibility?

• High-Level Exposure: Work with some of the biggest names in digital marketing and learn US agency standards.

• Skill Growth: We provide a path to learn advanced data engineering (BigQuery/Python) while you manage the reporting suite.

• Innovation: We stay on the cutting edge of AI and marketing technology—your input on our reporting tech stack will be valued.