Marketing Data & Reporting Specialist

Colling Media; Phoenix (AZ); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

401(k)

Medical Insurance

Vision Insurance

Health savings account

Life Insurance

PTO

Referral Program

MetLife Law

Identity Protection

ClassPass

Pet Discount Program

Job summary

Colling Media is seeking a Data & Reporting Specialist to manage and evolve our data infrastructure. You will support reporting, dashboard development, data modeling, tracking, and data quality across the organization, with a focus on creating trustworthy insights.

The ideal candidate is highly analytical, can work under pressure, and will translate business questions into concrete SQL queries and dashboards. Hybrid schedule in Phoenix, with collaboration across teams.

Qualifications

• Bachelor’s degree in a technical field.
• 3–5 years building dashboards and reporting in a business environment.
• Experience with dashboarding or BI tools.
• Strong data visualization skills.
• Ability to translate stakeholder requests into practical reporting solutions.
• Experience with messy or incomplete datasets.

Responsibilities

• Create, maintain, and improve dashboards and reports in Looker Studio.
• Build and maintain data models that support reporting across multiple data sources.
• Write complex SQL queries to transform and structure data for reporting and analysis.
• Translate stakeholder ideas into technical reporting solutions.
• Create new dashboards and reporting solutions based on evolving business needs.
• Manage and improve data ingestion pipelines across multiple sources.
• Support and maintain the data warehouse and reporting infrastructure.
• Lead onboarding from a reporting perspective for new clients.
• Assist analytics and tracking implementation (GA4, GTM, conversion tracking) as needed.
• Diagnose and resolve tracking, attribution, and reporting issues.
• Navigate ad platforms to troubleshoot conversion discrepancies.
• Collaborate with leadership and cross-functional teams on data challenges.
• Learn and adapt to new platforms and data sources as needed.

Skills

SQL

Dashboarding

Data visualization

Analytical thinking

Communication

Independent work

Stakeholder communication

Education

Bachelor’s degree in a technical field such as Computer Science, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, or a related field

Tools

Looker Studio

BigQuery

Google Analytics 4

Google Tag Manager

Funnel.io

Advertising platforms

Job description

We are looking for a Data & Reporting Specialist to help manage and grow our agency’s data infrastructure. This person will play a critical role in supporting reporting, dashboard development, data modeling, tracking, and data quality across the organization. This is a strong fit for someone who is highly analytical, calm under pressure, and able to learn quickly in a fast-paced environment. The ideal candidate does not need deep experience in every platform we use, but they do need strong SQL skills, solid dashboarding experience, a strong understanding of data visualization, and the ability to work through complex reporting and data problems independently.

What You’ll Do

• Create, maintain, and improve dashboards and reports in Looker Studio
• Build and maintain data models that support reporting across multiple data sources
• Write complex SQL queries to transform, combine, and structure data for reporting and analysis
• Translate stakeholder ideas and business questions into technical reporting solutions
• Create new dashboards and reporting solutions based on evolving business needs
• Manage and improve data ingestion pipelines, including cleaning and normalizing data across multiple sources
• Support and maintain the agency’s data warehouse and broader reporting infrastructure
• Lead onboarding from a reporting and data setup perspective for new clients
• Help support analytics and tracking implementation, including GA4, GTM, and conversion tracking workflows as needed
• Diagnose and resolve tracking, attribution, and reporting issues
• Navigate ad platforms when necessary to troubleshoot conversion and attribution discrepancies
• Work closely with leadership and cross-functional teams to identify and solve reporting and data-related challenges
• Learn and adapt to new platforms, CRMs, and data sources as business needs evolve

What This Role Really Requires

This is not just a dashboard-building role. Success in this position requires someone who can take loosely defined reporting requests, understand the business question behind them, determine what data is needed, assess whether the request is technically possible, and build the queries, models, and reports needed to support it.

You should be comfortable working through ambiguity, solving problems independently, and figuring out unfamiliar systems as they come up. People across the organization will rely on this person for reporting and tracking guidance, so strong communication and a calm, solutions-oriented mindset are important.

Required Qualifications

• Bachelor’s degree in a technical field such as Computer Science, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, or a related field
• 3-5 years of professional experience building dashboards and reporting solutions in a business environment
• Experience with dashboarding or BI tools
• Strong understanding of data visualization best practices
• Experience working with real-world business data, including messy or incomplete datasets
• Ability to build or support complex data models for reporting and analysis
• Strong analytical and problem-solving skillsAbility to understand stakeholder requests and translate them into practical reporting solutions
• Strong communication skills, especially when working with non-technical teams
• Ability to work independently, manage priorities, and learn new systems quickly

Preferred Qualifications

• Experience with Looker Studio
• Experience with BigQuery / Google BigQuery
• Familiarity with Google Analytics 4
• Familiarity with Google Tag Manager
• Familiarity with ad platforms and conversion tracking
• Experience with data ingestion and normalization tools such as Funnel.io
• Experience in a digital marketing agency or other fast-paced, multi-client environment

Job Type: Full-time/Hybrid

• 401(k)
• Medical Insurance
• Vision Insurance
• Health savings account
• Life Insurance
• PTO
• Referral Program
• MetLife Law
• Identity Protection
• ClassPass
• Pet Discount Program

Hybrid Schedule: 8 hour shift - M, F Remotely and T, W, TH in office. During first 90 days, new hires are required to be in office M, T, W, TH and remote on Friday.