Data Engineer (BigQuery)
Northramp LLC7 days ago
Bethesda, MD, USA +2 moreMid Level / Senior
Base Salary
$135k - $165k/yr
Responsibilities
- Design, build, and maintain scalable ELT/ETL pipelines for structured and semi-structured data from cloud services, APIs, databases, and files.
- Develop data models, schemas, and transformation logic using dbt, SQL, and Python while enforcing testing and documentation standards.
- Implement and operate pipeline orchestration with Apache Airflow, Cloud Composer, Prefect, or equivalent tools.
- Integrate data platforms with AWS RDS, Azure SQL, GCS/S3, operational databases, and third-party SaaS APIs.
- Implement BigQuery and cloud-storage access controls, column-level security, and encryption aligned with FedRAMP High and FISMA requirements.
- Maintain data cataloging, lineage metadata, governance, auditability, and data security controls.
- Collaborate with data scientists and analysts on data availability, schema stability, and analytical workload performance.
- Develop infrastructure-as-code for data platform components using Terraform and integrate data assets with CI/CD pipelines.
- Support profiling, anomaly detection, SLA monitoring, ATO documentation, retention policies, and audit logging.
Requirements
- 3–6 years of progressive hands-on data engineering experience focused 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 BigQuery experience, including familiarity with partitioning, clustering, and 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 and schema design for analytical workloads.
- Familiarity with data governance, cataloging, lineage, access controls, and retention in regulated environments.
- Knowledge of FedRAMP, FISMA, and NIST 800-53 data security requirements.
- U.S. citizenship and ability to obtain and maintain DHS suitability/Public Trust clearance.
- Eligibility to work in the United States.
- Preferred experience with dbt, Apache Airflow or Cloud Composer, streaming platforms, and federal data engineering.
- Preferred certifications include Google Cloud Professional Data Engineer, AWS Certified Data Analytics Specialty, Azure Data Engineer Associate, and Security+ or equivalent.
- Active Public Trust or higher clearance is preferred.
Benefits
- Hybrid work in the Washington, DC metro area with on-site presence at designated client locations and remote work supported around mission and security requirements.
- Health care plan covering medical, dental, and vision.
- Retirement plan including 401(k) and IRA.
- Basic, voluntary, and AD&D life insurance.
- Paid vacation, sick leave, and public holidays.
- Maternity and paternity family leave.
- Short-term and long-term disability coverage.
- Training and development opportunities.
- Wellness resources.
- Employee bonus programs.
Categories
Data Engineering
About Northramp LLC
Northramp LLC provides integrated advisory and software engineering services to modernize and run mission-critical systems for U.S. federal agencies and other mission-driven organizations. It works on ASP.NET/.NET platforms, cybersecurity, enterprise architecture, and IT service optimization, delivering projects with advisors and engineers on the same team. Founded in 2012 and headquartered in Reston, Virginia, the privately held firm focuses on federal contracts and critical infrastructure programs.