On Northramp LLC’s own careers site (Workable), last seen open yesterday.
To check: No pay range listed, though one is likely required in DC, MD, VAAsk for the pay range before you interview. The law here likely requires one.
Checked: On the company's own careers siteWorkable board
Design, build, and maintain data pipelines that ingest data from cloud services, APIs, databases, and files into BigQuery and other cloud warehouses.
Develop data models, schemas, and transformations; implement pipeline orchestration, monitoring, testing, and documentation.
Integrate data platforms with operational databases, cloud services, and third-party SaaS APIs.
Implement data security, governance, cataloging, lineage, and audit practices for regulated environments.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Licenses and certifications
Google Cloud Professional Data Engineer certification (preferred)
AWS Certified Data Analytics Specialty or Azure Data Engineer Associate certification (preferred)
Security+ or equivalent certification (preferred)
Experience
3 to 6 years of hands-on data engineering experience focused on cloud data platforms and pipeline development
Experience with dbt for data transformation and modeling in cloud warehouse environments (preferred)
Hands-on experience with Apache Airflow or Cloud Composer (preferred)
Experience with streaming data platforms such as Pub/Sub, Kafka, or Kinesis (preferred)
DHS or other federal data engineering experience (preferred)
Education
Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, or a related field; relevant experience may substitute
Skills
Strong SQL skills and hands-on experience with BigQuery as an analytical data warehouse
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 including cataloging, lineage, access controls, and retention, and their application in regulated environments
Knowledge of FedRAMP, FISMA, and NIST 800-53 data security requirements
Other requirements
U.S. citizenship and ability to obtain and maintain a DHS suitability / Public Trust clearance
Eligible to work in the United States
Based in the DC, Maryland, or Virginia region and able to meet the hybrid on-site schedule
Active Public Trust or higher clearance (preferred)
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Benefits
Health insurance
Health care plan
Dental & vision
Dental and vision coverage
Retirement plan
401(k) and IRA
Paid time off
Paid vacation, sick leave, and public holidays
Parental leave
Maternity and paternity family leave
Bonus
Employee bonus programs
Learning & tuition
Training and development
Wellness & mental health
Wellness resources
Life & disability insurance
Basic and voluntary life insurance, AD&D, and short- and long-term disability
Other
Work from home
Full job description
From Northramp LLC’s careers site
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.
Show full descriptionShow less
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.
Requirements
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.