Data Warehouse Software Engineer III (GCP)

Location: Somerville, Massachusetts, United States. U.S. Citizenship is required due to federal government contract requirements.

Salary: $120,000–$135,000 USD per year, based on qualifications and experience.

Company

hirify.global provides AI, identity intelligence, risk operations, and data analytics solutions for government and commercial organizations.

What you will do

• Architect, build, and maintain production ELT/ETL pipelines for high-volume batch and streaming datasets in Google BigQuery.
• Manage, monitor, configure, and upgrade Apache Airflow and Cloud Composer environments.
• Develop modular Python DAGs, custom operators, hooks, API connectors, and automation tools.
• Optimize BigQuery, Cloud Storage, Cloud Functions/Run, Pub/Sub, and IAM for performance, reliability, and cost control.
• Implement data quality monitoring, automated alerting, schema validation, and safeguards against data loss.
• Maintain infrastructure-as-code and CI/CD pipelines, contribute to architecture reviews, and mentor junior engineers.

Requirements

• U.S. Citizenship is required.
• 4–7+ years of professional software development experience, including 3+ years focused on data warehousing, cloud data pipelines, and data platform operations.
• Advanced production-grade Python development skills for data processing, pipeline tooling, and API integrations.
• Hands-on Apache Airflow experience, including DAG architecture, troubleshooting, environment configuration, and platform upgrades; Cloud Composer experience is preferred.
• Deep experience with GCP analytics services, including BigQuery, Cloud Storage, Cloud Composer, Pub/Sub, and Cloud Functions/Run.
• Proficiency with Git, CI/CD pipelines, BigQuery optimization, and modern software development workflows.

Nice to have

• Google Cloud Certified Professional Data Engineer certification.
• Experience with multi-terabyte or billion-row datasets, unstructured web-scraped data, or streaming architectures.
• Familiarity with government compliance frameworks, IAM policy design, and data encryption standards.

Culture & Benefits

• Medical, dental, vision, life, and disability insurance, with hirify.global covering 85–100% of monthly premiums for employees and families.
• Traditional and Roth 401(k) plans with a competitive company match.
• Unlimited flexible leave and 12 paid federal holidays.
• Tuition reimbursement for continuing education.