Marketing Data Reporting and Analyst

Data & Reporting Specialist

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.

Responsibilities:

Create, maintain, and improve dashboards and reports in Looker StudioBuild and maintain data models that support reporting across multiple data sourcesWrite complex SQL queries to transform, combine, and structure data for reporting and analysisTranslate stakeholder ideas and business questions into technical reporting solutionsCreate new dashboards and reporting solutions based on evolving business needsManage and improve data ingestion pipelines, including cleaning and normalizing data across multiple sourcesSupport and maintain the agency’s data warehouse and broader reporting infrastructureLead onboarding from a reporting and data setup perspective for new clientsHelp support analytics and tracking implementation, including GA4, GTM, and conversion tracking workflows as neededDiagnose and resolve tracking, attribution, and reporting issuesNavigate ad platforms when necessary to troubleshoot conversion and attribution discrepanciesWork closely with leadership and cross-functional teams to identify and solve reporting and data-related challengesLearn and adapt to new platforms, CRMs, and data sources as business needs evolve

Required Qualifications

Bachelor’s degree in a technical field such as Computer Science, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, or a related field2-4 years of professional experience building dashboards and reporting solutions in a business environmentStrong SQL skillsExperience with dashboarding or BI toolsStrong understanding of data visualization best practicesExperience working with real-world business data, including messy or incomplete datasetsAbility to build or support complex data models for reporting and analysisStrong analytical and problem-solving skillsAbility to understand stakeholder requests and translate them into practical reporting solutionsStrong communication skills, especially when working with non-technical teamsAbility to work independently, manage priorities, and learn new systems quickly

Preferred Qualifications

Experience with Looker StudioExperience with BigQuery / Google BigQueryFamiliarity with Google Analytics 4Familiarity with Google Tag ManagerFamiliarity with ad platforms and conversion trackingExperience with Python or JavaScriptExperience with data ingestion and normalization tools such as Funnel.ioExperience in a digital marketing agency or other fast-paced, multi-client environment

Key Traits for Success

Calm under pressureQuick learnerIndependent and self-sufficientAnalytical thinkerStrong communicatorStrong time management skillsPatient when supporting non-technical stakeholdersComfortable solving unfamiliar problems without step-by-step directionAble to use AI tools effectively for research, troubleshooting, and problem-solving

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. Teams across the organization will rely on this person for reporting and tracking guidance, so strong communication and a calm, solutions-oriented mindset are important.

Company DescriptionColling Media is an innovative, full-service advertising and marketing agency based in Phoenix, AZ. We pride ourselves in our ability to deliver leads and fuel growth for businesses. We also place a huge emphasis on company culture, having fun, and our G.O. H.A.R.D. values (Go the extra mile, over-communicate, humble confidence, always improving, results-driven, do what you say). Our mission is to help people succeed, and this mission extends to our clientele, our employees, our employees' families and beyond. We specialize in advertising across a wide variety of channels, such as Google Ads, Facebook Ads, Tiktok, Snapchat, LinkedIn, TV, Radio, Outdoor and SEO.