Marketing Data & Reporting Specialist

Marketing Data & Reporting SpecialistAbout the RoleWe 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.

While professional experience and qualifications are key for this role, make sure to check you have the preferable soft skills before applying if required.
What You’ll DoCreate, 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
What This Role Really RequiresThis 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 QualificationsBachelor’s degree in a technical field such as Computer Science, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, or a related field3-5 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 QualificationsExperience 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 Experience in a digital marketing agency or other fast-paced, multi-client environment
Job Type: Full-time/HybridBenefits:401(k)Medical InsuranceDental InsuranceVision InsuranceHealth savings accountLife InsurancePTOParental LeaveReferral ProgramMetLife LawIdentity ProtectionClassPassPet Discount Program
Hybrid Schedule: 8 hour shift - M, F Remotely and T, W, TH in office. xzbcwsv During first 90 days, new hires are required to be in office M, T, W, TH and remote on Friday.