Data Engineer - BigQuery & Cloud Data Pipelines (Hybrid)

Northramp LLC

Washington (District of Columbia)

Hybrid

USD 110,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
401k retirement plan
Paid time off

Job summary

Northramp LLC is seeking a Data Engineer (BigQuery) to design, build, and operate cloud-native data pipelines, warehousing, and integration layers for enterprise data across IaaS, PaaS, and SaaS environments.

The role emphasizes production-ready data platforms with BigQuery as the primary warehouse, supporting analytics, AI/ML, and reporting for a federal-minded client. Hybrid work model in DC metro with on-site cadence.

Qualifications

  • 3 to 6 years of progressive, hands-on experience in data engineering with a focus on cloud data platforms and pipeline development.
  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, or a related field. Relevant experience may substitute.
  • Strong SQL skills and hands-on experience with BigQuery as an analytical data warehouse; familiarity with BigQuery optimization (partitioning, clustering, materialized views).
  • Proficiency in Python for data engineering tasks.
  • Working knowledge of data services from at least one major cloud provider.
  • Understanding of data modeling principles and schema design for analytical workloads.
  • Familiarity with data governance concepts — cataloging, lineage, access controls, retention — and their application in regulated environments.
  • Knowledge of FedRAMP, FISMA, and NIST 800‑53 data security requirements.
  • U.S. citizenship and the ability to obtain and maintain a DHS suitability / Public Trust clearance.
  • Eligible to work in the United States.

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, SQL, and Python; enforce testing and documentation standards across the data layer.
  • Implement and operate pipeline orchestration using Apache Airflow (Cloud Composer), Prefect, or equivalent; monitor pipeline health, SLA adherence, and failure alerting.
  • Integrate data platforms with upstream source systems including cloud-native services (AWS RDS, Azure SQL, GCS/S3), operational databases, and third-party SaaS APIs.
  • Implement data access controls, column-level security, and encryption within BigQuery and related cloud storage services aligned to FedRAMP High and FISMA requirements.
  • Build and maintain data cataloging and lineage metadata practices to support data governance and auditability requirements.
  • Collaborate with Data Scientists and analysts to ensure data availability, schema stability, and performance of analytical workloads.
  • Develop and maintain infrastructure-as-code for data platform components using Terraform; participate in CI/CD pipeline integration for data assets.
  • Support data quality frameworks — profiling, anomaly detection, and SLA monitoring — across production data pipelines.
  • Contribute to ATO documentation and data security controls including data classification, retention policies, and audit logging.

Skills

BigQuery
SQL
Python
ETL/ELT pipelines
Data modeling
Airflow/Cloud Composer
Data governance
FedRAMP/FISMA knowledge
U.S. citizenship

Education

Bachelor’s degree in Computer Science / Data Engineering / Information Systems / Mathematics

Tools

dbt
Apache Airflow / Cloud Composer
Terraform
GCS/S3

Job description

Northramp LLC is seeking a Data Engineer (BigQuery) to design, build, and operate cloud-native data pipelines, warehousing, and integration layers for enterprise data across IaaS, PaaS, and SaaS environments.

The role emphasizes production-ready data platforms with BigQuery as the primary warehouse, supporting analytics, AI/ML, and reporting for a federal-minded client. Hybrid work model in DC metro with on-site cadence.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BigQuery Data Engineer — Hybrid, DC Metro
BigQuery Data Engineer — Hybrid, DC Metro

Northramp LLC • Reston (VA)

Hybrid
USD 120,000 - 170,000
Health Plan (Medical, Dental & Vision)
401k Retirement Plan
Life Insurance
+7
BigQuery Data Engineer - Hybrid Cloud Analytics
BigQuery Data Engineer - Hybrid Cloud Analytics

Northramp LLC • Bethesda (MD)

Hybrid
USD 120,000 - 160,000
Health Care Plan (Medical, Dental &amp
401k, IRA
Life Insurance
+7
BigQuery Data Engineer | Hybrid (DC Metro) | FedRAMP
BigQuery Data Engineer | Hybrid (DC Metro) | FedRAMP

Northramp LLC • Vermont

Hybrid
USD 140,000 - 190,000
Health Care Plan
Retirement Plan
Life Insurance
+7
Data Engineer - GCP
Data Engineer - GCP

TechDigital Group • Washington

On-site
USD 90,000 - 130,000
GCP Data Engineer: BigQuery Pipelines & DBT (Hybrid, Atlanta)
GCP Data Engineer: BigQuery Pipelines & DBT (Hybrid, Atlanta)

Capgemini • Atlanta (GA)

Hybrid
USD 77,000 - 151,000
PTO policy
Health benefits
401(k)
+3
Data Engineer (BigQuery)
Data Engineer (BigQuery)

Northramp LLC • Vermont

Hybrid
USD 140,000 - 190,000
Health Care Plan
Retirement Plan
Life Insurance
+7
Data Engineer (BigQuery)
Data Engineer (BigQuery)

Northramp LLC • Reston (VA)

Hybrid
USD 120,000 - 170,000
Health Plan (Medical, Dental & Vision)
401k Retirement Plan
Life Insurance
+7
Data Engineer (BigQuery)
Data Engineer (BigQuery)

Northramp LLC • Washington

Hybrid
USD 110,000 - 160,000
Health insurance
401k retirement plan
Paid time off
GCP & BigQuery Data Engineer for Scalable Analytics
GCP & BigQuery Data Engineer for Scalable Analytics

TechDigital Group • Dallas (TX)

On-site
USD 90,000 - 130,000
Senior Cloud Data Engineer: BigQuery, Dataflow & ETL
Senior Cloud Data Engineer: BigQuery, Dataflow & ETL

CVS Health • United States

Remote
USD 83,000 - 222,000
Medical, dental, and vision coverage
Paid time off
Retirement savings
+1