Data Architect
Remote
Job Id:
156440
Job Category:
Job Location:
Remote
Security Clearance:
No Clearance
Business Unit:
Piper Companies
Division:
Piper Enterprise Solutions
Position Owner:
Beth Roberts
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.
Qualifications for the Data Architect:
- 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.
Compensation/Benefits for the Data Architect / Data Engineer:
- 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.
This job opens for applications on 12/12/2025. Applications for this job will be accepted for at least 30 days from the posting date.
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
#LI-BR1
#LI-REMOTE