Data Engineer, BigQuery & Cloud Data Pipelines

Northramp LLC; Reston (VA); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health care

401k

Life insurance

PTO

Family leave

Disability

Training & development

Work From Home

Wellness resources

Bonus programs

Job summary

Northramp LLC in the Washington, DC metro area seeks a Data Engineer to design cloud-native data pipelines, warehousing, and integration layers that support enterprise reporting, AI/ML, and analytics across IaaS, PaaS, and SaaS environments.

You will build production-grade pipelines for BigQuery, develop data models with dbt and Python, orchestrate with Airflow, and enforce data quality, security, and governance in a FedRAMP/FISMA context.

Qualifications

• 3 to 6 years of progressive, hands-on data engineering experience with cloud data platforms.
• Strong SQL skills and hands-on BigQuery experience; knowledge of optimization techniques.
• Proficiency in Python for data engineering tasks; experience with dbt.
• Hands-on with orchestration tools: Airflow or Cloud Composer; CS/IS related degree.

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines into BigQuery and other cloud warehouses.
• Develop data models, schemas, and transformation logic with dbt, SQL, and Python.
• Implement pipeline orchestration and monitor health, SLA adherence, and failures.
• Integrate data platforms with upstream sources and SaaS APIs across clouds.
• Enforce data access controls, encryption, and governance per FedRAMP/FISMA.
• Build and maintain data cataloging and lineage for auditability.
• Collaborate with Data Scientists and analysts to ensure data availability and performance.
• Develop infrastructure-as-code with Terraform; support CI/CD for data assets.
• Support data quality profiling, anomaly detection, and alerting.
• Contribute to security controls and ATO documentation for regulated environments.

Skills

SQL

Python

dbt

Airflow

BigQuery

Cloud platforms

Data modeling

Data governance

FedRAMP/FISMA/NIST

Public Trust clearance

Education

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

Tools

dbt

Apache Airflow

Cloud Composer

BigQuery

GCS/S3

Job description

Northramp LLC in the Washington, DC metro area seeks a Data Engineer to design cloud-native data pipelines, warehousing, and integration layers that support enterprise reporting, AI/ML, and analytics across IaaS, PaaS, and SaaS environments.

You will build production-grade pipelines for BigQuery, develop data models with dbt and Python, orchestrate with Airflow, and enforce data quality, security, and governance in a FedRAMP/FISMA context.