Google Cloud Platform (GCP) Data Engineer

The work you'll do

• Design, develop, and maintain robust data pipelines and ETL processes that enable the seamless integration, cleansing, harmonization, and transformations in large-scale data processing systems and data lakes/data warehouses using GCP native services (BigQuery, Cloud Storage, Dataflow, Dataproc, Pub/Sub)
• Implement performance tuning (partitioning, broadcast joins, caching, shuffle optimization)
• Integrate data from multiple sources (databases, APIs, cloud storage, potentially streaming)
• Migrate legacy data stores and ETL pipelines to modernized, cloud-native architectures on GCP
• Develop scalable batch and real-time streaming data pipelines using Python, SQL, and Apache Beam
• Implement data governance, data quality checks, and secure data access controls in alignment with strict federal security requirements
• Collaborate with data scientists, cloud infrastructure engineers, and mission stakeholders to optimize data models and query performance
• Design and implement CI/CD pipelines to streamline the build, test, and deployment processes from development through to production environments

What you'll need

• 3 to 5+ years of experience in data engineering, data warehousing, or big data processing
• 2+ years of hands-on experience building data pipelines and/or data solutions on Google Cloud Platform (BigQuery, Dataflow, Cloud Composer)
• Strong programming skills in Python and advanced proficiency in SQL
• Experience with ETL/ELT concepts and tools

Bonus points if you have

• Google Cloud Professional Data Engineer Certification
• Experience with migrating legacy relational databases (e.g., Oracle, SQL Server) to cloud-native databases (e.g., Cloud SQL, AlloyDB, Spanner)
• Familiarity with federal data strategies, RMF, and Impact Level 4/5 (IL4/IL5) security and compliance standards

Security clearance: Active Top Secret (TS) security clearance is required.

Pay

The base pay range for this position in California, Colorado, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New York, Vermont, Virginia, Washington, and the District of Columbia, and the city of Cleveland is $100,200—$203,400 USD.