Sr Cloud ETL Developer

Summary:

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:

Pipeline Development:

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.

Collaboration & Leadership

• 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