Data Engineer (BigQuery)

Northramp LLC

Vermont

Hybrid

USD 140,000 - 190,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 Care Plan
Retirement Plan
Life Insurance
Paid Time Off
Family Leave
Disability Insurance
Training & Development
Work From Home
Wellness Resources
Employee Bonus Programs

Job summary

Northramp LLC is seeking a Data Engineer (BigQuery) to design, build, and operate cloud‑native data pipelines, warehousing, and integration layers for an enterprise data platform. The role centers on BigQuery as the primary analytics warehouse, supporting reporting, AI/ML, and program management data needs.

You will work in a hybrid setup with on‑site client locations in the DC metro area and remote‑friendly requirements aligned to mission and security constraints.

Qualifications

  • 3–6 years of hands‑on data engineering with cloud data platforms.
  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, or related field.
  • Strong SQL and BigQuery experience; optimization (partitioning, clustering, materialized views).
  • Proficiency in Python for data engineering tasks.
  • Working knowledge of cloud data services from major providers.
  • Understanding of data modeling for analytical workloads.
  • Familiarity with data governance concepts in regulated environments.
  • Knowledge of FedRAMP, FISMA, and NIST 800-53 data security requirements.
  • U.S. citizenship and ability to obtain DHS Public Trust clearance.
  • Eligible to work in the United States.

Responsibilities

  • Design, build, and maintain scalable ELT/ETL pipelines ingesting data from cloud services, APIs, databases, and files into BigQuery and other warehouses.
  • Develop data models, schemas, and transformation logic using dbt, SQL, and Python; enforce testing and documentation.
  • Implement and operate pipeline orchestration with Airflow/Cloud Composer; monitor health and SLAs.
  • Integrate data platforms with upstream sources including AWS, Azure, GCS/S3, and third‑party SaaS APIs.
  • Enforce data access controls, encryption, and security aligned to FedRAMP High and FISMA.
  • Build data cataloging and lineage practices for governance and auditability.
  • Collaborate with Data Scientists and analysts to ensure data availability and performance.
  • Develop infrastructure‑as‑code for data components using Terraform; contribute to CI/CD for data assets.
  • Support data quality with profiling, anomaly detection, and SLA monitoring.
  • Contribute to ATO documentation and data security controls.

Skills

SQL
BigQuery
Python
Cloud platforms
Data modeling
FedRAMP/FISMA awareness
ETL/ELT pipelines
Airflow/Cloud Composer

Education

Bachelor’s degree in CS/IS/Math

Tools

dbt
Terraform
CI/CD

Job description

Opportunity Overview

Northramp is seeking a Data Engineer (BigQuery) to join the team supporting a mission-critical effort to consolidate, modernize, and operate our client's enterprise cloud services across IaaS, PaaS, and SaaS environments.

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, Maryland, and Virginia 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 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.
Required 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.
Desired Qualifications
  • Experience with dbt for data transformation and modeling in cloud warehouse environments.
  • Hands‑on experience with pipeline orchestration tools such as Apache Airflow or Cloud Composer.
  • Google Cloud Professional Data Engineer certification.
  • AWS Certified Data Analytics Specialty or Azure Data Engineer Associate.
  • Security+ or equivalent certification.
  • Experience with streaming data platforms (Pub/Sub, Kafka, Kinesis).
  • DHS, or other federal data engineering experience.
  • Active Public Trust or higher clearance.
Clearance

DHS suitability and a Public Trust background investigation are required for this role. Active Public Trust or higher clearance is preferred. Selected applicants will be subject to a security investigation and may need to meet eligibility requirements for access to controlled or classified information.

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k, IRA)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Sick & Public Holidays)
  • Family Leave (Maternity, Paternity)
  • Short Term & Long Term Disability
  • Training & Development
  • Work From Home
  • Wellness Resources
  • Employee Bonus Programs
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Data Engineer (BigQuery)
Data Engineer (BigQuery)

Northramp LLC • Bethesda (MD)

Hybrid
USD 120,000 - 160,000
Health Care Plan (Medical, Dental &amp
401k, IRA
Life Insurance
+7
Data Architect
Data Architect

J5cyberconsulting • Maryland

On-site
USD 90,000 - 130,000
100% employer‑paid health coverage
6% 401(k) match
PTO
+3
Data Engineer
Data Engineer

Sotalent • McLean (VA)

On-site
USD 102,000 - 170,000
Health, dental, and vision insurance
401(k) with company matching
Tuition reimbursement
+2
Data Engineer
Data Engineer

Ryde Technologies, LLC • Virginia (MN)

Hybrid
USD 120,000 - 150,000
Data Engineer - BigQuery & Cloud Data Pipelines (Hybrid)
Data Engineer - BigQuery & Cloud Data Pipelines (Hybrid)

Northramp LLC • Washington

Hybrid
USD 110,000 - 160,000
Health insurance
401k retirement plan
Paid time off
Data Engineer
Data Engineer

Northstrat Incorporated • Sterling (VA)

Hybrid
USD 120,000 - 150,000
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
Google Cloud Platform (GCP) Data Engineer
Google Cloud Platform (GCP) Data Engineer

accenturefederalservices • United States

Remote
USD 120,000 - 190,000
Federal benefits package