Piper Companies · 1 day ago
Data Architect
Piper Companies is looking for a Data Architect to join a leading advertising agency in a fully remote role. The main purpose of the role is to design and implement a modern data warehouse solution leveraging Google Cloud Platform and Snowflake, while collaborating with stakeholders to ensure data solutions meet reporting and campaign performance requirements.
Management Consulting
Responsibilities
Lead the architecture and design of a scalable data warehouse solution using GCP and Snowflake
Develop and optimize data pipelines, ETL processes, and integrations for large, complex datasets
Define data modeling standards, governance practices, and performance tuning strategies for analytics workloads
Collaborate with business stakeholders and data analysts to ensure data solutions meet reporting and campaign performance requirements
Qualification
Required
6–8+ years of experience in data engineering or data architecture roles
Deep expertise in Snowflake and Google Cloud Platform (BigQuery, Cloud Storage, Dataflow, Pub/Sub)
Strong proficiency in SQL, data modeling, and ETL development for enterprise-scale data warehouses
Hands-on experience using Fivetran for data ingestion pipelines in modern data architectures
Experience with data governance, security, and performance optimization in cloud environments
Must be eligible to work in the United States and obtain an Active U.S. Government Secret Clearance
Bachelor's degree in Computer Science, Data Engineering, or related field
Preferred
Familiarity with advertising or marketing analytics is a plus
Advanced certifications in GCP or Snowflake preferred
Benefits
Medical
Dental
Vision
401K
PTO
Sick Leave (if required by law)
Holidays