Data Engineer (BigQuery)
Northramp LLC
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.
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.
Benefits
- 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
- ...computing solutions. Founded by ex-Googlers with engineers from Google, Amazon, and Capital One,... ...itself particularly in AI, data engineering, blockchain, and cloud-native... ...pipelines using Dataflow (Apache Beam), Pub/Sub, BigQuery, and Cloud Composer (Airflow) Strong background...SuggestedFull timeWork at office
- Overview VTG is seeking a skilled Data Engineer with at least 5 years of experience designing, building, and maintaining scalable data pipelines... ...with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery) Strong understanding of data modeling concepts (star/...Suggested
$130k - $170k
Dark Wolf constructs and deploys data management and analytics solutions for the defense... .... We're proud to boast a world-class engineering team that thrives on rolling up their sleeves... ...warehouses (e.g., Snowflake, Redshift, BigQuery). Deploy and manage containerized data...SuggestedFull timeFor contractors$146.04k - $318.84k
...State Applicants. POSITION SPECIFICS We are seeking a Senior Data Engineer with deep expertise in database design, optimization, and... ...and feature store architectures (e.g., Snowflake, Redshift, BigQuery, Feast) Familiarity with ETL/ELT frameworks and data orchestration...SuggestedFull timeFor contractorsWork experience placementRemote workFlexible hours- ...skilled and motivated individual to join our team as a Senior Data Engineer to align data solutions to business requirements by planning... ...platforms using technologies such as Redshift, Snowflake, BigQuery, Delta Lake, Apache Iceberg, and Apache Hudi, applying appropriate...SuggestedContract workWork at officeLocal area3 days per week
$101.66k
...Amazon, our tech isn't just a tool, it's your playground. Our engineers work on scalable systems, cloud services, and customer-facing products... ...-disciplinary staff to provide full life-cycle support to AWS Data Centers from design inception through site improvement and...Full timeSummer workInternshipRelocationMonday to Friday$90k - $200k
...a list that spans across the country.Job DescriptionCapTech Data Engineering consultants enable clients to build and maintain advanced data... ...database (PostgreSQL, MySQL, SQL server, Oracle, Aurora, Presto, BigQuery) Expertise with SQL, database design/structure and data...Work at officeRemote workVisa sponsorshipWork visaFlexible hours$90k - $200k
...a list that spans across the country.Job DescriptionCapTech Data Engineering consultants enable clients to build and maintain advanced data... ...SQL Server, PostgreSQL, Snowflake, Redshift, Aurora, Presto, BigQuery, Oracle DevOps: git, docker, subversion, Kubernetes, Jenkins...Work at officeRemote workVisa sponsorshipWork visaFlexible hours- ...We are seeking a skilled Mid-Level Data Engineer to join our team in Reston, VA and support data-driven initiatives. The Mid-Level Data Engineer will play a key role in data cleaning, basic analysis, and preparing data for visualization. This position will support...
- ...Job Title: Mid-Level Data Engineer Location: Reston, VA Work Model: 100% Onsite Employment Type: Full-Time Required Qualifications & Skills - U.S. Citizenship is mandatory. - Bachelor's degree in Information Technology, Information Science, Computer Science...Full time
- ...GENERAL DESCRIPTION: Data Scientist to own our enterprise data warehouse and turn its data into Power BI reports. This role will build... ...as PL-300 (Power BI Data Analyst) or Databricks Certified Data Engineer Associate. · Experience with version control (Git) and CI/CD...Full time
- ...skilled and motivated individual to join our team as a Senior Data Engineer to align data solutions to business requirements by planning... ...with modern data warehousing platforms (Redshift, Snowflake, BigQuery). Deep understanding of dimensional modeling (star/snowflake...Contract workWork at officeLocal area3 days per week
$150k - $175k
...Data Engineer - Senior Reston, VA, United States (On-site) Job Title: Data Engineer - Senior Job Code: ITS954 Location: Reston, VA Reports to: Program Manager FLSA Status: Exempt Supervisory: No supervisory/management authority Prepared Date...Permanent employmentContract workTemporary workFor contractorsWork at officeLocal areaFlexible hours- ...Property & Casualty, and Specialty Insurance.Position SummaryThe Data Engineering Lead is responsible for the design, development, governance,... ..., or Google Cloud)Databricks, Snowflake, Synapse, Redshift, BigQuery, or equivalent technologiesReal-time data processing and...Minimum wageFull timeWorldwide
$90k - $200k
..., and government agencies, a list that spans across the country.Job DescriptionCapTech Machine Learning Engineers are responsible for designing and implementing data-driven solutions for our clients, with a specific focus on building and deploying scalable machine learning...Work at officeRemote workVisa sponsorshipWork visaFlexible hours$108.01k - $183.61k
ICF is seeking a skilled Data Engineer to join our Corporate IT organization. You will design, build, and maintain the data infrastructure that powers insights and decision-making across our practices and support organizations. Working at the intersection of enterprise...Full timeContract workWork experience placementH1b$100.79k - $160.26k
...DLA Piper is a place you can engage in meaningful work and grow your career. Let’s see what we can achieve. Together.SummaryThe Data Engineer, Solutions & Data role designs, builds, and operates data pipelines and data integration processes that translate raw data into...Full timeWork at officeRemote workVisa sponsorship- Lead Data Engineer Mantech seeks a motivated, career and customer-oriented Lead Data Engineer to join our Enterprise Data, AI, and Automation team in Herndon, VA. This is a hybrid position, requiring 2-3 days a week onsite. In this pivotal role, you will bridge the gap...Work at office2 days per week3 days per week
- ...Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified...Worldwide
$260k
...activities like fraud, money laundering, and terrorist financing through digital asset tracing. They are seeking a Forward Deployed Data Engineer to work directly with government customers to take their SaaS products from initial setup and implementation to configuration...Remote workFlexible hours- ...Data Engineer Location: Herndon, VA Preferred: US Citizen Job Description Node is currently seeking a motivated, career and customer-oriented Senior Data Engineer /Data Architect to begin an exciting and challenging career with our large Enterprise Application...Full time
- OverviewLMI is seeking a Senior Data Engineer to support our Intelligence Community client. LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed. Investing in technology and prototypes ahead of need, LMI...Contract work
- Title: Data Engineer Location: Reston, VA or Bethesda, MD Clearance: TS/SCI w/CI polygraph Description: Invictus, a Red River company, delivers technology and services supporting government and national security missions. We combine cleared mission expertise with enterprise...Contract workFor contractorsWork at office
- Location: Herndon, Virginia Type: Contract Job #4009 Title: Data Engineer Location: Herndon, Virginia *Clearance: *Active TS/SCI w/ Polygraph needed to apply * Company Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities...Contract work
$120k - $225k
Data Engineer Absolute Business Solutions Corp (ABSC) is a community of innovators, engineers, analysts, and business professionals working with customers to tackle complex challenges. For more than 20 years, we have supported critical DoD, Intelligence Community, and Federal...- About Infinitive Infinitive is a data and AI consultancy that helps clients modernize,... ...Role We are seeking an experienced Data Engineer to help design, build, and scale our next... ...warehouses / Lakehouse (e.g., Snowflake, BigQuery, Databricks, Redshift). Reliability & Data...Contract workLocal area
$185k - $240k
Dark Wolf constructs and deploys data management and analytics solutions for the defense and intelligence communities. We're proud to boast a world-class engineering team that thrives on rolling up their sleeves to solve your mission's biggest challenges. Dark Wolf is...Full timeFor contractors- ...Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Data Engineer Location: Reston, VA. Job Description: The Senior Data Engineer is responsible for orchestrating, deploying, maintaining and...Work experience placement
- 4464 Data Engineer 4464 | Top Secret Job Description: OVERVIEW: We are seeking a Cyber Data & Telemetry Engineer to build and scale our next-generation security data pipelines. You will design real-time streaming architectures, normalize critical security schemas, and...
- Data Engineer Insight Xcite is recruiting Data Engineers for current and upcoming mission-focused opportunities. Build reliable paths from raw data to the people and systems that need it. Work may include integrating diverse sources, transforming structured and unstructured...Full timeTemporary workImmediate startRemote workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Engineer (BigQuery). Be the first to apply!
- junior data engineer remote Reston, VA
- data engineer analytics Reston, VA
- data science developer Reston, VA
- big data developer Reston, VA
- big data devops engineer Reston, VA
- data center engineer Reston, VA
- big data cloud engineer Reston, VA
- big data engineer Reston, VA
- junior big data engineer Reston, VA
- remote data engineer Reston, VA






