Sr Cloud ETL Developer

North Texas Tollway Authority; Plano (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

North Texas Tollway Authority in Plano, TX is seeking a Senior ETL Developer specializing in Google Cloud Platform and BigQuery to design, build, and optimize large-scale data pipelines.

You will work with advanced SQL and Python, orchestrate with Cloud Composer, and partner with analytics leaders to deliver scalable cloud-native data solutions and governance. This role also involves enterprise reporting tools like MicroStrategy, Power BI, and Tableau, plus data quality and cost optimization.

Qualifications

• Bachelor’s degree in CS, IS, or related field.
• 6-10+ years of ETL/Data Engineering experience.
• 8-10+ years of SQL experience.
• 8+ years of data architecture/engineering experience.
• Strong expertise with GCP (BigQuery, Composer, Dataflow, Cloud Storage).
• Hands-on with Fivetran, Google DTS, or equivalent ingestion tools.
• Proficiency with enterprise reporting platforms (MicroStrategy, Power BI, Tableau).
• Advanced SQL and data modeling expertise.
• Experience designing secure and governed data environments.

Responsibilities

• Design and build complex ETL/ELT pipelines for structured and unstructured data sources using GCP native services.
• Build and orchestrate automated data pipelines using Fivetran, Google DTS, and custom ETL/ELT frameworks.
• Create robust ingestion patterns for batch and streaming data.
• Troubleshoot data integration issues, latency problems, and pipeline failures.
• Partner with application teams to integrate SaaS, on-prem, and cloud sources.
• Implement BigQuery best practices, including data modeling, partitioning, clustering, and cost/performance tuning.
• Build reusable workflow frameworks using orchestration tools like Cloud Composer and Git-based CI/CD pipelines.
• Enforce strict data validation, observability, schema handling, and reconciliation for enterprise data.
• Partner with data science, Data Analytics, AI, and business teams to translate requirements into technical solutions.
• Implement data access controls leveraging IAM, service accounts, and VPC-SC; ensure compliance with data standards; design disaster recovery and high-availability strategies.
• Mentor junior engineers and support cross-functional architecture reviews.

Skills

ETL/Data Engineering

SQL

GCP / BigQuery

Python

Data Warehousing

Education

Bachelor’s degree in computer science, Information Systems, or related field

Tools

Fivetran

Google DTS

Cloud Composer

Dataflow

Dataproc

Job description

A Senior ETL Developer specializing in Google Cloud Platform (GCP) and BigQuery designs, builds, and optimizes large-scale data pipelines. This role requires advanced SQL, Python, orchestration (Airflow), and data warehousing skills to deliver scalable, reliable data solutions. This role focuses on cloud-native data architecture on Google Cloud Platform (GCP) while integrating enterprise reporting tools including MicroStrategy and cloud-based data movement technologies such as Fivetran and Google Data Transfer Service (DTS). The Data Architect will collaborate with business stakeholders, engineering teams, and analytics leaders to deliver scalable, reliable, and modern data platforms.

Responsibilities

Design and build complex ETL/ELT pipelines for structured and unstructured data sources using GCP native services like Cloud Storage, Dataflow, and Dataproc, Data Integration & ETL/ELT

• Build and orchestrate automated data pipelines using Fivetran, Google DTS, and custom ETL/ELT frameworks.
• Create robust ingestion patterns for batch and streaming data.
• Troubleshoot data integration issues, latency problems, and pipeline failures.
• Partner with application teams to integrate SaaS, on-prem, and cloud sources.

BigQuery Optimization

Implement BigQuery best practices, including data modeling, partitioning, clustering, and cost/performance tuning.

Orchestration & Automation

Build reusable workflow frameworks using orchestration tools like Cloud Composer and Git-based CI/CD pipelines.

Data Quality & Governance

Enforce strict data validation, observability, schema handling, and reconciliation for enterprise data.

Cross-Functional Collaboration

Partner with data science, Data Analytics, AI, and business teams to translate requirements into technical solutions.

Security, Compliance & Governance

• Implement data access controls leveraging IAM, service accounts, and VPC-SC.
• Ensure compliance with organizational and industry data standards.
• Design disaster recovery, backup, and high-availability strategies.
• Experience with Data Governance Framework, Data Quality, Data Stewardship, Ontology and Data Lineage.
• Work closely with product owners, data engineers, analysts, and architects across the organization.
• Serve as a technical advisor for large enterprise reporting and integration initiatives.
• Mentor junior engineers and support cross-functional architecture reviews.

Qualifications

Minimum

• Bachelor’s degree in computer science, Information Systems, or related field.
• 6-10+ years of ETL/Data Engineering experience.
• 8-10+ years of SQL experience.
• 8+ years of experience in data architecture or data engineering.
• Strong expertise with GCP (BigQuery, Composer, Dataflow, Cloud Storage).
• Hands-on experience with Fivetran, Google DTS, or equivalent ingestion tools.
• Proficiency with enterprise reporting platforms (preferably MicroStrategy, plus Power BI/Tableau).
• Advanced SQL and data modeling expertise.
• Experience designing secure and governed data environments.

Preferred Qualifications

• Advanced SQL Experience.
• Advanced Stored Procedures Skill.
• Python experience for pipeline and orchestration scripting.
• Experience with cloud cost optimization and FinOps practices.
• Familiarity with streaming architectures (Pub/Sub -> Dataflow).
• Knowledge of data catalog tools (Dataplex, Collibra, Alation).

About NTTA

NTTA is a political subdivision of Texas created to acquire, construct, maintain and operate toll roads in North Texas. As a customer-driven organization, NTTA delivers a safe and reliable toll system for millions of customers each year in one of the fastest growing regions in the United States. NTTA is a vibrant organization with a highly qualified, energized and engaged team focused on achieving Excellence and we are looking for talented individuals to join us.

Our mission

We are committed to providing a safe and reliable toll road system, increase value and mobility options for our customers, operate the Authority in a businesslike manner, protect our bondholders, and partner to meet our region's growing need for transportation infrastructure