Senior Engineer_Data Engineer_7

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

It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business. Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets; an ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work® Institute and recognized as a 'Cool Vendor' and a 'Vendor to Watch' by Gartner. Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Role Overview

We are looking for a skilled Data Engineer to join our team and support the build-out of scalable, reliable data infrastructure on the Google Cloud Platform. In this role, you will work on migrating data from Teradata to BigQuery, building and maintaining end-to-end data pipelines, and ensuring data quality and integrity throughout the platform. You will collaborate closely with data analysts, architects, and business stakeholders to translate requirements into robust, production-ready solutions.

Key Responsibilities

• Write efficient, optimized SQL queries to extract, clean, transform, and analyze large and complex datasets from multiple sources.
• Automate repetitive data workflows and reporting processes to improve efficiency and reduce manual effort.
• Document methodologies, code, and findings clearly for reproducibility and knowledge sharing.
• Execute migration tasks under the guidance of senior engineers and architects.
• Build ingestion scripts, transformation logic, and end-to-end data pipelines.
• Support migration of data from Teradata to BigQuery.
• Implement pipeline monitoring, logging, and alerting to ensure reliability.
• Support testing, validation, and reconciliation of migrated datasets to ensure data integrity.
• Maintain and update technical documentation and operational runbooks.
• Collaborate with cross-functional teams including data analysts, architects, and business stakeholders to understand requirements.

Required Skills & Experience

• Strong SQL and Python skills.
• Basic-to-intermediate experience with GCP services, including BigQuery, GCS, Composer, and Cloud Functions.
• Solid understanding of ETL/ELT data flows and pipeline design.
• Experience working with APIs, file-based ingestion, and orchestration tools.
• Ability to test, validate, and debug data pipelines effectively.
• Hands‑on exposure to migration tools such as Storage Transfer Service, gsutil, and bq CLI.
• Understanding of Teradata-to-GCP mapping concepts (e.g., Teradata → GCS, ADF → Composer).
• Familiarity with CI/CD concepts and practices.
• Exposure to version control systems such as Git for code management and collaboration.
• Understanding of data security, access controls, and governance best practices in cloud environments.
• Familiarity with data quality frameworks and reconciliation techniques.
• Good communication and problem‑solving skills, with the ability to work independently and in a team setting.

Preferred Skills

• Working knowledge of Spark via Dataproc.
• Prior experience with large-scale data migration projects from on‑premise or legacy systems to cloud platforms.
• Exposure to data cataloging or metadata management tools.

Pay The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: $140,000 – $150,000. In addition, you may be eligible for a discretionary bonus for the current performance period.

• As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time.
• You will be eligible for benefits on the first day of employment with the Company.
• you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms.
• The Company provides for 11 paid holidays and 12 weeks of Parental Leave.
• We also follow a "free time" PTO policy, allowing you the flexibility to take time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

At Fractal, towards our goal of “powering every human decision in the enterprise”, our partnerships and alliances help in creating and delivering a compelling suite of solutions to unlock value. We partner with companies from around the globe, leaders in their respective fields. With Fractal’s expertise in artificial intelligence, design, engineering, and digital transformation, combined with the data, technology, and software platforms from our partners, we create cutting‑edge solutions to problems in the business world. We understand how critical and timely decision triggers, and information, empower our clients to create, unlock, deliver, and realize value. Together with our partners, our goal is to serve each client in their end‑to‑end data‑to‑decision journey.