Senior Data Engineer - GCP Pipelines & Teradata Migration

Fractal Analytics Inc; California (MO); On-site; USD 140,000 - 150,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

11 paid holidays

Parental leave (12 weeks)

401(k) plan

Job summary

Fractal Analytics Inc is seeking a Data Engineer to build scalable data infrastructure on Google Cloud Platform. You will migrate data from Teradata to BigQuery, create end-to-end pipelines, and ensure data quality while working with analysts, architects, and business stakeholders.

The role emphasizes optimizing SQL/Python, implementing automated workflows, and maintaining robust documentation. Strong collaboration and communication are essential for success in this team-driven environment.

Qualifications

• Strong SQL and Python skills.
• Basic-to-intermediate experience with GCP services (BigQuery, GCS, Composer, Cloud Functions).
• Solid understanding of ETL/ELT data flows and pipeline design.
• Experience with APIs, file-based ingestion, and orchestration tools.
• Ability to test, validate, and debug data pipelines.
• Hands-on with migration tools (Storage Transfer Service, gsutil, bq CLI).
• Understanding of Teradata-to-GCP mapping concepts (Teradata→GCS, ADF→Composer).
• Familiarity with CI/CD concepts and Git for code management.
• Understanding of data security, access controls, governance, and data quality.
• Good communication and problem-solving skills.

Responsibilities

• Write efficient SQL queries to extract, clean, transform, and analyze large datasets.
• Automate data workflows and reporting processes to improve efficiency.
• Document methodologies, code, and findings for reproducibility.
• Execute migration tasks under senior engineers' guidance.
• Build ingestion scripts and end-to-end data pipelines.
• Support migration of data from Teradata to BigQuery.
• Implement pipeline monitoring, logging, and alerting for reliability.
• Test, validate, and reconcile migrated datasets for integrity.
• Maintain technical documentation and operational runbooks.
• Collaborate with data analysts, architects, and stakeholders to gather requirements.

Skills

SQL

Python

ETL/ELT

APIs

Data pipelines

CI/CD

Git

Data security

Governance

Data quality

Teradata-to-GCP mapping

Data migration

Tools

BigQuery

GCS

Composer

Cloud Functions

Storage Transfer Service

gsutil

bq CLI

Job description

Fractal Analytics Inc is seeking a Data Engineer to build scalable data infrastructure on Google Cloud Platform. You will migrate data from Teradata to BigQuery, create end-to-end pipelines, and ensure data quality while working with analysts, architects, and business stakeholders.

The role emphasizes optimizing SQL/Python, implementing automated workflows, and maintaining robust documentation. Strong collaboration and communication are essential for success in this team-driven environment.