Data Developer

Company: The Shipyard
Job type: Full-time

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 Developer to join our Columbus team. 
The Data Developer is responsible for supporting end-to-end data development, from building data architectures for robust data sets to collecting & modeling data. You will work with internal departments to define their analytic requirements and set up their corresponding data environments. You will be a valued member with the opportunity to shape the way that we collect and share data, influencing processes and efficiency across the agency and its clientele.
This is a hybrid work-from-home/office position (in-office attendance is required on Tuesdays & Thursdays) and the candidate must live near Columbus, OH.
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
Support data needs for clients and internal teams in an agile work environment 
Collect data requirements from internal teams to assist in the design of a scalable infrastructure to drive decision-making using technology and BI tools 
Manage the retrieval, compiling, and formatting of large volumes of data 
Set up data environments, in partnership with the Data Visualization team, within business intelligence platforms, ultimately creating advertising reports 
Learn new technologies as they evolve, and understand their impact on systems 
Collaborate with internal teams and users to understand new opportunities for support 
Documentation of data environments and infrastructures developed
WHAT YOU'LL BRING
3-5 years equivalent work experience in Data Developer or similar Data & Analytics Role 
Experience in data modeling, development, and/or reporting 
Proficiency in SQL 
Knowledge of data modeling and entity relationships 
Ability to write code with clean documentation 
Strong entrepreneurial drive 
Strong verbal and written communication skills and a collaborative, problem-solving mindset 
Self-starting with initiative and passionate about learning the world of data strategy, architecture, processing, and development 
Not required, but preferred
Marketing & advertising knowledge 
Experience with data warehousing architecture and data modeling 
Experience building and supporting high-performance data models, visualizations, and KPIs for key initiatives 
Experience with data collection tools such as Fivetran, Snowflake, Panoply 
Experience with data transformation tools such as DBT 
Experience with cloud-based visualization tools such as Tableau, Looker, or Periscope
WHAT YOU'LL GET
The overall target range of base compensation for this role is $79,000 - $110,000. Compensation offered will be determined by additional factors such as location and experience
Open PTO
Flexible work hours and remote work
Paid holidays + vacation 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. 

Apply for this job