> Markdown version of [/jobs/ext/2544990-data-engineer-lads-logistics-analytics-data-services-activ](https://www.wearedevelopers.com/jobs/ext/2544990-data-engineer-lads-logistics-analytics-data-services-activ). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer (LADS - Logistics Analytics Data Services) - Activ - **Company:** Akima - **Location:** North Charleston, SC, United States (Remote available) - **Experience:** Expert - **Salary:** $140,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, Data Analysis, Code Review, Continuous Integration, Data Architecture, Data Validation, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Relational Databases, Database Security, Dimensional Modeling, Python (Programming Language), Performance Tuning, Query Optimization, Software Engineering, SQL Databases, Data Logging, Caching, Change Data Capture, Indexer, Git, Data Lakes, Deployment Automation, Data Analytics, Software Version Control, Data Pipelines, Databricks - **Published:** August 12, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9090087/data-engineer-lads-logistics-analytics-data-services-activ ## About the Role * Current and active Secret security clearance * Bachelor's degree in CS, IT, Engineering, Math, or related field, or equivalent experience. * 8+ years' experience (Bachelor's) or 6+ years (Master's). * Strong understanding of relational database principles, indexing, transaction management, and query optimization. * Hands-on experience with SQL. * Knowledge of database security controls and encryption. * Experience in Agile/SAFe environments. Preferred Qualification: * Experience modeling data for use in Foundry (Ontologies). ## Description Five Rivers Analytics is seeking a versatile and driven Data Engineer with strong hands-on expertise in Databricks. This is a remote role based in South Carolina and the qualified candidate will be responsible for building, optimizing, and maintaining robust data pipelines, with a particular focus on reliably capturing source changes and preserving historical truth. The ideal candidate understands how to structure scalable data Lakehouse's using Delta Lake, write highly optimized SQL and Python, and implement Change Data Capture (CDC) and Slowly Changing Dimension (SCD) architectures. You will deliver secure, auditable, and high-performance data products to empower our downstream data consumers. This is in support of the Logistics Analytics Data Services (LADS) program for the Marine Corps., Data Engineering, CDC & Pipeline Development * Pipeline Orchestration: Design, build, and maintain scalable batch and streaming ETL/ELT pipelines using Python, SQL, and built-in Databricks Workflows. * Change Data Capture (CDC): Establish efficient pipelines to ingest incremental source changes (inserts, updates, and deletes) into the lakehouse using native Databricks capabilities. * Lakehouse Architecture: Implement and manage data layouts using the Medallion Architecture (Bronze, Silver, Gold layers) to clean, enrich, and optimize structured and semi-structured datasets. * Data Governance & Security: Administer schemas, catalogs, and secure access permissions using Unity Catalog to ensure strict data governance. * Performance Tuning: Optimize SQL queries, caching, indexing, and cluster configurations to reduce execution times and platform compute costs. Historical Dimensional Modeling & Cross-Functional Collaboration * SCD & History Implementation: Design and implement robust Slowly Changing Dimension (SCD) patterns and historical truth tables in Delta Lake. * Requirements & Collaboration: Work closely with dashboard developers, data analysts, and data scientists to deeply understand and capture their data requirements. * Source System Mastery: Proactively investigate and learn about various source systems to understand how they work and how data is generated and extracted. * Data Modeling: Create clean, optimized, and reusable semantic data models in Databricks SQL that serve as the "single source of truth" for the business. Data Quality & Operations * CI/CD & Git Integration: Implement software development best practices using Git integration in Databricks Repos for version control, code review, and automated deployments. * Data Quality Monitoring: Implement automated data validation, logging, and alerting systems using native Databricks data quality tools to ensure high data integrity. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [HTTP headers that make your website go faster](https://www.wearedevelopers.com/videos/1676-http-headers-that-make-your-website-go-faster) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How Gatsby Cloud's real-time streaming architecture drives <5 second builds](https://www.wearedevelopers.com/videos/418-how-gatsby-cloud-s-real-time-streaming-architecture-drives-5-second-builds) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)