Data Engineer — BigQuery & Cloud Data Pipelines

Northramp LLC; Bethesda (MD); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health Care Plan

401k/IRA

Life Insurance

Paid Time Off

Family Leave

Disability Insurance

Training & Development

Work From Home

Wellness Resources

Bonus Programs

Job summary

Northramp is seeking a Data Engineer 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 data accessible, reliable, and analytics-ready, with BigQuery as the primary analytical data warehouse.

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 (ingestion, transformation, pipeline scripting).
• Experience with dbt for data transformation and modeling in cloud warehouse environments.

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.

Skills

SQL

Python

Data modeling

Data quality

FedRAMP/FISMA knowledge

Cloud data platforms

Education

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, or a related field

Tools

BigQuery

dbt

Apache Airflow

Cloud Composer

Terraform

Job description

Northramp is seeking a Data Engineer 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 data accessible, reliable, and analytics-ready, with BigQuery as the primary analytical data warehouse.