Data Engineer, BigQuery

Northramp

. Design, build, and maintain scalable ELT/ETL data pipelines ingesting structured and semi-structured data into BigQuery and other cloud data warehouses.

Posted 11/6/2026full-timeUnited StatesMid-LevelSenior💰 $135,000 - $165,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining scalable ELT/ETL data pipelines, utilizing SQL and Python for data transformation, and ensuring compliance with FedRAMP and FISMA security requirements. Proficient in data governance practices, including cataloging and lineage, while collaborating effectively with data scientists and analysts.

Highest-signal resume keywords

Data EngineeringSQL ProficiencyPython ProgrammingBigQuery OptimizationData Governance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ELT/ETL Pipeline DevelopmentData ModelingSchema DesignData Transformation with dbtPipeline Orchestration with Apache AirflowTerraform Infrastructure-as-CodeData Quality FrameworksMonitoring and AlertingData Access ControlsStreaming Data Platforms

Tools & Technologies

BigQueryApache AirflowCloud ComposerAWS RDSAzure SQLGCS/S3TerraformCI/CD PipelinesData Cataloging ToolsThird-Party SaaS APIs

Certifications & Qualifications

Google Cloud Professional Data EngineerAWS Certified Data Analytics SpecialtyAzure Data Engineer AssociateSecurity+

Industry Keywords

FedRAMPFISMANIST 800-53Data GovernanceData SecurityRegulated EnvironmentsDHS SuitabilityPublic Trust ClearanceData LineageData Retention Policies

Tech Stack

Tools & technologies

AirflowApacheAWSAzureBigQueryCloudETLKafkaPythonSQLTerraform

About the role

Key responsibilities & impact

Design, build, and maintain scalable ELT/ETL data pipelines ingesting structured and semi-structured data into BigQuery and other cloud data warehouses.
Develop and manage data models, schemas, and transformation logic using dbt, 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 AWS RDS, Azure SQL, GCS/S3, operational databases, and third-party SaaS APIs.
Implement data access controls, column-level security, and encryption aligned to FedRAMP High and FISMA requirements.
Build and maintain data cataloging and lineage metadata practices for governance and auditability.
Collaborate with Data Scientists and analysts on data availability, schema stability, and analytical workload performance.
Develop and maintain Terraform infrastructure-as-code for data platform components.
Participate in CI/CD pipeline integration for data assets.
Support data quality frameworks including profiling, anomaly detection, and SLA monitoring.
Contribute to ATO documentation and data security controls including data classification, retention policies, and audit logging.

Requirements

What you’ll need

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

Benefits

Comp & perks

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