Data Engineer (BigQuery / Cloud Data Platforms)

About this role

Opportunity Overview

Northramp is seeking a Data Engineer to join the team supporting the client's Cloud BPA Bridge program — a mission-critical effort to consolidate, modernize, and operate the client's enterprise cloud services across IaaS, PaaS, and SaaS environments under FedRAMP High authorization.

You will design and operate cloud-native data pipelines, warehousing, and integration layers that make the client's data accessible, reliable, and analytics-ready. The role centers on modern cloud data platforms — with BigQuery as the primary analytical data warehouse — supporting the client's enterprise reporting, AI/ML, and program management data needs.

This role is part of Northramp’s integrated delivery model, where engineers and advisors work as one team to bring sound judgment, disciplined execution, and deep federal experience to high-stakes modernization programs.

Location & Work Arrangement

Hybrid, based in the Washington, DC metro area. On-site presence at designated client locations is expected on a cadence aligned to program needs. Remote work is supported around mission and security requirements. This role is not open to candidates outside the DC region.

The Ideal Candidate

You build data pipelines that run reliably in production — not just demos. You’ve designed schemas and ingestion pipelines against messy, real-world source systems, you understand data quality as an engineering discipline, and you can work comfortably within the access controls and compliance requirements of a federal environment.

Key Responsibilities

• Design, build, and maintain scalable ELT/ETL data pipelines ingesting structured and semi-structured data from cloud services, APIs, databases, and file sources into BigQuery and other cloud data warehouses.
• Develop and manage data models, schemas, and transformation logic using dbt (data build tool), SQL, and Python; enforce testing and documentation standards across the data layer.
• Implement and operate ...