Senior Analytics Engineer
Core
Design, develop, and optimize scalable data transformation pipelines in BigQuery while managing a Common Data Model (CDM) hub to support enterprise data warehouse modernization from Teradata to Google Cloud.
Role type
Senior Analytics Engineer (Data Platform Modernization)
Builds
Scalable data pipelines, CDM hubs, and migrated data warehouse workloads
Domain
Enterprise Data Warehousing, Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL (complex transformations, optimization), Google Cloud Platform (BigQuery), Dataform (or dbt), Data Modeling (dimensional, hub-and-spoke), Business KPI translation, Data Quality Testing/Validation, AI Tool Usage
Preferred skills
Teradata (SQL, BTEQ), Python, GCP Data Services (Airflow, Dataflow, Pub/Sub), BI Tools (Looker, Power BI), CI/CD, Infrastructure-as-Code
Technologies
BigQuery, Dataform, Teradata, Python, Airflow, Dataflow, Pub/Sub, Cloud Storage, Dataplex, Looker, Power BI, Tableau
Responsibilities
Design and optimize scalable data transformation pipelines in BigQuery; Support migration of data models from Teradata to BigQuery; Discover, document, and manage the Common Data Model (CDM) hub; Enable onboarding of new CDM consumers; Analyze business KPIs and ensure accurate implementation in data models; Maintain deep knowledge of data structures and semantics; Drive testing, validation, and reconciliation activities; Improve BigQuery workloads for performance and cost efficiency; Contribute to documentation and modeling standards; Partner with engineers, analysts, and stakeholders to deliver trusted data products
Seniority
Senior, hands-on IC
