Sr Cloud ETL Developer

Senior ETL Developer 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. Pay Range: Minimum: $ 111,525 - Maximum: $ 146,744 Applicants are required to be eligible to lawfully work in the United States immediately. This position is not available for H1-B visa sponsorship. 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). NTTA is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability or veteran status. North Texas Tollway Authority