Sr. Technical Data Analyst (GCP)
ΠΡΡΡ & Π‘ΠΎΠΏΡΠΎΠ²ΠΎΠ΄
ΠΠ»Ρ ΠΌΡΡΡΠ° Ρ ΡΡΠΎΠΉ Π²Π°ΠΊΠ°Π½ΡΠΈΠ΅ΠΉ Π½ΡΠΆΠ΅Π½ Plus
ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ Π²Π°ΠΊΠ°Π½ΡΠΈΠΈ
TL;DR
Sr. Technical Data Analyst (GCP): Managing cloud/AI usage costs and project capacity by analyzing historical query volume and platform activity with an accent on infrastructure scaling and cost optimization. Focus on monitoring API/AI agent usage, optimizing query performance across BigQuery and Trino, and reconciling usage across AWS and GCP.
Location: Remote (US) or Hybrid in Newark, NJ. Must be based in the United States. Time zone: 9am-6pm ET preferred.
Salary: $110k-120k base + 11-12k bonus
Company
is an adtech company focusing on granular data platform optimization and transparent leadership.
What you will do
- Model client growth trajectories to translate them into infrastructure and capacity scaling scenarios.
- Monitor API and AI agent usage patterns to anticipate future client needs and assist in dataset knowledgebase creation.
- Optimize query performance across Trino, Spark SQL, and BigQuery while tracking cost trends.
- Own product analytics reporting, focusing on usage, utilization, and growth.
- Reconcile usage and flag anomalies across AWS, GCP, and AI/ML tooling.
- Partner with engineering and product teams on database scaling decisions driven by client demand.
Requirements
- 3-5+ years of experience in data analytics, capacity planning, or BI roles.
- Bachelor's degree in Computer Science, Analytics, Statistics, or a related field.
- Must be based in the United States.
- Strong SQL skills with required experience in Trino and/or BigQuery.
- Experience working cross-functionally with Engineering, Product, Finance, and Sales teams.
- Preferred availability for 9am-6pm ET time zone.
Nice to have
- Hands-on experience with GCP Billing console and cost monitoring.
- Experience with Tableau or Looker for self-serve dashboards and operational reporting.
- Prior vendor contract negotiation or procurement experience.
- Experience with DB context management platforms (e.g., DataHub).
Culture & Benefits
- Comprehensive healthcare with medical, dental, and vision options.
- 100%-paid life and disability insurance.
- 401(k) match and annual tuition assistance.
- Generous paid vacation, sick time, and paid parental leave.
- Better Yourself Wellness program and group volunteer opportunities.
- Commuter benefits and commuting subsidy.
Hiring process
- Two SQL tests (45 minutes and 25 minutes).
- Initial 15-minute phone screen.
- 30-minute SQL interview.
- Hiring Manager and Team interviews.
ΠΡΠ΄ΡΡΠ΅ ΠΎΡΡΠΎΡΠΎΠΆΠ½Ρ: Π΅ΡΠ»ΠΈ ΡΠ°Π±ΠΎΡΠΎΠ΄Π°ΡΠ΅Π»Ρ ΠΏΡΠΎΡΠΈΡ Π²ΠΎΠΉΡΠΈ Π² ΠΈΡ ΡΠΈΡΡΠ΅ΠΌΡ, ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΡ iCloud/Google, ΠΏΡΠΈΡΠ»Π°ΡΡ ΠΊΠΎΠ΄/ΠΏΠ°ΡΠΎΠ»Ρ, Π·Π°ΠΏΡΡΡΠΈΡΡ ΠΊΠΎΠ΄/ΠΠ, Π½Π΅ Π΄Π΅Π»Π°ΠΉΡΠ΅ ΡΡΠΎΠ³ΠΎ - ΡΡΠΎ ΠΌΠΎΡΠ΅Π½Π½ΠΈΠΊΠΈ. ΠΠ±ΡΠ·Π°ΡΠ΅Π»ΡΠ½ΠΎ ΠΆΠΌΠΈΡΠ΅ "ΠΠΎΠΆΠ°Π»ΠΎΠ²Π°ΡΡΡΡ" ΠΈΠ»ΠΈ ΠΏΠΈΡΠΈΡΠ΅ Π² ΠΏΠΎΠ΄Π΄Π΅ΡΠΆΠΊΡ. ΠΠΎΠ΄ΡΠΎΠ±Π½Π΅Π΅ Π² Π³Π°ΠΉΠ΄Π΅ β