Senior Data Engineer
San Diego, California, United States
Applications have closed
The Shipyard
Proud to be Adweek Fastest Growing Independent Agency. We build performance-driven brands that audiences love. Offices in OH and CA. Serving clients globally. | shipyardThe 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 Senior Data Engineer to join our San Diego team.
The Senior Data Engineer is a managerial position within our Data Development career track. This role will have management responsibilities starting with 1-2 direct reports and will grow as the team continues to scale. In addition to serving as a coach and manager for other Data Developers, the role requires daily hands-on development execution and technology roadmap leadership. The Senior Data Engineer is responsible for leading 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 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
- Lead 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, understand their impact to systems, and lead the team in proposed tech stack evolutions
- Leadership in implementing technological advancements as well as educating internal and external partners
- Collaborate with internal teams and users to understand new opportunities for support
- Documentation of data environments and infrastructures developed
WHAT YOU’LL BRING
- 5-6 years equivalent work experience in a Data Developer or similar Data & Analytics Role
- Experience in data collection, transformation, development, and/or reporting with optimized outputs for BI tools
- Experience developing and optimizing data ingestion processes with tools such as Fivetran, Stitch, and even writing custom API scripts.
- Experience designing, building, and maintaining robust data pipelines (ETL/ELT) using technologies like Postgres, dbt, and Airflow.
- Experience with AWS services, Kubernetes, and Docker.
- Experience with data modeling / semantic modeling
- Experience with data warehousing architecture (Postgres, AWS Redshift)
- Experience in applying data processes and deploying BI updates at scale
- A testing mindset – Knowledge and experience of CI/CD pipelines and test environments
- Proficiency in SQL, Python, and/or Scala/Java
- Experience contributing to and influencing tech stack evolutions and infrastructure roadmap
- 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
- Experience balancing multiple deliverables across multiple clients and data sets
- Experience with /awareness of cloud-based visualization tools such as Tableau, Looker, or Periscope
- Marketing & advertising knowledge (preferred, not required)
WHAT YOU'LL GET
- The overall target range of base compensation for this role is $110,000 - $137,000. Compensation offered will be determined by additional factors such as location and experience
- 40 hours of paid sick time (annually)
- Open PTO
- 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.
Tags: Agile Airflow APIs Architecture AWS Business Intelligence CI/CD Data pipelines Data strategy Data visualization Data Warehousing dbt Docker ELT Engineering ETL FiveTran Java Kubernetes Looker Periscope Pipelines PostgreSQL Python Redshift Scala SQL Tableau Testing
Perks/benefits: Career development Flex hours Flex vacation Health care Home office stipend Insurance Medical leave Parental leave Pet friendly Salary bonus Snacks / Drinks
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Junior Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs