AI Summary
Design and implement a modern data warehouse solution using GCP and Snowflake. Develop and optimize data pipelines, ETL processes, and integrations for large, complex datasets. Collaborate with business stakeholders and data analysts to ensure data solutions meet reporting and campaign performance requirements.
Key Highlights
Lead the architecture and design of a scalable data warehouse solution
Develop and optimize data pipelines, ETL processes, and integrations
Collaborate with business stakeholders and data analysts
Technical Skills Required
Benefits & Perks
Salary/Rate Range: $75 - $85 per hour
Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave, and Holidays
Job Description
Piper Companies is looking for a Data Architect to join a leading advertising agency in a fully remote role to design and implement a modern data warehouse solution leveraging Google Cloud Platform (GCP) and Snowflake on a 6–9 month contract working EST hours.
Responsibilities for the Data Architect:
- 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.
- 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.
- 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.
- Familiarity with advertising or marketing analytics is a plus.
- Bachelor’s degree in Computer Science, Data Engineering, or related field; advanced certifications in GCP or Snowflake preferred.
- Salary/Rate Range: $75 - $85 per hour (based on experience).
- Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave (if required by law), and Holidays.
Keywords: Data Architect, Data Engineer, GCP, Google Cloud Platform, Snowflake, Data Warehouse, ETL, BigQuery, Cloud Storage, Data Modeling, SQL, Advertising Analytics, Marketing Data, Data Governance, Performance Tuning
Similar Jobs
Explore other opportunities that match your interests
Visa Sponsorship
Relocation
Remote
Job Type
Contract
Experience Level
Mid-Senior level
KPG99 INC
United State
Software Development Engineer (Rust/Python)
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
Experis
United State
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
close
United State