Data Coordinator

The Shipyard is a leading, independent agency that builds performance-driven brands audiences can’t help but love.

By applying modern mindsets to established models, we fuel brand and marketing decisions that are more courageous and more validated.

Our ability to align bold creativity with individual consumer motivations lets us do more than hope for brand love – we methodically engineer it throughout the consumer journey. That’s how we activate the synergistic power of brand building and performance marketing.

Engineering Brand Love through the courageous ambitions of our people and our clients.

The agency has significant momentum and is on a roll with new business. Our team continues to expand across four cities (Columbus, Newport Beach, Sacramento, and San Diego) and we’re still growing. Come join our team!

SUMMARY

We are looking for a smart, experienced, and motivated Data Coordinator to join our San Diego team. 

The Data Coordinator is a junior role for the Data Strategy career track. They will be tasked with owning the execution of tracking and tagging, reporting inputs and outputs, and quality assurance to support strategic initiatives. The Coordinator orchestrates monthly reporting across multiple clients – they will gather monthly reporting from all external publishers and sources, transform the data for ingestion into our ETL pipelines, track all monthly reporting to ensure all publishers are accurately reflected via BI tools, and partner with Data Strategists, Media Planners, and Account Managers in developing client-facing performance reports. The Data Coordinator is also responsible for working with account teams on ad hoc requests; resolving data discrepancies; and supporting data strategy ideation, execution, and quality assurance. 

This is a hybrid work-from-home/office position (in-office attendance is required on Tuesdays & Thursdays) and the candidate must live near San Diego, CA.

At The Shipyard, we know that it's your unique talents, backgrounds, and perspectives that make you who you are, just like our team, who come from various career paths and experiences. We believe we can't be truly diverse without bringing your most authentic self to the agency.  

Studies show that people from marginalized communities may not always apply for positions if they don't meet every single requirement in a job posting. At The Shipyard, we encourage you to apply even if you don't meet all the requirements. We believe that your passion for what we stand for — our values and purpose — is just as important as meeting every checkbox. 

WHAT YOU'LL DO

• Production of weekly, monthly, quarterly, and ad-hoc reports for various business needs 
• Support in analytical and research activities 
• Communicate with external data sources and internal data teams 
• Track all monthly reporting requirements 
• Transform data for ingestion into internal pipelines 
• Collaborate with team members to build new BI solutions and help track KPIs 
• Set up and organization of media tracking infrastructure

WHAT YOU'LL BRING

• 0-2 years equivalent work experience in a Data Coordinator or similar Data & Analytics Role role
• Required Qualifications 
• Working knowledge of Excel and pivot tables 
• Ability to communicate with people with different levels of marketing knowledge and data reporting concepts 
• Analytical and research skills 
• Excellent written and oral communication skills 
• Well organized, professional business attitude, personal maturity, and attention to detail 
• Flexibility, problem-solving skills, and learning skills 
• Self-starting with initiative and passionate about learning the world of data strategy, architecture, and processing
• Desired Qualifications 
• Understanding of marketing principles and KPIs 
• Understanding data structures, APIs, databases 
• Ability to create technical documents and user manuals 
• Highly organized with acute attention to detail 
• Google Analytics certification - a plus! 
• Familiarity with navigating user interface of BI tools - a plus!

WHAT YOU'LL GET

• The overall target range of base compensation for this role is $58,000 - $68,000. Compensation offered will be determined by additional factors such as location and experience
• Open PTO
• 40 hours of paid sick time (annually)
• Flexible work hours and remote work
• Paid holidays + holiday closure between Christmas Eve and New Year’s Day
• Company-paid medical, dental, and vision insurance
• Life insurance and disability benefits
• 401k program with employer matching
• 6 weeks paid parental leave
• Employee bonus referrals
• Dog-friendly offices 
• Company-provided snacks and beverages (yes, beer/wine included)
• … and lots more!

Requirements

• Must be authorized to work in the U.S. without the need for visa sponsorship.